This is a discussion on "WHY IS THIS SCRIPT TAKING SO LONG!!!" within the Classic ASP section. This forum, and the thread "WHY IS THIS SCRIPT TAKING SO LONG!!! are both part of the Program Your Website category.
|
|
|
|
|
![]() |
||
WHY IS THIS SCRIPT TAKING SO LONG!!!
|
||
| Notices |
![]() |
|
|
LinkBack | Thread Tools |
|
#1
|
||||
|
||||
|
WHY IS THIS SCRIPT TAKING SO LONG!!!
does anyone have any idea why this script should be taking so long: (theres only 2 records in the database!!!)
|
|
|
|
#2
|
||||
|
||||
|
ps the script times out (usual time of 90 secs)
|
|
#3
|
|||
|
|||
|
I think the problem is your .MoveNext is inside the Else of an If statement, so the recordset loops infinitely if the If is true. You want the .MoveNext to happen no matter what the IF Else does so you should put it after End If and before Wend. On a side note people usually use Do While...Loop instead of While...Wend - but I'd have to think too much to give you a reason why :wink:
|
|
#4
|
||||
|
||||
|
ok thanks catalyst i never even noticed why!! i got round it anyway, not needing to compare the dates...
but i think i might change it back that way was easier! thanks |
![]() |
| Tags |
| script, taking, long |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Taking values from a form without sending it... | Mazinger | JavaScript Forum | 4 | Jan 8th, 2008 18:39 |
| Taking flash games from websites | DerangedGranny | Flash & Multimedia Forum | 13 | Oct 26th, 2007 10:12 |
| [SOLVED] not processing or just taking too long | saltedm8 | PHP Forum | 3 | Oct 17th, 2007 12:59 |
| They are taking legal action | littlebilly | Starting Out | 21 | Sep 23rd, 2007 14:03 |
| isn't this taking a bit too long...? | tameem | Web Page Design | 2 | May 6th, 2007 08:21 |