View Single Post
  #2 (permalink)  
Old June 1st, 2007, 08:09 AM
ublend ublend is offline
Authorized User
 
Join Date: Mar 2007
Location: , , .
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quick thanks to all who viewed my question --
I figured out that I was overthinking the process when the solution was pretty simple. The key to it was remembering that the dynamic form element names are always the same as the dynamic table field names for this application. Here is a sample of the code for those who may ask the same question in the future:
Set RSC = Server.CreateObject("ADODB.Recordset")
RSC.Open myTable, Conn, 2, 2
      RSC.addnew
      For ix = 1 to Request.Form.Count-1
      RSC(Request.Form.Key(ix)) = Request.Form.Item(ix)
    Next
    RSC.update
RSC.close


Reply With Quote