RE: next row in

2000-09-05 Thread Tim Bahlke
Thanks for the help ... I was all around it but just couldn't put it together. Tim _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile

Re: next row in

2000-09-05 Thread Sharon DiOrio
this loop: #field# next loop: #query.field[currentRow+1]# 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 ne

RE: next row in

2000-09-05 Thread Rick Osborne
Instead of using use . Then just make sure that you reference all your vars as #x.FieldName[i]#. Or, you should be able to use the CurrentRow variable from that first loop. EIther way will work, it just depends on which you think you like better. SELECT bug_id BugID, created_dt Created

RE: next row in

2000-09-05 Thread Dan Haley
#myquery.myfield[myquery.currentrow + 1]# And don't forget to check for when you are in the last row. ;) Dan -Original Message- From: Tim Bahlke [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 05, 2000 11:53 AM To: [EMAIL PROTECTED] Subject: next row in Hey all, I am looping thr