form field list and SQL IN

[Species_Evolution]

I'm writing a query that creates a .csv file dependant on the results of a
search. The search is working fine with the exception of the IN statement which
doesn't like CF

The user has the option of selecting multiple age ranges
('u_24','25-34','35-44','45-54','55+').
The form returns these as a list eg. u_24,25-34,55+

I'm changing the list using <cfset form.age = ListChangeDelims(#form.age#,
"','", ",")>

Which when output looks fine, but refusees to work with the SQL.

Any ideas?

[The ScareCrow]

Not sure why your changing the delimiter, but this is how I do it

Where yourColumn IN (#ListQualify(form.age, " ' ")#)

Note space inserted so you can see what is there.

Ken

[vkunirs]

Hi

can you post your generater query here.?
i think if you are separating the values with "," then it will works fine...may the last comma may give error.

[Species_Evolution]

Ken,

Works fine, thanks for the help.

Spencer