Re: cf query::

[KChapman]

<cfquery datasource="#odbc#" name="getcategoryData">
SELECT *
from Items
WHERE Category LIKE '%#categoryVar#%'
AND (sub1 LIKE '%#url.sub1#%'
OR sub2 LIKE '%#url.sub1#%')
</cfquery>

Should Work.

--K

====================
Katrina Chapman
Consultant
Ameriquest Mortgage


                                                                                       
                                         
                    "Chip                                                              
                                         
                    Sigourney"           To:     "Cf-Talk@Houseoffusion. Com" 
<[EMAIL PROTECTED]>                       
                    <gators1@fgi.        cc:                                           
                                         
                    net>                 Subject:     cf query::                       
                                         
                                                                                       
                                         
                    07/11/00                                                           
                                         
                    01:51 PM                                                           
                                         
                    Please                                                             
                                         
                    respond to                                                         
                                         
                    cf-talk                                                            
                                         
                                                                                       
                                         
                                                                                       
                                         



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/cf-talk@houseoffusion.com/
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.




------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
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.