Ignore variables if blank

[Guest_imported]

Hi,

On my website I have a search form with 8 checkboxes, corresponding with 8 y/n fields in my database. How should my sql statement look if I only want to use the checkboxes that are checked by the visitor? In other words, how can I tell my asp page to ignore the checkboxes that weren't checked?

Thank you;
koenraad.
koenraad_deroo@email.com

 

[mbaranski]

Well, this is not SQL, but an asp question. But to do it, for cbox1, the logic would be:

if(cbox1.yes){
//Code...
}else if(cbox1.no){
//Code...
}
else{}//Nothing

Disclaimer:
Beware: Studies have shown that research causes cancer in lab rats.