Data entered through Web not recognized - help

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • John

    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("BreakfastIn cl") = BreakfastInclIn put
    rs("ConfCenter" ) = ConfCenterInput
    rs("ConfCenterD escription") = ConfCentDescInp ut
    rs("Distances" ) = DistancesInput
    rs("File Name") = fileName
    rs("File Size") = fileSize
    rs("File Data").AppendCh unk fileData
    rs("Content Type") = contentType

    rs("Subject")=n ameInput
    rs.Update

    rs.Close
    Set rs = Nothing

    SQL Query = 'strSQL = "SELECT * FROM BIBS WHERE Suburb ='" &
    Request.QuerySt ring("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.Q ueryString("lin k"))))
    then .....

    I am very perplexed. Thanks
    John
Working...