> What is the sql syntax for checking if a form field value is
> contained in the contents of a comma
> delimted list of values in a field?
I think about the only way to do it is using:
LIKE '%#form.name#%'
Thus, if your db field contained 'nuts,bolts,nail,gun' and your form field
was 'bolts', the record would match.
Is that what your are trying to do?
- Sean
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Sean Daniels
Manager of Engineering
DealStream, Inc.
[EMAIL PROTECTED]
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
tel: 207.439.6030
cel: 978.764.0799
Fax: 240.269.6319
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.