You could try


<cfloop query="qry_show_event_sponsors">
        #EventSponserName##IIF(qry_show_event_sponsors.RecordCount NEQ
qry_show_event_sponsors.CurrentRow, DE(','), DE(''))#
</cfloop>


HTH

-----Original Message-----
From: Chris Martin [mailto:[EMAIL PROTECTED]] 
Sent: Thursday, May 3, 2001 16:13
To: CF-Talk
Subject: Finding the last item in a loop


IS it possible to find the last item in a loop?

Right now I have this:

<cfloop query="qry_show_event_sponsors">
        #EventSponserName#,
</cfloop>

Is it possible to check if the #EventSponsorName#  is the last item in
the record set, and then not display the comma?  I.E.

<cfloop query="qry_show_event_sponsors">
        #EventSponserName#<cfif something>,</cfif>
</cfloop>

Thanks in advance

Chris Martin
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to