Untested but should work...
<cfloop query="qry_show_event_sponsors">
<CFIF qry_show_event_sponsors.currentrow NEQ
qry_show_event_sponsors.recordcount
#EventSponserName#,
<CFELSE>
#EventSponserName#
</CFIF>
</cfloop>
Jeff Garza
Web Developer/Webmaster
Spectrum Astro, Inc.
480.892.8200
[EMAIL PROTECTED]
http://www.spectrumastro.com
-----Original Message-----
From: Chris Martin [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 03, 2001 8:13 AM
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/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
