« Previous Next »

• 07-23-2008, 7:53 PM

  DaveRH Joined on 07-23-2008, 7:45 PM Posts 2

  Reading from recordset destroys content Reply Contact I've come across a bug/error/issue with a ASP application which has me completely stumped. I am succesfully retrieving a recordset from the Access database, but when I use any item of the recordset it seems to overwrite it with a null value.  I can demonstate this by calling response.write(myrs("description")) three times in a row. The first time it will display correctly, the second and third it will output nothing. Attempting to conduct other operations seems to show that the value of the field is now 'Null'. I am checking the length of the field using the VBScript 'len' function, but doing this seems to erase the field so I can no longer do anything with it. Can anyone help? p.s. My machine is a Vista Ultimate, fully patched, running the application on IIS7.

  Tags: ASP

• 07-24-2008, 8:01 AM

  In reply to

  DaveRH Joined on 07-23-2008, 7:45 PM Posts 2	Re: Reading from recordset destroys content Reply Contact  Ok - circumvented the problem by assigning all recordset values into equivilant variables prior to doing any operations on them.  However, it's still a bizarre thing to happen and I'd appreciate any feedback on how/why this is happening.