Eliminate Blanks in QuotedValueList

[shobia]

How do i get rid of blank values in a QuotedValueList?
Replace does not always work.Version is ColdFusion MX 7.

ex: 'a','b','','d'
'a','b','d'

Thanks
Shobia

 

[ecobb]

You can either modify your query to not pull blank (NULL) values, or you can use this UDF to replace the blank values with something else, then hunt down and get rid of that value.

http://www.cflib.org/udf.cfm?id=507

For example, replace all blank values with "Null". Then you could use ListFind & ListDeleteAt to get rid of all the NULL values.

Actually, you may be able to use ListFind & ListDeleteAt on the string as-is. I don't know if it can find the blank values or not...



Hope This Helps!

ECAR
ECAR Technologies, LLC

http://www.ecartech.com

"My work is a game, a very serious game." - M.C. Escher

 

[shobia]

thanks, i will try it.