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 - 2000-09-01 : 16:46:40
|
Richard writes "I can get the Page Count value to work using a hard coded(bad)
SQL statement in an ASP page, but NOT when I use a
Stored Proc(good). Any ideas on how to get this to work?
Example:
Customer table has 1000 rows
Using ADO object
rsData.PageSize = 20
Using the HardCoded method.
rsData.Open "SELECT Name FROM Customer", conn
The rsData.PageCount is 50.
Using a Stored Proc.
rsData.Open "sp_Get_Name", conn
The rsData.PageCount is -1.
Thanks." |
|
|
|
|
|
Using Page Counts from a Stored Proc in ASP