any one else see this? http://blog.daemon.com.au/archives/000196.html#000196
Brian Gilbert Wesley College, Melbourne Australia Position: Web Architect Ph: +61 (0)3 9881 5459 Fx: +61 (0)3 9802 0142 Personal Website: http://www.realityloop.com/ >>> [EMAIL PROTECTED] 09/18/03 03:34pm >>> No problem. Yeah, I only realised after sending I had put an AND there.. Darryl -----Original Message----- From: Seona Bellamy [mailto:[EMAIL PROTECTED] Posted At: Thursday, 18 September 2003 11:26 AM Posted To: CFAussie Conversation: [cfaussie] RE: Dumb SQL problem Subject: [cfaussie] RE: Dumb SQL problem Ah, thanks for that Darryl. It didn't quite work, but it got me on the right track. With this version, because you're using an AND statement, the query only returns records if they match all of the keywords passed. But if you start with a WHERE clause that is always false (I used 1=0) and then make the statement in the loop an OR statement, it works just fine. Cheers, Seona. -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Fuzion - CFAussie Sent: Thursday, 18 September 2003 10:43 AM To: CFAussie Mailing List Subject: [cfaussie] RE: Dumb SQL problem I would loop over the "form.keywords" list and generate an SQL statement for each. <cfloop index="keyword" list="#form.keywords#"> AND keywords LIKE '%#keyword#%' </cfloop> Or something like that.. Darryl --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.518 / Virus Database: 316 - Release Date: 11/09/2003 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/ --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MX Downunder AsiaPac DevCon - http://mxdu.com/
