Next/Previous Record in database for query
Posted on 2008-11-04
I have an access database of 250 records. I also have an admin section where the staff is viewing each record of the database. When viewing the data of the individual record, they would like to move to the next record or the previous record. The query does need to be limited by status.
<cfquery name="qry_previous" datasource="#request.dsn#" dbtype="ODBC">
WHERE grantid = #url.grantid# AND status IS NULL
ORDER BY grantID DESC
Any suggestions? I only need to get the very next record and the very previous record.