Query to List 1

[minli98]

Hi,

Is there a function that automatically converts query results to a list? I thought I read somewhere that there is one, but couldn't find it now. Or do I need to use cfloop to append query results to the list one by one?

<cfquery name="getProductId">
  select productId
  from product
</cfquery>

<cfset x = QueryToList(getProductId.productId)> ???

Thank you in advance!

Regards,
Min

 

[FALCONSEYE]

<cfset x = ValueList(getProductId.productId)>

http://www.jetansolutions.com

 

[minli98]

Hi Falconseye,

This is a new function for me, but I tried it and it works perfectly. Thank you very much!

Regards,
Min

 

[FALCONSEYE]

glad i could help...

http://www.jetansolutions.com