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
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... > > > 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 > > > > 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 > > > > 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 > > > > 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
SQL Query Headache...
This works... 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 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 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 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