ASP,SQL help 1

[Guest_imported]

Is it possible to to have conditions based on a query? I have a form where the user can select multiple search criteria. Some of the crieria if selected will clash with other criteria selected. Can I have a statement that will say if one field is selected then these other variables will have different values? I appreciate any help.

 

[rbauerle]

Yes you can.
Look:

var1=request("var1&quot
var2=request("var2&quot

if var1<>&quot;&quot; then
var2=&quot;other_value&quot;
end if

SQL=&quot;SELECT * FROM table WHERE colum1=&quot; & var1 & &quot; AND colum2=&quot; & var2
...