ASP/SQL

Howdy,

I'm in the process of converting a page using an access database to MS =
SQL.  It seems that when retrieving the data from the database, I have to =
use the data in the order in which it appears in the database or it =
doesn't see it. =20

Example:  I have a record with FirstName, LastName, Phone.  If I print =
LastName, FirstName, Phone, FirstName will show up blank because I already =
passed it to get to LastName.

Now I can either assign all data to values, IE MyLastName =3D Rs("LastName"=
) or if it's a single record, I can just start over at the first record.  =
But I do have multiple records and I don't want to assign every item.=20

So, long story short, is there a way to just move to the beginning of the =
current record (not the current record set)?  I've tried MoveNext, then =
MovePrevious and equivalent, but they don't work either.=20

Any help would be appreciated.=20

Regards,

Doug Dossett
Webmaster
Bastyr University
http://www.bastyr.edu

HWG: hwg-languages mailing list archives, maintained by Webmasters @ IWA