Multiple Search

[MetroToday]

Hi guys,

I have two parts to implement in my ASP. First of all I have a search page where there are 10 text boxes. In a nutshell I want to enable to user to search from any one of these text fields. So its a OR clause in the SQL part. The more fields the user fills in, the more accurate the results are going to be.

What I am having trouble is with the implementation part. Any ideas to get me started would be very welcome.

Thanks.

 

[GabeC]

Loop through your input boxes in your asp code.

dim sSQL
sSQL = "Select * From mytable Where "
dim sWhereClause
If len(request("box1")) > 0 then
  sWhereClause = "dbField = " & request("box1")
end if

if len(request("box2")) > 0 then
 if len(sWhereClause) > 0 then
   sWhereClause = sWhereClause & " OR dbField = " & request("box2")
 else
   sWhereClause = "dbField = " & request("box2")
 end if
... the rest of your text boxes here

dim sFullSQL
sFullSQL = sSQL & sWhereClause

end if
Thanks,

Gabe