query to list

[weblover]

i need to convert a query column values to list , is there any way to do that, pls.help

thanks in advance.

[lad4bear]

DataManipulationLib over at CFLib contains lots of Query related functions. If its not in there, it will provide some useful place to get started.

Cheers,

Pete (aka lad4bear)

[weblover]

i tried that function, but it doesn't work, or may be am wrong . i tried to
input Query and Column name and comma as delimiter to that function but it
gives an error.

i just pasted this function in my coldfusion page where am working on but it
throws the below error
=======================
Invalid parser construct found on line 24 at position 10. ColdFusion was
looking at the following text:

DynamicValueList
======================

any ideas pls.help

[Adam Cameron]

> i need to convert a query column values to list , is there any way to do that, pls.help

RTFM can get you a long way...

[url]http://livedocs.macromedia.com/coldfusion/7/htmldocs/wwhelp/wwhimpl/common/html/wwhelp.htm?context=ColdFusion_Documentation&file=p art_cfm.htm[/url]

--

Adam

[weblover]

I need a solution, not the whole documentation, anyways thanks for your reference.

[weblover]

got the solution, used a valuelist function for a specified column to convert to list.

[Adam Cameron]

> I need a solution, not the whole documentation, anyways thanks for your reference.

Sorry... didn't notice the CFMX7 docs are in frames now (the CFMX6.1 ones
weren't).

Meant to send you the link to valueList(). Seems you found it anyhow ;-)

--

Adam