[thelist] ASP/SQL Question

[rudy]

> Each Product Type requires a seperate query

aaargh

please, above all, your first consideration in any 
web database application is to reduce the number
of times the web server calls the database server

the optimum number would be one 

> Secondly, would there be some strange, obscure, 
> or just overlooked (on my part) SQL trick which 
> would reduce the queries needed?

just do a simple join query from products to categories
(write back if you need help)


as for processing the output, this is a very simple matter
if you have any programming experience

at its simplest, you need to make just one pass of the
returned records in the result set, check the current
record against the previous, and do end-of-group
and initialize-group processing conditionally

if you want to use data shaping, be my guest


rudy