"Go Next" record?

	Home Register Search Help Login

Sponsors
Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax
Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions.
Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Recent Posts
Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

"Go Next" record?

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP, PHP, and Database >> "Go Next" record?

Page: [1]


evansforsyth Posts: 277 Joined: 12/11/2001 From: Grande Prairie, Alberta, Canada Status: offline	"Go Next" record? - 8/16/2004 14:25:40 Is there some way, using the DRW, to select the next record? Say after the 10th record is displayed, (and if the 11th record was deleted) that the next query would show the 12th record? I seem to remember a "Go Next" database command--is it available to us? Thanks Evans _____________________________ Over the hill? What hill, where, when? I don't remember any hill!


Spooky Posts: 26723 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: "Go Next" record? - 8/16/2004 15:14:23 The normal paging method will always select the 'next' record. It mainly depends on the sort order eg "SORT BY ID DESC" _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to evansforsyth)


evansforsyth Posts: 277 Joined: 12/11/2001 From: Grande Prairie, Alberta, Canada Status: offline	RE: "Go Next" record? - 8/16/2004 23:52:21 Thanks This is for a classroom tutorial--so I need to store the record number and use it when the students have all answered the current question. Ended up using another DIW to select ID_nbr > ID_nbr current, limited to calling one record. And then storing it in a variable. Really appreciate the help--am doing things I'd despaired of a few years ago! Thanks Evans (in reply to Spooky)


aaronwiles Posts: 200 Joined: 7/5/2004 From: Aaron Wiles Status: offline	RE: "Go Next" record? - 8/23/2004 14:51:49 Syntax being "ORDER BY ID DESC" not "SORT BY ID DESC", you can also use "ORDER BY ID ASC" (ASC - Ascending, DESC = Descending). _____________________________ You really never learn to swear until you get a computer. (in reply to evansforsyth)


Spooky Posts: 26723 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: "Go Next" record? - 8/23/2004 15:32:26 Doh - mind on a different thing _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem Spky Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s (in reply to aaronwiles)