Im using asp and sql server for a web page
I've got a simple recordset:
I want to display the data in a series of select lists based on itemcategory. I could pull a different recordset for each category, but that seems way clunky.
How can I pull one recordset and distribute to the appropriate select lists? The selects should be built dynamically so one category, one select list. 8 (or whatever)categories, 8 select lists.