I'm working on this autocomplete script using AJAX in conjunction with Classic ASP which is not my idea. I have the following javascript:
function showCustomer(str)
{
// remove white space from the name entered on the search screen
str = str.replace(" ", "");
var xmlhttp;
if (str=="")
{
document.getElementById("txtHint").innerHTML="No records found";
return;
}
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById("txtHint").innerHTML=xmlhttp.responseText;
}
}
xmlhttp.open("GET","get_customer.asp?q="+str,true);
xmlhttp.send();
}
My ASP code is as follows:
<%
response.expires=-1
dim name
name = request.querystring("q")
sql="SELECT person.id, person.forename, person.surname, person.postid, person.extension, person.internal_extension, person.mobile, person.room_number, job.id, job.postname FROM staff INNER JOIN posts ON job.id = person.postid WHERE (person.forename & person.surname like '%" & name & "%') or job.postname like '%" & name & "%'"
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open("C:\dirplus\database.mdb")
set rs=Server.CreateObject("ADODB.recordset")
rs.Open sql,conn
response.write("<table>")
response.write("<thead>")
response.write("<tr>")
response.write("<th>Forename</th>")
response.write("<th>Surname</th>")
response.write("<th>Extension</th>")
response.write("<th>Internal Ext.</th>")
response.write("<th>Mobile</th>")
response.write("<th>Room No.</th>")
response.write("<th></th>")
response.write("</tr>")
response.write("</thead>")
response.write("<tbody>")
Do While Not rs.EOF
response.write("<tr>")
response.write("<td>" & rs("forename") & "</td>")
response.write("<td>" & rs("surname") & "</td>")
response.write("<td>" & rs("extension") & "</td>")
response.write("<td>" & rs("internal_extension") & "</td>")
response.write("<td>" & rs("mobile") & "</td>")
response.write("<td>" & rs("room_number") & "</td>")
response.write("<td>" & rs("post_id") & "</td>")
response.write("<td>" & rs("postname") & "</td>")
response.write("<td><a href='index.asp?View=StaffRecord&StaffID=" & rs("id") & "'>Record</a></td>")
response.write("</tr>")
rs.MoveNext
loop
response.write("</tbody>")
response.write("</table>")
%>
Problem I'm having is that it doesn't work. When I just use a standard form to return the results (via POST or GET) it works fine and when I am just returning the results from the one table it works, but it doesn;t seem to be returning any results with this query
