Outputting a list

[ice78991]

I am using Coldfusion with Sql Server 2005 and I am using coldfusion to convert a simple recordset to a list

Is it possible/advisable to perform this conversion in a stored procedure

ie converting the output of

SELECT names FROM dir

to a comma seperated list @list

which I could then output to coldfusion

 

[r937]

there's an easier way

<CFQUERY NAME="myquery" ...>
select name from dir
</CFQUERY>

<CFSET listofnames=ValueList(myquery.name) >

tadaaaa!!

r937.com | rudy.ca

 

[ice78991]

Thanks