not using ado... so is there a way to get a records affected count??? the recordset doesn't stay open if you just do an insert into query, right?
Use a Stored Proc and return rowsaffected as an output param...
stored procedures = too much hassle. :)<BR><BR>i used to do ntier, not anymore... we're just a webshop. it's more of a hassle then a benefit.<BR><BR>good idea though, and i might use it for this... i really need that recordcount. hehe.