Go Back   TechArena Community > Software > Software Development
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Reply
 
Thread Tools Search this Thread
  #1  
Old 14-01-2009
Member
 
Join Date: Oct 2008
Posts: 35
AJAX does not work

I was going to test this with AJAX and found a complete written solution to the network. A solution that at first look would solve my problems.

After a month or so I tested it locally on my computer (XP with IIS ).... it did not work. I uploaded the same patterns on a webserver .... did not work either. Are any of the server or in my computer in the form of additional or setting to XML / AJAX to work ?????? Or is it something I am doing wrong? Is not quite familiar in this with AJAX ... yet.

The first page looks like this:
Code:
<html> <head> <script language="javascript"> var xmlHttpfunction showCustomer(str) { xmlHttp=GetXmlHttpObject(); if (xmlHttp==null) { alert ("Your browser does not support AJAX!"); return; } var url="getdatum_xml.asp"; url=url+"?q="+str; url=url+"&sid="+Math.random(); xmlHttp.onreadystatechange=stateChanged; xmlHttp.open("GET",url,true); xmlHttp.send(null); }function stateChanged() { if (xmlHttp.readyState==4) { var xmlDoc=xmlHttp.responseXML.documentElement; document.getElementById("Lopp").innerHTML= xmlDoc.getElementsByTagName("Lopp")[0].childNodes[0].nodeVal 
 ue; document.getElementById("Datum").innerHTML= xmlDoc.getElementsByTagName("Datum")[0].childNodes[0].nodeVa 
 lue; } } function GetXmlHttpObject() { var xmlHttp=null; try { // Firefox, Opera 8.0+, Safari xmlHttp=new XMLHttpRequest(); } catch (e) { // Internet Explorer try { xmlHttp=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { xmlHttp=new ActiveXObject("Microsoft.XMLHTTP"); } } return xmlHttp; } </script> </head> <body> <% Set Connection = Server.CreateObject("ADODB.Connection") Connection.Open "driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("DATABAS.mdb") SQLStmt = "SELECT * FROM TABELL1 ORDER BY Datum" Set RS = Connection.Execute(SQLStmt) %> <form action=""> V?lj datum: <select name="customers" onchange="showCustomer(this.value)"> <option value="">--- V?lj datum ---</option> <%Do Until RS.EOF%> <option value="<%=RS("Datum")%>"><%=RS("Datum")%>< 
 /option> <% RS.MoveNext Loop RS.Close Connection.Close %> </select> </form> <b> <span id="companyname"></span></b><br /> <span id="contactname"></span><br /> </html>
getdatum_xml.asp looks like this:
Code:
<% response.expires=-1 response.contenttype="text/xml"sql="SELECT * FROM TABELL2 " sql=sql & " WHERE Datum='"&request.querystring("q")&"'" on error resume next set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0" conn.Open(Server.Mappath("DATABAS.mdb")) set rs=Server.CreateObject("ADODB.recordset") rs.Open sql, connif err <> 0 then response.write(err.description) set rs=nothing set conn=nothing else response.write("<?xml version='1.0' encoding='ISO-8859-1'?>") response.write("<company>") response.write("<Datum>" &rs.fields("Datum")& "</Datum>") response.write("<Lopp>" &rs.fields("Lopp")& "</Lopp>") response.write("</company>") end if on error goto 0 %>
What is wrong? Is it the server or the code?
Reply With Quote
  #2  
Old 14-01-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: AJAX does not work

The easiest way is if you are troubleshooting.
Run getdatum_xml.asp alone. Does it go to the JavaScript.
See if you can answer when the other file called by printing a alert.

Troubleshooting 101, simply.

Among others, I found a flaw in this line:
Code:
 s.Open sql, connif err <> 0 then
You know what to do
Reply With Quote
  #3  
Old 14-01-2009
Member
 
Join Date: Oct 2008
Posts: 35
Re: AJAX does not work

Have run getdatum_xml.asp alone, and it seems (in my eyes anyway) that that part works. What I am less sure of is whether JavaScript faults .. ie if the sending of value and if it takes the results from the ASP page.

Where in the script, it is appropriate to add an alert?

Code:
<html> <head> <script language="javascript"> var xmlHttpfunction showDatum(str) { xmlHttp=GetXmlHttpObject(); if (xmlHttp==null) { alert ("Your browser does not support AJAX!"); return; } var url="getlopp.asp"; url=url+"?Datum="+str; url=url+"&sid="+Math.random(); xmlHttp.onreadystatechange=stateChanged; xmlHttp.open("GET",url,true); xmlHttp.send(null); }function stateChanged() { if (xmlHttp.readyState==4) { var xmlDoc=xmlHttp.responseXML.documentElement; document.getElementById("Loppen").innerHTML= xmlDoc.getElementsByTagName("Lopp")[0].childNodes[0].nodeVal 
 ue; document.getElementById("Datumen").innerHTML= xmlDoc.getElementsByTagName("Datum")[0].childNodes[0].nodeVa 
 lue; } } function GetXmlHttpObject() { var xmlHttp=null; try { // Firefox, Opera 8.0+, Safari xmlHttp=new XMLHttpRequest(); } catch (e) { // Internet Explorer try { xmlHttp=new ActiveXObject("Msxml2.XMLHTTP"); } catch (e) { xmlHttp=new ActiveXObject("Microsoft.XMLHTTP"); } } return xmlHttp; } </script> </head> <body> <% Set Connection = Server.CreateObject("ADODB.Connection") Connection.Open "driver={Microsoft Access Driver (*.mdb)};DBQ=" & server.mappath("..\..\Db\DATABAS.mdb") SQLStmt = "SELECT * FROM TABELL1 ORDER BY Datum" Set RS = Connection.Execute(SQLStmt) %> <form action=""> V?lj datum: <select name="Datum" onchange="showDatum(this.value)"> <option value="">--- V?lj datum ---</option> <%Do Until RS.EOF%> <option value="<%=RS("Datum")%>"><%=RS("Datum")%>< 
 /option> <% RS.MoveNext Loop RS.Close Connection.Close %> </select> </form> <HR> <span id="Loppen"></span></b><br /> <span id="Datumen"></span><br /> </html>
Reply With Quote
  #4  
Old 14-01-2009
Member
 
Join Date: May 2008
Posts: 2,008
Re: AJAX does not work

I can now find more serious errors in the javascript code.
There are line breaks, which makes available to it. Look like the javascript errors that arise. If you get no errors, you have probably just not set in the browser that will warn the javascript errors.


was xmlHttpfunction showdate(str) <--- FEEEL


was XMLHTTP; //new line here
function show Date (str)
Reply With Quote
  #5  
Old 14-01-2009
Member
 
Join Date: Oct 2008
Posts: 35
Re: AJAX does not work

Ahhhh, you are an angel. Now came the JavaScript running anyway. Fixed now grappling I followed the wrong .... I will return soon
Reply With Quote
Reply

  TechArena Community > Software > Software Development
Tags:



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "AJAX does not work"
Thread Thread Starter Forum Replies Last Post
what is ajax? carmelmonteverdeinn Software Development 1 28-07-2010 11:34 AM
jQuery AJAX vs. Adobe AIR AJAX Class Agaev Windows Software 5 06-07-2010 01:59 PM
PHP Vs AJAX Happy46 Software Development 3 03-09-2009 07:27 PM
AJAX does not work in Internet Explorer HP_Crook Software Development 4 18-07-2009 04:27 PM
What is AJAX in Asp.net ? Braze Software Development 5 14-01-2009 06:35 PM


All times are GMT +5.5. The time now is 08:40 PM.