weird ado problem - any ideas?

[FranckM]

,,,
ADODB.Recordset error '800a0cb3'

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.

/ABSInternet_Local/test.asp, line 40


I have 2 sql queries set to rs and rs2. I open both of them, then I do this:

varfields=Array("value1a","value1b","value1c", "value1d&quot
varvalues=Array(Response.Write(value2a & "," & value2b & "," & value2c & "," & value2d))
rs.AddNew varfields,varvalues

Both sql queries have the select the same values. I tryed puttins some locktypes...all 5 of them, they would lead to an other error:

ADODB.Recordset error '800a0bb9'

Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.

/ABSInternet_Local/test.asp, line 9


Thanks for reading and giving you're input

 

[FengShui1998]

FranckM,


varfields=Array("value1a","value1b","value1c", "value1d&quot
varvalues=Array(value2a , value2b, value2c, value2d)

You do not need to do a "Response.write". Response.write means write to the HTML page. The examples above merely assigns values to the array.

fengshui_1998