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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
RE: SQL Query Headache...
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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
Re: SQL Query Headache...
Try to use PreserveSingleQuotes function: . WHERE messages.parent = 0 AND messages.active = 1 #PreserveSingleQuotes(KeyWords)# . Marian That was it! Thank you very much! Steve ~~ 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