BTW, that link leads to a page with no entries. On 12/5/05, Mark A Kruger <[EMAIL PROTECTED]> wrote: > > You can create a UDF (in SQL - not CF) that mimics the "listfind" > function, > then loop through list "A" and check list "B". I have a blog on how to do > that UDF. > > > http://mkruger.cfwebtools.com/index.cfm?mode=alias&alias=sql%20udf%20listfin > d > > -Mark > > P.S. Obviously, storing lists in columns doesn't lend itself to optimal > SQL > code. I wouldn't expect this to be very efficient or easily maintained. > > -----Original Message----- > From: Ian Skinner [mailto:[EMAIL PROTECTED] > Sent: Monday, December 05, 2005 5:24 PM > To: CF-Talk > Subject: RE: SQL Question. Compare one list to another > > > I've got a table with a column that holds a comma seperated list of > keywords. I'm just not seeing the solution right now. > > I've got a keyword search where the user can put in a comma seperated list > of keywords. I need the query to search the DB to see if any of the > keywords > match the keywords in the keywords column. > > I'm sure it's right in front of me > > -- > John Wilker > Writer/Web Consultant > www.johnwilker.com / www.red-omega.com > > > Without pulling those lists out into a more normalize structure, the first > thing that pops into my head is a series of like matches. > > WHERE > Keywords LIKE '%KeywordMatch1%' AND|OR /*Depending in if they need to > match > one or all*/ > Keywords LIKE '%KeywordMatch2%' AND|OR > Keywords LIKE '%KeywordMatch3% /*continue until all keywordmatchs are > accounted for. > > Not very pretty, and I doubt it would be a quick performer. > > > -------------- > Ian Skinner > Web Programmer > BloodSource > www.BloodSource.org > Sacramento, CA > > "C code. C code run. Run code run. Please!" > - Cynthia Dunning > > Confidentiality Notice: This message including any > attachments is for the sole use of the intended > recipient(s) and may contain confidential and privileged > information. Any unauthorized review, use, disclosure or > distribution is prohibited. If you are not the > intended recipient, please contact the sender and > delete any copies of this message. > > > > > > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Discover CFTicket - The leading ColdFusion Help Desk and Trouble Ticket application http://www.houseoffusion.com/banners/view.cfm?bannerid=48 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:226143 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
