<cfset LastSponsor = ListLast(ValueList(qry_show_event_sponsors.EventSponserName))>
<cfloop query="qry_show_event_sponsors">
#EventSponserName#<cfif EventSponserName NEQ LastSponsor>,</cfif>
</cfloop>
> <!--- start count outsite of loop --->
> <cfset count = 1>
>
> <cfloop query="qry_show_event_sponsors">
>
> <!--- check each iteration of the loop to see if count equals the total
> records --->
> #EventSponserName#<cfif count is not
> qry_show_event_sponsors.RecordCount>,</cfif>
>
> <!--- increment the count at the end of each loop --->
> <cfset count = IncrementValue(count)>
>
> </cfloop>
>
> ----- Original Message -----
> From: "Chris Martin" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, May 03, 2001 10:12 AM
> 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
