logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
Action Movies
Bible Basics
Houseplants
Romance Movies
Creativity
Family Travel
Southwest USA


dailyclick
All times in EST

Full Schedule
g
g ASP Site

BellaOnline's ASP Editor

g

MoveNext Record Set Function


When you're working with a set of records in ASP, you want some way to move from record to record. The MoveNext function lets you do that.

Let's say you select all writers from your database with a statement like

SQLText = "select FirstName, LastName from writers order by LastName, FirstName"

You go through all the defining and opening of your record set and now want to move by them one by one, to put each one on your screen. You would say:

do while not objRec3.EOF
response.write objRec3("firstname") & " " & objRec3("lastname") & "
"
objRec3.MoveNext()
loop

If you did NOT do the MoveNext, the record wouldn't move on to the next record. You would keep printing out the same record, over and over again, until your server went insane and locked up :)

Really, infinite loops are REALLY bad for your system. Make sure you always have your records advancing properly before you test out your code!
Add MoveNext+Record+Set+Function to Twitter Add MoveNext+Record+Set+Function to Facebook Add MoveNext+Record+Set+Function to MySpace Add MoveNext+Record+Set+Function to Del.icio.us Digg MoveNext+Record+Set+Function Add MoveNext+Record+Set+Function to Yahoo My Web Add MoveNext+Record+Set+Function to Google Bookmarks Add MoveNext+Record+Set+Function to Stumbleupon Add MoveNext+Record+Set+Function to Reddit




RSS | Related Articles | Editor's Picks Articles | Top Ten Articles | Previous Features | Site Map


For FREE email updates, subscribe to the ASP Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2014 by Lisa Shea. All rights reserved.
This content was written by Lisa Shea. If you wish to use this content in any manner, you need written permission. Contact Lisa Shea for details.

g


g features
Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2014 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor