That was a Fast and SWEET adjustment. ;-> Thank You
http://www.yippykia.com Camilo Trevino Senior Web Developer 949-646-1890 2445 Elden Ave Suite L Costa Mesa, CA 92627 -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Rod Buchan Sent: Wednesday, June 04, 2003 5:08 PM To: [EMAIL PROTECTED] You should use single quotes instead of double quotes (I didn't test anything - just using my brain so this may be wrong) SELECT Products.ID, Products.Name, Products.Category, ProductSKUs.UnitPrice FROM Products INNER JOIN ProductSKUs ON Products.ID = ProductSKUs.ItemID WHERE (([Category]='Out Door Essentials')) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Camilo Trevino Sent: Thursday, 5 June 2003 9:30 To: [EMAIL PROTECTED] Subject: [CFCDev] Problem with a query Hello Guys I have this monster of a query, works like a champ in Access 2000, but will not in CFMX. What is wrong with this puppy? SELECT Products.ID, Products.Name, Products.Category, ProductSKUs.UnitPrice FROM Products INNER JOIN ProductSKUs ON Products.ID = ProductSKUs.ItemID WHERE (([Category]="Out Door Essentials")) Thank You http://www.yippykia.com Camilo Trevino Senior Web Developer 949-646-1890 2445 Elden Ave Suite L Costa Mesa, CA 92627 ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com). ---------------------------------------------------------- You are subscribed to cfcdev. To unsubscribe, send an email to [EMAIL PROTECTED] with the word 'unsubscribe cfcdev' in the message of the email. CFCDev is run by CFCZone (www.cfczone.org) and supported by Mindtool, Corporation (www.mindtool.com).
