Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASP / Mass Update for same ID

Status
Not open for further replies.

shruti

IS-IT--Management
Mar 2, 2002
2
US
I am working on an ASP application, I get one check for
multiple transactions, see below sample records, I take that check, and apply it to 'amount paid', then I submit that through, ASP form, I want to do 'mass' update. WATCH, App_ID, and CustomerID are same, orderID differs, employeeID
differs, amount differs. First I want pass these variables, as is to next page with updated amount, then post / update it into the 'rows' in a table where it belogs.
Any sample code helps. Thanks.
-----------------------------------
APP_ID - 54
CustomerID - OCEAN
OrderID - 10410
EmployeeID - 3353
ActualBilling - 100.00
AdjustmentsMade - 25.00
Amout Due - 75.00
Amount Paid - 25.00
Balance Due - 50.00
--------------------------------
APP_ID - 54
CustomerID - OCEAN
OrderID - 10411
EmployeeID - 4285
ActualBilling - 200.00
AdjustmentsMade - 10.00
Amout Due - 190.00
Amount Paid - 100.00
Balance Due - 90.00
--------------------------------
APP_ID - 54
CustomerID - OCEAN
OrderID - 10412
EmployeeID - 6854
ActualBilling - 50.00
AdjustmentsMade - 0
Amout Due - 50.00
Amount Paid - 25.00
Balance Due - 25.00
--------------------------------
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top