How to show category then all products in category for each category

[rosemary slack]

I am trying to show a category, for example shoes and then show all the shoes in that category and then show the next category and all the products in that category and so on. I am able to show all the products but the category part I can't think of how to do.
I have this so far displaying the products:

<CFLOOP QUERY="Prods" STARTROW="#URL.Start#" ENDROW="#Variables.EndRow#">
    <cf_RecurseCategories 
        id="#qProds.CategoryID#"
        divider=""
        output="Text">
    <CFQUERY NAME="qSaleProds" DBTYPE="query">
        SELECT * FROM qSaleProducts
 
    </CFQUERY>
<A HREF="link.cfm"><IMG SRC="product_photos/thumbnails/#URLEncodedFormat(Prods.Image_Thumb)#" WIDTH="140" ALT="#HTMLEditFormat(Prods.ProductName)#" BORDER="0"><BR>
        <font class="productName">#Prods.manufacturer#<br>#Prods.ProductName#</font><BR>
        <CFIF SaleProds.SalePrice gt 0 AND SaleProds.SalePrice lt qSaleProds.RetailPrice>
            <B CLASS="RedText">ON SALE:</B> <B><font class="productName">#DollarFormat(SaleProds.SalePrice)#</font></B>
            <br><font class="productpricestrike">#DollarFormat(Prods.RetailPrice)#</font>
        <CFELSE>
            <font class="productName">#DollarFormat(Prods.RetailPrice)#</font>
        </CFIF>
        </A>

[acoder]

I would imagine there would be a foreign key in the products table, so add a WHERE clause to filter by CategoryID, e.g.

SELECT * FROM qSaleProducts
WHERE CategoryID = #qProds.CategoryID#