Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Problem in retrieving records stored in a array

Author  Topic 

karan@talash.net
Starting Member

12 Posts

Posted - 2002-06-29 : 02:31:20
HI Viewer,
I am currently facing a strange problem.I stored the result of the query in an array.While retreiving records i am able to retrieve the values of all the fields except one.
When i am executing this query from query analyzer,i am getting the correct result but when i am executing this query through an asp page,I am facing the problem mentioned above.
Regards
Karan Bajoria

Johnhamman
Starting Member

37 Posts

Posted - 2002-06-29 : 18:41:10
which one are you not being able to retreive? Arrays typicaly start at 0 and go up but if you are starting at 1 you would miss the first record.

Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2002-07-01 : 14:28:39
Also, if one of your fields is a TEXT field, then ADO has problems retrieving and data after that field in the field list, so make your TEXT field the last one in the list.

Go to Top of Page
   

- Advertisement -