Ah you are using it wrong. When doing grouping you have 2 sets of cfoutput:
<cfoutput query="foo" group="payment_id">
this shows up once per payment id<br>
<cfoutput>
this shows up once per row
</cfoutput>
</cfoutput>
On 11/27/06, Torrent Girl <[EMAIL PROTECTED]> wrote:
> Here goes: What happens is, if there are multiple records per payment_id, the
> output only shows one when I group them
>
>
> <cfoutput query="getPaymentHistory" group="PAYMENT_ID">
> <tr bgcolor="###iif(currentrow MOD
> 2,DE('ffffff'),DE('efefef'))#">
> <td align="left"><span
> class="style1">#PAYMENT_ID#:#policy_no#</span></td>
> <td align="left"><span
> class="style1">#Message#</span></td>
> <td align="center"><span
> class="style1">#module#</span></td>
> <td align="center"><span
> class="style1">#dateFormat(Payment_Date, 'mm/dd/yyyy')#</span></td>
> <td align="center"><span class="style1"><cfif
> #Payment_Method# EQ "Agent Sweep">Sweep<cfelseif #Payment_Method# EQ "Credit
> Card">CC<cfelse>#Payment_Method#</cfif></span></td>
> <td align="center"><span
> class="style1">#Payment_Amount#</span></td>
> <td align="center"><span
> class="style1">#Bank_Code#</span></td>
> <td align="center"><span
> class="style1">#AUTHORIZATION_CODE#</span></td>
> <td align="center"><span
> class="style1">#Agent_Agency#</span></td>
> <td align="left"><span
> class="style1">#Upload_Status#</span></td>
> </tr>
> </cfoutput>
>
> >Can you show your code?
> >
> >
> >On 11/27/06, Torrent Girl <[EMAIL PROTECTED]> wrote:
> >>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting,
up-to-date ColdFusion information by your peers, delivered to your door four
times a year.
http://www.fusionauthority.com/quarterly
Archive:
http://www.houseoffusion.com/groups/CF-Newbie/message.cfm/messageid:2270
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
