I posted this in the database forum also.

I'm creating a classified ad site which is categorized. The problem I'm having is with my results page. I can only generate records for one category. How will the search page differentiate between the different categories with one recordset? Using DWMX with Coldfusion. Any help will be appreciated. Thanks.