|
|
 |
| Classic ASP Databases Discuss using ASP 3 to work with data in databases, including ASP Database Setup issues from the old P2P forum on this specific subtopic. See also the book forum Beginning ASP.NET Databases for questions specific to that book. NOT for ASP.NET 1.0, 1.1, or 2.0. |
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Databases section of the Wrox p2p Programmer to Programmer discussion community. This is a community of more than 40,000 computer programmers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining our free Wrox p2p community you can post your own programming questions and respond to other programmers’ questions. Registered users also don't have to see the ads that are displayed to guests. Registration is fast, simple and absolutely free so please, join today!
Join today and post to win prizes! Post more to increase your chances of being Wrox’s top poster of the month.
|
 |
September 24th, 2009, 04:58 PM
|
|
Authorized User
|
|
Join Date: Oct 2006
Location: , , .
Posts: 91
Thanks: 8
Thanked 0 Times in 0 Posts
|
|
SCRIPT TIMING OUT
Hi to all...
i have a web page that displays records from the database...
I added <% Server.ScriptTimeout = 2000 %> to my page...
but still after a while the page "The page cannot be displayed"...
I know it’s working because when I change my script to display least on screen it works…
Do you know if there something else to add or I need to change because it looks like it’s not reading the timeout…
Thx Rino
|
September 24th, 2009, 06:01 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,323
Thanks: 3
Thanked 70 Times in 69 Posts
|
|
Don't display so many records.
Learn to use "recordset paging". Display only 10 to 20 records per page.
Google for "asp recordset paging". Tons of examples out there. Some of them are even good ones.
|
September 24th, 2009, 06:18 PM
|
|
Authorized User
|
|
Join Date: Oct 2006
Location: , , .
Posts: 91
Thanks: 8
Thanked 0 Times in 0 Posts
|
|
the reason why is that once displayed the user exports the data to excel...
so they are not going to view it in web page...
is there a way to just export it to excel instead of display it on screen then???
Thx Rino
|
September 24th, 2009, 08:03 PM
|
|
Friend of Wrox
|
|
Join Date: Jun 2008
Location: Snohomish, WA, USA
Posts: 1,323
Thanks: 3
Thanked 70 Times in 69 Posts
|
|
Quote:
|
is there a way to just export it to excel instead of display it on screen then???
|
Yeah, but it's about 20 or 30 times as much work and easy to mess up.
Okay, just bump up the DB connection timeout and the Script timeout. A bit ugly, but if it's not done TOO often it will be okay. |
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
