Untitled

<html>
<head>
<cfquery datasource="Super972" name="getCat">
    SELECT DISTINCT category
    FROM Products
</cfquery>
<cfoutput>
    Product Search Results, all category #category# products
</cfoutput>
<cfoutput>
        <cfform name="SearchForm" action="prodSearchEnhanced.cfm">
            <cfselect name="CategorySearch"
                query="getCat"
                value="category"
                display="category"
                required="Yes"
                size="8">
            </cfselect>
    </ br><input type="Submit" value="Search">
        </cfform>
</cfoutput>
                </td>
            </tr>
    </table>
</head>
</html>