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/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
