syntax error

[TempAcct]

I have created an asp page that takes down customer info. What I am trying to do is read from my database and compare a field to an html variable. Here is the code that I am using

sqlstring = "SELECT * from (table) WHERE (field)=" &(variable)

I recieve the following error:

"You have an error in your SQL syntax"
and it says that it is near the closing parenthesis.
is there a way around this? Or is my syntax just wrong. Any help would be great!

 

[lodestar]

As your HTML variable is a string you need to enclose it with single quotes:

sqlstring = "SELECT * from (table) WHERE (field)='" &(variable) & "'"