Josh,
Try putting the search string in parenthasis - i.e. WHERE SECTION LIKE
('%Membership%')
-----Original Message-----
From: Joshua Miller [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 15, 2002 8: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
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.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
