RE: ASP/SQL

Hello,

Thanks for the info.  This does appear to be what's happening.  One of the =
fields is nText which I assume causes the same problem as just Text. =20

Guess I'll have to do it the hard way.=20

Thanks for everyone's suggestions.=20

Regards,

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

>>> "Anderson, Eric" <Eric_Anderson(at)hrsoft.com> 09/26/00 10:57AM >>>
Hi Bastyr!=20

What are your field definitions for FirstName and LastName in SQL
Server?  I have found that if you use Text fields (not varchar(), but
datatype Text) you have to read them in the order in which you queried
them.  AND they have to be the last fields in your SELECT statement.

However, if you are not using the Text datatype, I am afraid that I do
not know what is happening.  You should be able to read them from the
recordset in any order you choose.

Hope this helps,=20
Eric=20

-----Original Message-----=20
From: Bastyr University WebMaster [ mailto:WebMaster(at)bastyr.edu=20
<mailto:WebMaster(at)bastyr.edu> ]=20
Sent: Tuesday, September 26, 2000 10:36 AM=20
To: hwg-languages(at)hwg.org=20
Subject: ASP/SQL=20


Howdy,=20

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,=20

Doug Dossett=20
Webmaster=20
Bastyr University=20
http://www.bastyr.edu <http://www.bastyr.edu> =20

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