variables in SQL query

[mortkc]

Can I use a variable instead of a value from the database?

Here is my example: "SELECT * FROM Customers WHERE CustomerID = 'Smith'"

Can I replace Smith with the value from a variable that was passed from a user input?

Thanks

 

[gmagerr]

Yes i think so. It would be something like this
 "SELECT * FROM Customers WHERE CustomerID = " & Request.Form("TheInput&quot
something like that, i'm sorry i'm not at my computer to test it. someone will correct me if i'm wrong though

 

[mortkc]

Thanks for your response. I tried this, but get the following error:

Error Type:
Microsoft JET Database Engine (0x80040E10)
No value given for one or more required parameters.

My line read as follows:

"SELECT * FROM CUSTOMERS WHERE CUSTOMERID ="&Request.Form("searchtext&quot

 

[GaryC123]

Needs to be like this

sql="SELECT * FROM CUSTOMERS WHERE CUSTOMERID ='" & Request.Form("searchtext&quot & "'"

http://www.intouch-media.co.uk

 

[mortkc]

Perfect! I had left out the '. Thanks for your help