HELP:: Simple Search Box in ASP.

[dhavalcoholic]

Hello friends,

I am trying to make a simple search box in ASP.

I am using a text box, where the user enters his query. And besides it, I am using drop down menu (<select>.. <option>.. </select>) in which the user selects what he want to search (Song name, Artist, Album name, etc).

I am using the following code.

<%
Var = request.Form("sel")
Query = request.Form("query")
sql="Select Title, Artist, Link from Songs where " & Var &" = '" & Query & "'"
response.write(sql)
rs.Open sql, conn
%>

I am getting the following error:

Syntax error (missing operator) in query expression '= '''.

Can any one help me remove it?

Thanks! :)

[chsab420]

i dont see anything wrong :(
can u post html as well

[dhavalcoholic]

@ chsab420

Hello...

Thanks a lot for your reply..

I debugged it by using "If condition"

So if variable is blank....... the sql query is not executed.. !! :)

Have a good day. :)