Well I ported the search code to asp as the server is windows based and also
now also use SQL to hold the data as per the ideas from last week but I have
a problem.
I can run search.asp?q=ABC or search.php?q=ABC and both will output what
appears to be the same even down to the byte count. but when I make a change
in the HTML file so it uses the asp version of the search code it will only
ever returns 1 record. But yet when I run search.asp?q=ABC it will out put
XX amount records just like the php version.
Here is the ASP code.
<%
Dim ServerName
Dim DBName
Dim DBUserName
Dim DBPassword
Dim lConnectionobj
Dim lconnectionString
Dim Q
Q = Request.QueryString("q")
ServerName = "server"
DBName = "database"
DBUserName = "user"
DBPassword = "password"
if Q = "" then
response.write "No QueryString Found"
response.end
end if
Set lConnectionobj = Server.CreateObject("ADODB.Connection")
lconnectionString = "Provider=SQLOLEDB;Data Source=" & ServerName & ";User
ID= " & DBUserName & _
";Password= " & DBPassword & ";persist security info=False;Initial
Catalog= " & DBName
lConnectionobj.open lconnectionString
Dim SQLString
SQLString = "SELECT LOC + '|' as LOC FROM Suburbs WHERE LOC LIKE '%" & q &
"%'"
DIM objRS
Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.Open SQLString, lConnectionobj,adOpenDynamic
while not objRS.EOF
Response.Write trim(objRS.Fields("LOC")) & chr(13)
objRS.Movenext
wend
lConnectionobj.close
%>
Here is the output from search.php
Chinatown NSW 2000|
Church Hill NSW 2000|
Circular Quay NSW 2000|
Here is the output from search.asp
Chinatown NSW 2000|
Church Hill NSW 2000|
Circular Quay NSW 2000|
Here is the copy of the php code where I had entered all the towns in
an array (I have not listed all 30k of them)
<?php
$q = strtolower($_GET["q"]);
if (!$q) return;
$items = array(
"Chinatown NSW 2000",
"Church Hill NSW 2000",
"Circular Quay NSW 2000"
);
foreach ($items as $value) {
if (strpos(strtolower($value), $q) !== false) {
echo "$value|\n";
}
}
?>
The html I was changing was
$("#suggest2").autocomplete("search.php", {
to
$("#suggest2").autocomplete("search.asp", {
Any ideas why when I use a ASP version of the search back end it will
only return 1 record (doing a http sniff shows that it is returning
all of the records
but for some reason the javascript only displays 1 record)
Regards
James
