View Single Post
  #3 (permalink)  
Old April 10th, 2007, 08:53 AM
jonsey jonsey is offline
Authorized User
 
Join Date: Jan 2007
Location: , , USA.
Posts: 11
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via AIM to jonsey Send a message via Yahoo to jonsey
Default

I normally use Class but it think this may help or at less give you some option I have used the With method to right multi rows to DB

Code:

            <%
Dim quantity
quantity = Request.Form("quantity")

sql= "Update oddlist Set quantity='"& quantity & "' WHERE user_ID=" & ID

Rs.Open sql, Conn

With Rs
.AddNew()
                    .Fields("DBField1") = Request.Form("FormData1")
                    .Fields("DBField2") = Request.Form("FormData2")
                    .Fields("DBField3") = Request.Form("FormData3")
                    .Fields("DBField4") = Request.Form("FormData4")

                .Update()
End With

Conn.Close
Set Rs=Nothing
Set Conn = Nothing

%>


Reply With Quote