<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.