Eliminating last comma in my dynamic output 4

[evergreean43]

My current output of dynamic names in my variable (called dynNames) has a comma at the end.

I need to eliminate the last comma:
Jones, Smith, Baker, Johnson,

to look like this:

Jones, Smith, Baker, Johnson


My attempt to eliminate the last comma doesnt work because it eliminates all the commas:

<cfset myNames = REReplace(dynNames, ",$" "", "All")>

<cfoutput>#myNames</cfoutput>

Output from my bad attempt:
Jones Smith Baker Johnson

Please advise.

 

[evergreean43]

Thanks for all the help.

This is what finally worked.

I am not sure what ListAppend() function does?
I assume it adds each record find to a list?

<cfoutput query="otherquery" group="id">
#id#<br>
<cfset dynNames = "">
<cfoutput>
<cfset dynNames = listappend(dynnames,names)>
</cfoutput>
#dynNames#
</cfoutput>

 

[evergreean43]

Sorry typo on one line.

Here is what worked:

<cfoutput query="otherquery" group="id">
#id#<br>
<cfoutput>
[COLOR=red]<cfset dynNames = "">[/color]
<cfset dynNames = listappend(dynnames,names)>
</cfoutput>
#dynNames#
</cfoutput>