using LIKE in query of queries

hi guys, can anyone see anything wrong with the following query format... cfquery dbtype=query SELECT * FROM qGetAllProducts WHERE ( (product_title LIKE '%table%') OR (product_description LIKE '%table%') OR (cat_title LIKE '%table%') OR (artist_fname LIKE '%table%') OR (artist_lname LIKE

RE: using LIKE in query of queries

Does the product have a product_title of 'Table' or 'table'? I haven't checked in a while, but it might be case-sensitive. ::-Original Message- ::From: Mike Little [mailto:[EMAIL PROTECTED] ::Sent: Sunday, April 06, 2008 12:23 AM ::To: CF-Talk ::Subject: using LIKE in query of queries

Re: using LIKE in query of queries

: using LIKE in query of queries :: ::hi guys, :: ::can anyone see anything wrong with the following query format... :: ::cfquery dbtype=query ::SELECT * ::FROM qGetAllProducts ::WHERE ( ::(product_title LIKE '%table%') ::OR (product_description LIKE '%table%') ::OR (cat_title LIKE '%table

Re: using LIKE in query of queries

Try the lower() function - that might work in the QoQ. On Sun, Apr 6, 2008 at 3:41 PM, Mike Little [EMAIL PROTECTED] wrote: hey william, you are right. it does appear to be case sensitive. darn. Does the product have a product_title of 'Table' or 'table'? I haven't checked in a while,

Re: using LIKE in query of queries

thanks james and william, got it sorted. Try the lower() function - that might work in the QoQ. On Sun, Apr 6, 2008 at 3:41 PM, Mike Little [EMAIL PROTECTED] wrote: hey william, you are right. it does appear to be case sensitive. darn. Does the product have a product_title of 'Table' or