ronayers
asked on
Get ID of previous record and Next record during CFoutput of a query
As i output a coldfusion query(multiple records) to the page how can i access the previous record and the next record as the data is written to the page?
ASKER
hhh...without testing it that doesnt look like it will work. i thikn that will only add one or subtract one from the record count. shouldnt i be able to do something like qrytest.recordid[i] orsomething like that?
check out this tutorila it is similar to what you need
http://tutorial20.easycfm.com/
http://tutorial20.easycfm.com/
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thats it! thanks.
For example you have a query qryTest
In order to get all records you do qryTest.recordcount, so if you need the record before you qryTest.recordcount -1 and qryTest.recordcount +1
try this approach and let me know if you need more help