<cfloop query="myQuery">
        this loop: #field# 
        <cfif currentRow IS NOT myQuery.recordcount>
                next loop: #query.field[currentRow+1]#
        </cfif>
</cfloop>

HTH

Sharon

At 02:53 PM 9/5/2000 -0400, Tim Bahlke wrote:
>Hey all,
>
>I am looping through a query and need to get data from the next row.
>
>Make sense?  While my loop in handling row 5, I need to grab some data from 
>row 6 and do a TimeFormat.  I just can't seem to get to that next row.
>
>I have tried a number of different ways to do this but have had no luck.  It 
>seems that this screams for an embedded loop but I just can't seem to get 
>what I want.
>
>If this makes any sense I anyone out there, I would be grateful for any 
>assistance.
>
>Thanks,
>Tim
>_________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
>
>Share information about yourself, create your own public profile at 
>http://profiles.msn.com.
>
>---------------------------------------------------------------------------
---
>Archives: http://www.mail-archive.com/[email protected]/
>To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=listsbody=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
> 

------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit 
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a 
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.

Reply via email to