How can I add a comma ?

i using following code produce output :

<cfoutput query="qryview" group="materialnumber">
<tr>
<td class="titletext">#materialnumber#</td>
<td class="titletext">#purchaseorder#</td>
<td class="titletext"><cfoutput>#qryview.serialnumber#  </cfoutput></td>
<td class="titletext">#qryview.quantity#</td>
<td class="titletext">#dollarformat(qryview.unitvalue)#</td>
</tr>
</cfoutput>

for serial number line, outputs 1 serial number after another. want add comma @ end of each serial number separate them, if add comma, add comma last number, not want. since did not know how this, added 2   separate serial numbers. tried use valuelist duplicates serial numbers each material number. code produces output want, except comma separate each serial number.

how can done ?

how this?

<cfoutput query="qryview" group="materialnumber">
<tr>
<td class="titletext">#materialnumber#</td>
<td class="titletext">#purchaseorder#</td>
<td
class="titletext">#qryview.serialnumber#<cfif currentrow lt
qryview.recordcount>,</cfif></td>
<td class="titletext">#qryview.quantity#</td>
<td class="titletext">#dollarformat(qryview.unitvalue)#</td>
</tr>
</cfoutput>

may not want though.. not sure how trying
show serial number list, nested cfoutputs.

if each output shows full list, try cfloop

<cfset loopct = 0>
<cfloop query="qryview">
#qryview.serialnumber#<cfif loopct lt qryview.recordcount>,</cfif>
</cfloop>


other ways include useful listappend() function... depends on
what want output like, , how plan use


michael evangelista, evangelista design
web : www.mredesign.com blog : www.miuaiga.com
developer newsgroups: news://forums.mredesign.com

trojnfn wrote:
> using following code produce output :
>
> <cfoutput query="qryview" group="materialnumber">
> <tr>
> <td class="titletext">#materialnumber#</td>
> <td class="titletext">#purchaseorder#</td>
> <td
> class="titletext"><cfoutput>#qryview.serialnumber#  </cfoutput></td>
> <td class="titletext">#qryview.quantity#</td>
> <td class="titletext">#dollarformat(qryview.unitvalue)#</td>
> </tr>
> </cfoutput>
>
> serial number line, outputs 1 serial number after another. want
> add comma @ end of each serial number separate them, if add
> comma, add comma last number, not
> want. since did not know how this, added 2   separate
> serial numbers. tried use valuelist duplicates serial
> numbers each material number. code produces output want, except
> comma separate each serial number.
>
> how can done ?
>

More discussions in ColdFusion

adobe