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 ______________________________________________________________________ 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 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
