populating recordset with array? 1

[mmaz]

Is it possible to create a recordset and populate it with an array? If so, what is the syntax?

Thanks!

Marie

 

[wushutwist]

Are you creating the RecordSet for the purpose of inserting records into a Database? If so then I suggest going with a straight SQL Statement sent to the RDBMS, much easier (IMO) and more efficient. Wushutwist

 

[dianal]

Some quick and dirty code

<%
Dim myarr 'for storing array
Dim rs 'for recordset

'Initialization
myarr = Array (1, &quot;John&quot;, &quot;Smith&quot;, 33, 20000)
rs = CreateObject(&quot;ADODB.Recordset&quot

'Recordet is populated with whole array
rs = myarr

'Some output for testing

Response.Write &quot;<b>Array</b>&quot; & &quot;<br>&quot; & VBCrLf
for i = 0 to 4
Response.Write myarr(i) & &quot; &quot;
next
Response.Write &quot;<br>&quot; & VBCrLf

Response.Write &quot;<b>Recordset</b>&quot; & &quot;<br>&quot; & VBCrLf
for i = 0 to 4
Response.Write rs(i) & &quot; &quot;
next

%>

See if suits your needs.
D.

 

[phildownunder]

hi
have you tried getrows method of the recordset
phil