My problem is that it doesn't narrow down the products at all because it is
only passing the category and
the sub1. I need it to pass the category, the sub1 and the sub2 and then the
Query on Cat2.cfm needs to select only those products. Do you know how I can
do that?
<cfquery datasource="#odbc#" name="getcategoryData">
SELECT * from Items WHERE Category LIKE '%#categoryVar#%' AND sub1 LIKE
'%#url.sub1#%' or Category LIKE '%#categoryVar#%' AND sub2 LIKE
'%#url.sub1#%'
</cfquery>
thanks
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
