INSERT Multiple rows to database
I am using .asp classic NOT .NET!
I have a database called "oddlistorders" that users add to it when they shop around and select certain products. Once done, they can view thier cart which is the "oddlistorders" database.
I then need to take all that they ordered which each row has a unique user ID and customer code and pass it to another database called "oddlistprocessed".
They problem is, it works fine if thwy only order ONE item (one row of data), but if they order more than one item, I cant inssert more than one row at a time.
Here is what I use now which works perfectly for ONE item:
quantity = Request.Form("quantity")
sql= "Update oddlist Set quantity='"& quantity & "' WHERE user_ID=" & ID
Rs.Open sql, Conn
Set Conn = Nothing