ValueList

[Guest]

Can we use ValueList with query of queries? When I do so, I get an error as follows:

The ValueList() function has an invalid parameter:
Parameter 1 of function ValueList must be pointing to a valid query name.

[Newsgroup_User]

you definitely can.

without seeing your code i may just guess that maybe your QoQ have
dynamic names? then just use arraytolist() function and specify the qoq
name and column name as array notation:

<cfoutput>#arraytolist(variables['static_part_of_qoq_name' &
dynamic_part_of_qoq_name]['column_name'])#</cfoutput>

post your code for more exact help.

Azadi Saryev
Sabai-dee.com
http://www.sabai-dee.com/

[Dan_Bracuk]

Yes you can.

Read your error message very carefully. It looks pretty helpful to me.

[Newsgroup_User]

> The ValueList() function has an invalid parameter:
> Parameter 1 of function ValueList must be pointing to a valid query name.

Actually I think you'll find that error message is ballocks. Parameter 1
of valueList() needs to point to a valid query COLUMN.

The syntax is:
myList = valueList(myQuery.myColumn);

--
Adam