Problem with listQualify

Question

I have a dropdown list box on the form page that is populated
with a number of units, some single words, some multiple words with
spaces and some contain commas like this: AUG,ABN BCT

I am using MS SQL Server200 and when I pass in the list to
run the query I'm using listQualify in the where clause
like this: and unit in (#listQualify(units,"'")#)

It will not find the units that the user selected that have a
comma in them.

How can I fix this?

EndoplasmicReticulum · Answer

Thanks for the reply.However, cfqueryparam isn't helping.I need a comma delimited list for the where clause butsometimes the listvalues contain a comma within it. So when the query runs itseparates AUGfrom ABN BCT because there is a comma in it. I need the queryto see ‘AUG,ABN BCT’ as a single list value.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded