Re: sql list syntax

---Reply to mail from Chris Giminez about sql list syntax > I am doing that.. sort of. > > I have > '#form.city#' like '%des_city%' > % is a wild card character - like .* in regexp, so what you are saying there is "return true if the contents of form.ci

Re: sql list syntax

I am doing that.. sort of. I have '#form.city#' like '%des_city%' The #form.city# will have one city name, and the field des_city may have one or many city names in a comma deliimited list. This is executing without an error, but it is not returning any records, where I know the values should

RE: sql list syntax

> 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',

sql list syntax

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 -- A