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:2269
Subscription: http://www.houseoffusion.com/groups/CF-Newbie/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
