ASP memory leak??? Disappearing fields?? plz help!

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hi, 

I have a really bizare problem in ASP while querying data from an MSSQLServer database. 

The problem is that sometimes when trying to get field values from a recordset, the value is empty in ASP, eventhough it's not in the database. 
It's pretty random, but I noticed that this is affected by the order in which I get the fields from the recordset. 

For instance, in the example below: 

rsDataSet.Open strSQL, adoCn 
Response.Write("test 1: " & rsDataSet("col1") & "<br>") 
Response.Write("test 2: " & rsDataSet("col2") & "<br>") 
Response.Write("test 3: " & rsDataSet("col3") & "<br>") 

Test 1 will always show me the value in col1. 
But sometimes I can't see the values in col2 and col3 (they're empty, but I remind you, they're NOT empty in the database). 
But if I do this: 

Response.Write("test 2: " & rsDataSet("col2") & "<br>") 
Response.Write("test 3: " & rsDataSet("col3") & "<br>") 
Response.Write("test 1: " & rsDataSet("col1") & "<br>") 

Then I can see the value in col2, but I won't see the value in col1 anymore. 

However, string valued fields usually work, I found this problem quite consistent with non-string fields (numeric and boolean mostly). 
Usually I would also try to get a string value field somewhere in the middle, and it would work, and some numeric fields may even work once in a while, but others won't. It's hard to describe, it just seems so random... :( 
But no matter what, the first field I get always works. 

My guess is that this is some kind of a memory leak. 

Can anyone help? 

Edited by FLATLINE - 14 November 2007 at 9:43pm