To steal from the docs: ColdFusion has a list of reserved keywords, which are typically part of the SQL language and are not normally used for names of columns or tables. To escape a reserved keyword for a column name or table name, enclose it in brackets.
Caution: Earlier versions of ColdFusion let you use some reserved keywords without escaping them. ======================================================================= Raymond Camden, ColdFusion Jedi Master for Hire Email : [EMAIL PROTECTED] Yahoo IM : cfjedimaster "My ally is the Force, and a powerful ally it is." - Yoda > -----Original Message----- > From: Mark A. Kruger - CFG [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 10:02 AM > To: CF-Talk > Subject: RE: Query of Query Oddness > > > Ray, > > If section is reserved, do you know what it is reserved for? > Where is it > used? > > -mk > > -----Original Message----- > From: Raymond Camden [mailto:[EMAIL PROTECTED]] > Sent: Thursday, August 15, 2002 8:52 AM > To: CF-Talk > Subject: RE: Query of Query Oddness > > > Section is a reserved word. I checked the docs and it _wasnt_ on the > list, so I'm going to add it to livedocs. > > To correct, just change "section" to "[section]". > > ============================================================== > ========= > Raymond Camden, ColdFusion Jedi Master for Hire > > Email : [EMAIL PROTECTED] > Yahoo IM : cfjedimaster > > "My ally is the Force, and a powerful ally it is." - Yoda > > > -----Original Message----- > > From: Joshua Miller [mailto:[EMAIL PROTECTED]] > > Sent: Thursday, August 15, 2002 9:43 AM > > To: CF-Talk > > Subject: Query of Query Oddness > > > > > > This is really odd, this is a very simple Query of Query and the > > function keeps crapping out on me in CFMX ... any ideas? > > > > I did a cfdump of the query myQuery and it contains all the > fields I'd > > expect: > > > > HELPDOC (string) > > SECTION (string) > > TITLE (string) > > > > Here's the Query: > > <cfquery dbtype="query" name="qGetContent"> > > SELECT * FROM myQuery > > WHERE section LIKE '%#s#%' > > </cfquery> > > > > Here's the actual SQL: > > SELECT * FROM myQuery WHERE section LIKE '%Membership%' > > > > Here's the Error: > > Query Of Queries syntax error. > > Encountered "section" at line 3, column 15. Incorrect conditional > > expression, Expected one of [like|null|between|in|comparison] > > condition, > > > > > > Thanks, > > > > Joshua Miller > > > > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
