Peter J. Boettcher — Tue, 21 May 2002 22:20:50 +0000

It's not much different, you still have to create your recordset:

Set MyRS = Server.CreateObject(ADODB.RecordSet)

Then create your fields:

With MyRS
.Fields.Append "FieldOne", adInteger
.Fields.Append "FieldTwo", adInteger
End With

Then populate your fields:

With MyRS
.Open
.AddNew
.Fields.Item("FieldOne") = 64
.Fields.Item("FieldTwo") = 128
.Update
.MoveNext
End With

Hope that helps. You should consider just passing everything to the sproc and skip creating the recordset if possible.