|
 |
asp_web_howto thread: AbsolutePage issue
Message #1 by william.sze@s... on Wed, 28 Nov 2001 13:57:37 -0500
|
|
Hi,
I added record paging subroutines to my ProcessRpt.asp file. All of my user
is working fine with the new function except one. Error message from
Internet Explorer is
"The page cannot be displayed."
So I reload the original ProcessRpt.asp (without record paging function) to
the intranet web site, the page can then be displayed.
One of the subroutine I added to the file is:
Sub RSPaging( )
Dim numberPages, page
numberPages = oRS.PageCount
page = Request.QueryString("page")
If page = "" then page = 1
oRS.AbsolutePage = page
End Sub
I found that if I take away the "oRS.AbsolutePage = page" from the sub, the
page can be displayed. With the "oRS.AbsolutePage = page" in the sub, the
page cannot be displayed.
Is it a ADO revision problem?
Please help.
Thanks
William
Message #2 by "Ken Schaefer" <ken@a...> on Thu, 29 Nov 2001 12:47:33 +1100
|
|
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <william.sze@s...>
Subject: [asp_web_howto] AbsolutePage issue
: I added record paging subroutines to my ProcessRpt.asp file. All of my
user
: is working fine with the new function except one. Error message from
: Internet Explorer is
:
: "The page cannot be displayed."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
In Internet Explorer, goto Tools | Internet Options, switch to the Advanced
Tab, and uncheck the box that says "Show Friendly HTTP Errors"
Then, you should see the real error being returned by IIS (probably an ADO
error that the recordset does not support bookmarks or similar).
Please post this more detailed error message.
Cheers
Ken
Message #3 by william.sze@s... on Fri, 30 Nov 2001 10:08:26 -0500
|
|
Ken,
Thanks.
After unchecking the box, it gives me "HTTP/1.1 Server Too Busy".
Does it mean that the server is too busy that it is unable to get data from
stored procedure only or something else? It is because when I save the
original file (without sp) back to the server, it does not have this
problem.
Thanks
William
"Ken Schaefer"
<ken@a... To: "ASP Web HowTo" <asp_web_howto@p...>
tic.com> cc:
Subject: [asp_web_howto] Re: AbsolutePage issue
11/28/2001
08:47 PM
Please respond
to "ASP Web
HowTo"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
From: <william.sze@s...>
Subject: [asp_web_howto] AbsolutePage issue
: I added record paging subroutines to my ProcessRpt.asp file. All of my
user
: is working fine with the new function except one. Error message from
: Internet Explorer is
:
: "The page cannot be displayed."
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
In Internet Explorer, goto Tools | Internet Options, switch to the Advanced
Tab, and uncheck the box that says "Show Friendly HTTP Errors"
Then, you should see the real error being returned by IIS (probably an ADO
error that the recordset does not support bookmarks or similar).
Please post this more detailed error message.
Cheers
Ken
$subst('Email.Unsub')
Read the future with ebooks at B&N
http://service.bfast.com/bfast/click?bfmid=2181&sourceid=38934667&categoryid=rn_ebooks
|
|
 |