WHERE TUserInfo.LName =3D'" & Request.Form("Searchvalue") & "'"
notice the extra single quote around the variable. If this does not work,
print your SQL and then run it in SQL Plus or similar and see what happens.
At 14:36 15/08/01 -0700, you wrote:
>I am trying to implement a search page so a user can search the database
>based on certain criteria. So far everything works except one
>thing. When I search the database it gives me all the records in the RS
>instead of those in the WHERE Clause:
> "WHERE TUserInfo.LName =3D" & Request.Form("Searchvalue") & _
>The Last Name is in the TUserInfo table and I'm trying to compare it to
>the value that the user would enter in the form. The name for the text
>box is Searchvalue. Everytime I try this I get an error:
>"No value given for one or more required parameters"
>I checked to make sure the information was still in the dbase, and it was.
>Any help would be appreciated