Need Help with Webpage Query

[RussOSU]

I am wanting to create a web based query of a database. I have 4 fields which I want to query from. I know I need to use an Ifnull/then statement so I can search by the field specified by the user. Where I am running into trouble is in the list box. I am not sure with .asp pages how to script this. I know a little vbs and very little js. Could someone help push me in the right direction.

Thanks

Russ

 

[smartFly]

You could do this on the results page:

var1 = request.form("var1&quot
if var1 = "" then var1 = "%" end if

strSQL = "select * from table where var1 = '" & var1 & "';"

This would replace var1 with a wildcard if using textfields and the user left them blank. For drop-downs I always give the user the option to query against ALL records in that field:

<option selected value=&quot;%&quot;>---ALL---</option>