469,602 Members | 2,108 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,602 developers. It's quick & easy.

Data entered through Web not recognized - help

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
Nov 12 '05 #1
0 1018

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by osp | last post: by
reply views Thread by guiromero | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.