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
