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
