Connection.execute RecordsAffected Problem

[LuvASP]

I am executing an Insert query through connection object:

set conn = server.CreateObject("ADODB.connection&quot
conn.Open constr
conn.execute "INSERT INTO table1(val) SELECT val FROM table2", recs, adAsyncExecute

I keep getting a -1 in recs. What am I doing wrong? RecordsAffected just doesn't seem to work.

Thanks for any input.

 

[onpnt]

one tip: all nested SQL statements have to be segragated by a ;
eg:
"INSERT INTO table1 (val) ; SELECT val FROM table2", recs, adAsyncExecute

I've always been partial to get my statements as I believe you're taking from one table and inserting to the next(?) into two seperate proceses. This makes for debugging ease
eg:
RS1 = "SELECT val FROM table2"
RS2 = "INSERT INTO table1 (column) (RS1)"

then you can debug it with response.write etc...

_____________________________________________________________________
_{Where have all my friends gone to????}

http://www.onpntwebdesigns.com