Hey good point, forgot that. An elegant way is: WHERE myField IN (#listqualify(myString, "'")#)
but that might not work if myString was blank. > -----Original Message----- > From: Ben Doom [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 22 January 2003 11:54 a.m. > To: CF-Talk > Subject: RE: String matches > > > Two things: > > 1) It works if there is only one thing in the list. > > 2) You can't just throw the string in single quotes and have it work. > However, if you > mystring = replace(mystring, ",", "','") > wrapping singlequotes around all the commas in the string I > think it should > do what you want. > > > -- Ben Doom > Programmer & General Lackey > Moonbow Software, Inc > > : -----Original Message----- > : From: Rafael Alan Bleiweiss [mailto:[EMAIL PROTECTED]] > : Sent: Tuesday, January 21, 2003 5:47 PM > : To: CF-Talk > : Subject: RE: String matches > : > : > : >How about: > : > > : >SELECT * > : >FROM myTable > : >WHERE myField IN ('#myString#') > : > : > : WOuld that work even if the "String" is only one item and there's no > : delimiter? Or do I have to force a delimiter? Like I > could apppend the > : variable with a comma at the end if none is found? > : > : > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
