Why not use avoid all that looping and use GetRows()?
Dim opparray
opparray = rsItem.GetRows(-1, adBookmarkFirst)
That'll give you a two dimensional array of the data in the recordset.
See:
GetRows Method (ADO 2.7 API Reference)
http://msdn.microsoft.com/library/en-us/ado270/htm/mdmthgetr
AIL PROTECTED]]
Sent: 26 September 2002 16:19
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: Dynamically Loading Arrays
Another bit of info is I'm getting a Type Mismatch error when trying to load
the error. I have the array Dim Privately at the beginning of the page but
the array is in a Sub
check ur recordcount
-Original Message-
From: Hoenig, Robert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 26, 2002 11:41 AM
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: Dynamically Loading Arrays
I put the code in just as you have it below and I'm getting a subscript o
To: [EMAIL PROTECTED]
Subject: [wdvltalk] RE: Dynamically Loading Arrays
avoid using Redim Preserve, for ref
http://msdn.microsoft.com/library/default.asp?URL=/library/en-us/dnasp/html/
ASPtips.asp tip : 13
anywoo goin back to ur code
dim opparray
dim i
i=1
'Open ur recordset
rsItem.open sSql
avoid using Redim Preserve, for ref
http://msdn.microsoft.com/library/default.asp?URL=/library/en-us/dnasp/html/
ASPtips.asp tip : 13
anywoo goin back to ur code
dim opparray
dim i
i=1
'Open ur recordset
rsItem.open sSql,ocon,1,3
Redim opparray(rsItem.RecordCount)
Do While Not rsItem.EOF