Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-10-17 : 16:28:53
|
| Matt writes "Hi there.After reading your articles on returning random records from a table using a stored procedure i've come across a problem that i'm sure many developers have. I only want to show 4 records on my page and have a link on my page that will show the next 4 results,etc..The obvious problem here is that as soon as i click on my "next page" link the stored procedure executes again and i get a new set of random records which may or may not include the first 4 records on page 1. Of course if i then return back to page 1 i wont get the 4 records i got the first time as the stored procedure has executed again.I'm sure other people have come across this problem and i wondered if you can help me (and others) out on this one!I'm using IIS4 on an NT4 server. SQL Server 7. VBscript for my asp coding.Any help greatfully apreciated.. Kind Regards,MaTT Preston" |
|
|
|
|
|
Returning random records and page navigation.