Create list from query

Hello,

I have a query:
SELECT ID FROM TEST

I want the output to be like this: 1,3,4,6
How can i do that? What I'm trying is:
<cfoutput>#ID#,</cfoutput> which gets me 1,3,4,6, (I need to loss the last , )

Thanks!