|
|
|
|
|
| | |
| |
Active Server Pages what is asp programming how to sample asp example code scripts software asp forum mail sessions applications global.asa CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Update Multiple Records |
|
From: |
Nate Wittasek |
|
Date: |
9/24/2000 7:41:08 PM |
|
IP: |
24.8.131.202 |
I would like to be able to update a single table containing multiple records at one time. In some cases, I may have two or more records that are retrieved from the table for the purposes of updating them using only one update button. However, when I try to use the update command, I am getting an error (Data type mismatch in criteria expression). I think it is because the update is trying to update one recordset with two values, and so inserts a comma between the multiple values.
When I tried to use a For each, next command to iterate through the recordsets, the error was returned ("Object not part of a collection").
So how do I perform a multiple record update anyway? |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
