Topic awaiting preservation: SQL problem ( ASP ) (Page 1 of 1)

Hi, guys. How are you?
I am having SQL problem. Please help me.

If Not IsEmpty(Request("state")) Then

	 

	 sql = sql & " WHERE Tblstate.Colstate =" Request("state")""

	

	End If

I have an existing sql before this code. I want to add more sql statement using above code. But doesnot work.
Actually I want to swap value according to user choice from form. Then I want to pass user choice to sql statement.
Do you know what I mean???
Help.

Hiroki Kozai

sql = sql & " Where Tblstate.Colstate = '" & Request("state") & "'"

I enclosed the request value in single quotes because I assumed it will be a string. If not, remove the single quotes.

Thank you very much.
It works perfectly.
Cheers.

Hiroki Kozai