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
 General SQL Server Forums
 New to SQL Server Programming
 Empty recordset columns

Author  Topic 

danielbeard
Starting Member

1 Post

Posted - 2008-12-09 : 08:05:15
Hi everyone,

I am using Classic ASP with an SQL Server database and sometimes some columns of the recordset I get back appear as empty, when I know that they are not. Changing around the order in which I set up the variables receiving the data, some appear, and some remain empty. EG:

costa=rs("costa")
people=rs("people")
area=rs("area")
airport_alicante=rs("airport_alicante")
int_school=rs("int_school")
beach=rs("beach")
shops=rs("shops")
golf=rs("golf")

Some of the variables are empty (the database entries are not)

beach=rs("beach")
shops=rs("shops")
golf=rs("golf")
costa=rs("costa")
people=rs("people")
area=rs("area")
airport_alicante=rs("airport_alicante")
int_school=rs("int_school")

Gives me some other empty variables.

What is happening?

Thanks,

Daniel
   

- Advertisement -