Compare myquery.currentrow (the current row) to myquery.recordcount (the
total number of rows.  If they're equal, you're on the last row.

Cheers,
barneyb

> -----Original Message-----
> From: Jeff Fongemie [mailto:[EMAIL PROTECTED]
> Sent: Thursday, February 26, 2004 7:26 AM
> To: CF-Talk
> Subject: How to know when you have the last record?
>
> Hey,
>
> I'm outputting a query as a list. Visually, I'm inserting an
> image between each record. It looks great until the last
> record, and I get the image at the very end.
>
> What would be the best way to know that I'm at the end of my
> record set and not show the image?
>
> Something like: <cfif not lastrecord(myquery.recordcount)>
>                  <img src=""> >                 </cfif>
>
> Is there an easy way to accomplish this?
>
> -Jeff   
>                    
>
>
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to