How to display comma separated query column values in coldfusion

 Suppose if you have a query which returns some names of person. For example, if you have a table called person which have a column called fist_name and last_name. if you have to display each first_name and last_name comma separated you can use the following code.

We can have the query like this:

<cfquery name="getperson" datasource="datasourcename">

    select first_name,last_name from person

</cfquery>

so for displaying this result , we can have a code like this:

<cfoutput query="#getperson#">

    #trim(getperson.first_name)# #trim(getperson.last_name)#<cfif             getperson.currentrow LT getperson.recordCount>, </cfif> 

</cfoutput>