ado multiple addnew question

[duckyboyz]

I have 11 rows in my html table that I want to add via my recordset. With one record you would do an "addnew" and "update" to complete the transaction. What do I do if I want to loop through the 11 rows in my html table, parse them out to my recordset and do an "addnew" and an "update" for each record in a loop? Or is there a way to "append" mulitple records to an open recordset? what's the best way to add "mulitple" records via a recordset?

Mike Johnson

 

[jebenson]

With only 11 records, doing an addnew and an update for each record won't give a noticeable lag in performance. If it were 1100 or 11000 the story would be different.

You could also look into ADO's UpdateBatch method.



I used to rock and roll every night and party every day. Then it was every other day. Now I'm lucky if I can find 30 minutes a week in which to get funky. - Homer Simpson