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/
