Eliminating comma at end of output

Thanks it now works.

Have you tried something like this:

<cfoutput query="otherquery" group="id">
#id#<br>
<cfoutput>
#names#
<cfif otherquery.currentrow lt otherquery.recordcount>
,
</cfif>
</cfoutput>
</cfoutput>

--
Bryan Ashcraft (remove brain to reply)
Web Application Developer
Wright Medical Technologies, Inc.
------------------------------------------------------------------
Macromedia Certified Dreamweaver Developer
Adobe Community Expert (DW) :: http://www.adobe.com/communities/experts/


"Florida" <webforumsuser@macromedia.com> wrote in message
news:e7ecq2$49o$1@forums.macromedia.com...
> The id and names are from different tables where the query
> fetches an id that someone enters in a form and fetches the
> id
> and names. I have to group the otherquery by id so I can fetch all
> id listings and get the names for each id.
>
>
> Here is how I currently have it and it works great but the comma at the
> end is
> the only problem:
>
> <cfoutput query="otherquery" group="id">
> #id#<br>
> <cfoutput>
> #names#,
> </cfoutput>
> </cfoutput>
>
>
> Output:
> Thompson, Jones, Williams,
>

The id and names are from different tables where the query fetches an id that someone enters in a form and fetches the id and names. I have to group the otherquery by id so I can fetch all id listings and get the names for each id.


Here is how I currently have it and it works great but the comma at the end is the only problem:

<cfoutput query="otherquery" group="id">
#id#<br>
<cfoutput>
#names#,
</cfoutput>
</cfoutput>


Output:
Thompson, Jones, Williams,

Thanks,

It still adds commas to all such as this:
Jones, Carson, Baker,



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

> Should I do this another way?

Yeah, use ListAppend().
<cfset dynNames = ListAppend(dynNames,names)>

Thanks,

I think my problem is this is in a nested cfoutput.

I am taking the data which is in variable names that looks like this as an output:
Jones Rivers Baker Johnson

and putting comma delimeters on them like this:
<i>
<cfset dynNames = "#names#,">
</i>
so my output will have comma delimeters. The problem is I dont want a comma at the end which is what is happening:
Jones, Rivers, Baker, Johnson,

I tried all suggestions in this thread and all of them knock off all the commas but I only need the last comma knocked off. I assume I have an output issue.
Should I do this another way? If so please advise.

Why not just use ListAppend() rather than your string append?

<cfset mylist = "1,2,3,4,5," />
<cfset newlist = left(mylist,len(mylist)-1) />
#newlist#

--
Bryan Ashcraft (remove brain to reply)
Web Application Developer
Wright Medical Technologies, Inc.
------------------------------------------------------------------
Macromedia Certified Dreamweaver Developer
Adobe Community Expert (DW) :: http://www.adobe.com/communities/experts/


"Florida" <webforumsuser@macromedia.com> wrote in message
news:e7blqf$ksm$1@forums.macromedia.com...
> 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.
>

Thanks,

Sorry I didnt show my entire script because it still doesnt work.
I have the names that comes out where I put a comma in between each one but the last one shouldnt have one:


<cfoutput query="otherquery" group="id">
#id#<br>
<cfoutput>
<cfset dynNames = "#names#,">

<CFSET bar = Mid(dynNames, 1, Len(dynNames) - 1)>
#bar#
</cfoutput>
<cfoutput>

See below.