When I enter data into my access db through the gui, my SQL Query
recognizes the data it is looking for and returns the result. ie I
enter "Dog" through the Access GUI and when my SQL query asks for
"Dog" it returns all the records with "Dog" in it.
The problem is if I enter "Dog" through my ASP web interface to
exactly the same database, I can see "Dog" in the table through the
gui, however when I run the SQL query, it only returns records with
"Dog" that were entered directly in through the Access GUI.
rs("BreakfastIncl") = BreakfastInclInput
rs("ConfCenter") = ConfCenterInput
rs("ConfCenterDescription") = ConfCentDescInput
rs("Distances") = DistancesInput
rs("File Name") = fileName
rs("File Size") = fileSize
rs("File Data").AppendChunk fileData
rs("Content Type") = contentType
rs("Subject")=nameInput
rs.Update
rs.Close
Set rs = Nothing
SQL Query = 'strSQL = "SELECT * FROM BIBS WHERE Suburb ='" &
Request.QueryString("link") & "' ORDER BY ID DESC"'
I am doing an rs.update - I can see the web entered "Dog" through the
gui - but the SQL query or the following line just does not see it.
If UCase(Trim(CStr(oRset("Suburb"))))=UCase(Trim(CStr (Request.QueryString("link"))))
then .....
I am very perplexed. Thanks
John
