"Go Next" record? (Full Version)

All Forums >> [Web Development] >> ASP and Database



Message

evansforsyth -> "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



Spooky -> 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"



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



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



Spooky -> RE: "Go Next" record? (8/23/2004 15:32:26)

Doh - mind on a different thing [sm=icon_redface.gif]



Page: [1]

Valid CSS!




Forum Software © ASPPlayground.NET Advanced Edition 2.4.5 ANSI
4.882813E-02