Try to use PreserveSingleQuotes function:
.....
WHERE messages.parent = 0 AND messages.active = 1
#PreserveSingleQuotes(KeyWords)#
.....
Marian
> -----Original Message-----
> From: Steve Reich [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, April 11, 2001 8:27 PM
> To: CF-Talk
> Subject: SQL Query Headache...
>
>
> This works...
>
> <cfquery...>
> SELECT messages.messageid, messages.title AS mesTitle,
> messages.userid, messages.body, messages.datestamp,
> users.userid, users.fname, users.lname, users.company,
> users.copyReplies
> FROM messages JOIN
> users ON (users.userid = messages.userid)
> WHERE messages.parent = 0 AND messages.active = 1
> AND messages.body LIKE '%roar%' OR messages.body LIKE '%boby%'
> ORDER BY messages.datestamp desc
> </cfquery>
>
>
> This doesn't... (Return error: [Microsoft][ODBC SQL Server Driver][SQL
> Server]Invalid column name 'roar'.) I don't understand why it is seeing
> 'roar' as a db column....
>
> <cfset KeyWords = "AND messages.body LIKE '%roar%' OR messages.body LIKE
> '%boby%'">
> <cfquery...>
> SELECT messages.messageid, messages.title AS mesTitle,
> messages.userid, messages.body, messages.datestamp,
> users.userid, users.fname, users.lname, users.company,
> users.copyReplies
> FROM messages JOIN
> users ON (users.userid = messages.userid)
> WHERE messages.parent = 0 AND messages.active = 1
> #KeyWords#
> ORDER BY messages.datestamp desc
> </cfquery>
>
>
> What am I missing here?
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
