sql list syntax

2000-03-29 Thread Chris Giminez 

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?


Chris Giminez
Owner - Cyber Scriber Web Site Design
831-728-4469
ICQ# 2628000



--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

RE: sql list syntax

2000-03-29 Thread Sean Daniels 

 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=listsbody=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.