What is stored in the db? Is it a single entry, or have you put a list of items in the db field?
Jerry Johnson >>> [EMAIL PROTECTED] 01/21/03 05:26PM >>> If I have a string that can contain one or more entries, and I want to match it against a table field, what's the best CF5 way of doing this? The string MAY have a comma, but if only one entry is in it there's no comma... For Example, if my string is: <CFSET MyString="MA32-30443,20WQ11,4055392T5"> OR if my string is: <CFSET MyString="39EUWI33"> how do I compare that to a datatable that would possibly have at least ONE of the entries in the string? ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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
