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
This list and all House of Fusion resources hosted by CFHosting.com. The place for
dependable ColdFusion Hosting.
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
