Re: Reading from recordset destroys content

DaveRH — Thu, 24 Jul 2008 12:01:55 GMT

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.

Reading from recordset destroys content

DaveRH — Wed, 23 Jul 2008 23:53:24 GMT

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.

IIS7 - Classic ASP

Re: Reading from recordset destroys content

Reading from recordset destroys content