Skip to main content
February 26, 2009
Question

ValueList

  • February 26, 2009
  • 3 replies
  • 1282 views
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.
This topic has been closed for replies.

3 replies

Inspiring
February 27, 2009
> 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
Inspiring
February 26, 2009
Yes you can.

Read your error message very carefully. It looks pretty helpful to me.
Inspiring
February 26, 2009
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/