Perform Multi-Record Updates with a Single Submit

[Skee777]

Is there an easy way that to perform a multi-record update using a single submit in ASP?

Basically I have a form that is created using a query. It is built by bringing back multiple records as text boxes. I then what to change the information on a few of the text boxes and click submit to have the modifications posted to the database. The problem I am having is that because a number of the fields are named the same, the posting data comes in a comma delimited string.

I have tried using a recommendation from microsoft, but the scipt is dated and does not work for me with the current technology.

http://msdn.microsoft.com/library/d...ry/en-us/dnasdj00/html/multiRecordUpdates.asp

If you have a minute and can offer some assistance, I would greatly appreciate it. I can't imagine that I'm the first person who needs this feature and I'm hoping you might have run across it at some point.

 

[Bastien]

Hi

Make sure you have a LockType of adLockBatchOptimistic set for the recordset and then use RS.UpdateBatch adEffectAll (if you have the adovbs.inc file included in your project)

A good book here is Sams Teach Yourself Active Web Database Programming in 21 Days. I found it most helpful. ISBN = 1-57521-139-4

hth
Bastien

There are many ways to skin this cat,
but it still tastes like chicken