[thelist] More ASP/database (almost there)...

[Beau Hartshorne]

> the best way is to let the database do all the work
> 
>  select  category, subcat
>    from tableA, tableB
>   where tableB.categoryID = tableA.categoryID
>  order by category, subcat
> 
> not sure how you handle the groups using ASP code, but in cold fusion it
> would look like this --
> 
>  <cfoutput query="q" group="category">
>    <p>Category: #category#
>    <cfoutput>
>    <br />Subcat: #subcat#
>    </cfoutput>
>    </p>
>  </cfoutput>
> 
> the category prints only once and its subcats print under it

Does anyone have any idea how to do something like this with asp?

Thanks,

Beau