DaniWeb Forum Index > Web Development > ASP

HELP:: Simple Search Box in ASP.

Please support our ASP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Feb 2009

Posts: 16

Reputation: dhavalcoholic is an unknown quantity at this point

Solved Threads: 0

dhavalcoholic dhavalcoholic is offline

Offline

Newbie Poster

HELP:: Simple Search Box in ASP.

Sep 20th, 2009

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.

 Help with Code Tags 
 ASP Syntax (Toggle Plain Text) 
<%
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
%>
<%
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!

•

Join Date: Jun 2009

Posts: 23

Reputation: chsab420 is an unknown quantity at this point

Solved Threads: 5

chsab420

Offline

Newbie Poster

Re: HELP:: Simple Search Box in ASP.

Sep 28th, 2009

i dont see anything wrong

can u post html as well

•

Join Date: Feb 2009

Posts: 16

Reputation: dhavalcoholic is an unknown quantity at this point

Solved Threads: 0

dhavalcoholic dhavalcoholic is offline

Offline

Newbie Poster

Re: HELP:: Simple Search Box in ASP.

Sep 28th, 2009

@ 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.