Error - View Single Post - strange problem - recordset query loses data after response.write

**driverdownloads** · 22-May-2007, 09:10 AM

do not use the .Recordcount property unless really needed, because it is 1) not relyable 2) should not be needed anyhow.

you migh try this:

response.write adorecordset.recordcount
adoRecordset.Movefirst
Do Until adoRecordset.EOF

but you might run into another error, ie like "provider does not support move..."

tip:
instead of

Set adoRecordset = adoCommand.Execute

try this:

Set adoRecordset = Server.CreateObject("ADODB.Recordset")
adoRecordset.open adoCommand

question:
what database?
why did you post ing Windows 2003 Active Directory?

22-May-2007, 09:10 AM	#2 (permalink)
driverdownloads Fixed Error! Posts: 1,672 Join Date: Mar 2007 Rep Power: 3 IM:	Re: strange problem - recordset query loses data after response.write do not use the .Recordcount property unless really needed, because it is 1) not relyable 2) should not be needed anyhow. you migh try this: response.write adorecordset.recordcount adoRecordset.Movefirst Do Until adoRecordset.EOF but you might run into another error, ie like "provider does not support move..." tip: instead of Set adoRecordset = adoCommand.Execute try this: Set adoRecordset = Server.CreateObject("ADODB.Recordset") adoRecordset.open adoCommand question: what database? why did you post ing Windows 2003 Active Directory?