That would work even if there was only one item in the list.
But it would require that myField have one and only one value per record.
Does this handle your needs? (Or do you have more than one potential value in each
myField field?)
Jerry Johnson
>>> [EMAIL PROTECTED] 01/21/03 05:46PM >>>
>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
Get the mailserver that powers this list at http://www.coolfusion.com
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
