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

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


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

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

Rs.Open sql, Conn

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

End With

Set Rs=Nothing
Set Conn = Nothing