> They must be single-quotes. (guess you weren't paying attn in SQL 101 ;) > J/K of course.
I dont think i mentioned Oracle or any DB for that matter :) Different DB's have variations in SQL.. T-SQL for MS-SQL , PL-SQL for Oracle etc. Access you can use double quotes... > > All String(char/varchar) fields in the query should have single/double > > quotes. Perhaps you didnt read "single/double" :) Joe Eugene > -----Original Message----- > From: Ruggiero, Kevin D [mailto:[EMAIL PROTECTED] > Sent: Wednesday, April 02, 2003 6:15 PM > To: CF-Talk > Subject: RE: Learned something today (Oracle) > > > > > All String(char/varchar) fields in the query should have single/double > > quotes. > > This is something you learn in SQL 101. > > > To clarify- in Oracle if you put double-quotes around a value that you're > matching to a String field (char/varchar), it'll come back with an error. > They must be single-quotes. (guess you weren't paying attn in SQL 101 ;) > J/K of course. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
