Update problem

I used the below code to update the reservation list. But the problem is these code got problem. See attachment ( http://www.codingforums.com/attachment.php?s=&postid=149 684). After I put 2, 5, 10 under quantity column, all quantity value will become 10. I think it takes the last value and update to all records. So, how do I fix it? Thanks.

<%
qty = Request("quantity_fr")
ids = Split( strProductID, ", " ) ' that is COMMA-SPACE
qtys = Split( qty, ", " ) ' that is COMMA-SPACE

For ix = 0 To UBound(ids)
id = ids(ix)
qty = qtys(ix)
SQL = "UPDATE reservationdetails INNER JOIN reservation ON ReservationDetails.ReservationID = Reservation.ReservationID "
SQL = SQL & "SET Quantity = " & qty & " WHERE status = 'temp' "
conn.Execute( SQL )
Next
Response.Write "OK Done!"
response.end

Still the same result.

Actually, I got 2 tables.

1. Reservation (ReservationID, CustomerID, Reserved_Date, Discount)

2. ReservationDetails (ReservationDetailsID, ReservationID, ProductID, Quantity, Status)

When I add the items to list, the code will insert those items into these 2 tables and set quantity = 0 and status = temp.

Then, when I click view reservation list page, it will display all items added into list under that customerID (session).

So, all quantity at this time is 0 and user will update that quantity and lastly update as batch (which is my initial problem).

Hope this is much clearer. So, how do update as batch here? I will appreciate all help.