[thelist] Multiple updates - ASP

[Matt MacLeod]

What I really meant was entering different values for specific records.

For example, if someone has ordered an apple and an orange I need to take 1
from the stock column for apples and oranges.
The way I have the information displayed on the page is a table showing the
customer's order. In the table, the product name, number ordered, and
updated stock numbers are displayed. I have looped through the recordset so
that each item within the customer's order has been displayed.
I want to be able to hit one submit button and have each record updated
with the new stock level.
Help...please!
Matt

At 18:09 31/10/02 +0300, you wrote:
>using the UPDATE sql statement yu can update multiple records.
>for eg.
>
>Update authors
>Set name = "gorilla"
>
>this statement will update all author names to "gorilla"
>
>Look up the keyword UPDATE in the acces manual...
>
>------
>Ashok Hariharan
>http://www.unganisha.org
>------
>
>
>
>--
>For unsubscribe and other options, including
>the Tip Harvester and archive of thelist go to:
>http://lists.evolt.org Workers of the Web, evolt !