Need a Dynamic multi-dimentional array to load items from a database.
length1 = 1
Set RS = MyConn.Execute(strSQL)
while not RS.eof
redim preserve tempArray(length,4)
length = length + 1
But keep getting error:
Subscript out of range
indicating the redim line.
When trying to declare a multi-dimentional array with a variable,
I get the error message:
Expected integer constant
/TemplateTesting/sendNewsletter2.asp, line 75
So it requires a constant!! How can I get round this problem. I have a database items, each with a dimention of four items which change from day to day depending on additions and deletions... so I need an array with a dynamic length and four dimentions.