Multiple query with checkboxes

<i><b>Originally posted by : Angela (agriener@bluewin.ch)</b></i><br />I would like to create a search form in ASP with about twelve checkboxes, each of which correspond to a value of the column "Category" in my Access 2000 database. I would then like to group the results by each of the chosen categories.<br />I would really appreciate any help you can give me.<br />Thanks<br /><br />

<i><b>Originally posted by : steve </b></i><br />you would 1st have to loop throught to find out if the checkboxes where selected. then based on that build your sql string to be passed onto the database<br /><br />http://www.aspfree.com/authors/adrian/MultipleCheckboxes.asp has a demo on how to detect if multiple checkboxes are checked or not<br /><br />http://www.aspfree.com/asp/searchcode.asp has a dynamic search page.<br /><br /><br />------------<br />Angela at 3/28/2000 3:30:36 PM<br /><br />I would like to create a search form in ASP with about twelve checkboxes, each of which correspond to a value of the column "Category" in my Access 2000 database. I would then like to group the results by each of the chosen categories.<br />I would really appreciate any help you can give me.<br />Thanks<br /><br />

<i><b>Originally posted by : Angela (agriener@bluewin.ch)</b></i><br />Thanks. But I am having a problem building the sql string. How do I do this?<br /><br /><br />------------<br />steve at 3/29/2000 10:18:53 AM<br /><br />you would 1st have to loop throught to find out if the checkboxes where selected. then based on that build your sql string to be passed onto the database<br /><br />http://www.aspfree.com/authors/adrian/MultipleCheckboxes.asp has a demo on how to detect if multiple checkboxes are checked or not<br /><br />http://www.aspfree.com/asp/searchcode.asp has a dynamic search page.<br /><br /><br />------------<br />Angela at 3/28/2000 3:30:36 PM<br /><br />I would like to create a search form in ASP with about twelve checkboxes, each of which correspond to a value of the column "Category" in my Access 2000 database. I would then like to group the results by each of the chosen categories.<br />I would really appreciate any help you can give me.<br />Thanks<br /><br />