NCS Logo - Click for home page Northstar Developer Center
Platforms
All Platforms
.NET Framework (1.x - 4.x)
Active Server Pages
ASP.NET
C#
SQL Server
VB.NET
Visual Basic

Keywords
.NET Data Types
.NET E-mail
.NET Events
.NET Functions
.NET Object Programming
.NET System.Configuration
.NET System.Diagnostics
.NET System.IO
.NET System.Net
.NET System.Net.Sockets
Active Data Objects
ASP Architecture
ASP Black Belt
ASP Built-in Functions
ASP Built-in Objects
ASP Debugging
ASP Performance
ASP Security
ASP Syntax
ASP.NET Authentication
ASP.NET Controls
ASP.NET Data Access
ASP.NET Features
ASP.NET Master Pages
ASP.NET Page Events
ASP.NET Security
ASP.NET ViewState
Atom
Certifications
COM, DCOM, COM+
Data Access
E-Mail
Errors
Exporting Data
HTML Tips
IIS
Object-Oriented Programming
RSS
SQL
Uncategorized ASP Tips
VB API Programming
VB Forms
VB Syntax
XML

Book Support
Visual Basic 6 Bible
ASP Bible
ASP Weekend Crash Course
ASP.NET At Work
Creating Web Services

Finding Infinite Loops

Written by Eric Smith, Northstar Computer Systems LLC

If you ever have a page that just seems to hang, it's possible that you have an infinite loop. This often comes up when dealing with databases, where you might have code like this:

Set rsData = cnDB.Execute("SELECT * FROM SomeTable")
Do Until rsData.EOF
   do something with the data
Loop

Assuming there are records in the recordset, this loop will never exit. Why? The loop doesn't go past the first record. The code is missing a call to MoveNext to select the next record. A practice I try to follow is to immediately type the MoveNext call after I write the Do statement. I also typically will put in the Loop keyword so I don't forget.

Keywords: [ Uncategorized ASP Tips ]

Publication Date: 1/10/2001