tanks! -----Original Message----- From: Bobby Hartsfield [mailto:[EMAIL PROTECTED] Sent: Monday, December 05, 2005 11:09 PM To: CF-Talk Subject: RE: SQL Question. Compare one list to another
Pretty good read in general too about UDFs in sql ...:.:.:.:.:.:.:.:.:.:.:.:.:.:. Bobby Hartsfield http://acoderslife.com -----Original Message----- From: John Wilker [mailto:[EMAIL PROTECTED] Sent: Monday, December 05, 2005 11:55 PM To: CF-Talk Subject: Re: SQL Question. Compare one list to another Ah, duh, missed the trailing "d" on the next line. my bad. On 12/5/05, Bobby Hartsfield <[EMAIL PROTECTED]> wrote: > > Not if you piece it back together right.... > > http://mkruger.cfwebtools.com/index.cfm > ?mode=alias > &alias=sql%20udf%20listfind > > ..:.:.:.:.:.:.:.:.:.:.:.:.:.:. > Bobby Hartsfield > http://acoderslife.com > > -----Original Message----- > From: John Wilker [mailto:[EMAIL PROTECTED] > Sent: Monday, December 05, 2005 11:36 PM > To: CF-Talk > Subject: Re: SQL Question. Compare one list to another > > 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:226170 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
