Variabel størrelse array

Du skal bruge redim
http://www.devguru.com/Technologies/vbscript/quickref/redim.html

Et variabelt størrelse array erklæres:
dim myArray() as string

ja, referencen er godt nok til noget VBScript, men melodien er den samme

Det prøvede jeg også, Mads, med denne:
Dim sngMulti(0 To rst2.EOF) As String

tofte, jeg ønsker jo ikke at redimensionere arrayet, bare sætte det "med det samme", udfra hvor mange resultater der kommer tilbage fra SQL'en.
Beklager fejlen i ovenstående, jeg mente jo selvfølgelig:
Dim myArray(0 To rst.RecordCount -1) As String

Declaring a Dynamic Array
By declaring a dynamic array, you can size the array while the code is running. Use a Static, Dim, Private, or Public statement to declare an array, leaving the parentheses empty, as shown in the following example.

Dim sngArray() As Single

Note  You can use the ReDim statement to declare an array implicitly within a procedure. Be careful not to misspell the name of the array when you use the ReDim statement. Even if the Option Explicit statement is included in the module, a second array will be created.

In a procedure within the array's scope, use the ReDim statement to change the number of dimensions, to define the number of elements, and to define the upper and lower bounds for each dimension. You can use the ReDim statement to change the dynamic array as often as necessary. However, each time you do this, the existing values in the array are lost. Use ReDim Preserve to expand an array while preserving existing values in the array. For example, the following statement enlarges the array varArray by 10 elements without losing the current values of the original elements.

ReDim Preserve varArray(UBound(varArray) + 10)

Note  When you use the Preserve keyword with a dynamic array, you can change only the upper bound of the last dimension, but you can't change the number of dimensions.

Private sub DinProc
Dim MyArray() As Integer 
...
...
Redim MyArray(0 to rst2.recordcount)   
...
End sub

Nemlig....

Takker