Hi,

this is probably a beginner question...

I'm using ASP3.0 (project isn't yet .net)
We want to have an array-like structure that is dynamic in size. We currently have something like:
dim myArray(5)
but I'd like it to be like:
dim mySize : mySize = 5
dim myArray( mySize )

...the system complains. I tried a "redim", but it still didn't like it. What should I do?

Thanks in advance!

it's simply redim myArray(size)

what didn't it "like" ?

thanks for the relpy.

After re-examining the code, I discovered that my problem wasn't with the "redim", but rather with a function that depended on references several arrays. If I did the redim on once array, but didn't take into account how it affected the other arrays, then I was getting a "locked" message.

Though, thanks to your comment, I revisited it and saw what was happening. Now it's working :-)

Thanks.

A redim on one array shouldn't affect other arrays, unless you're using single-dimensional arrays inside of single-dimensional array.

If that's the case, a two-dimensional array would work a lot better.

e.g.

Dim myArray (5, 6)

Will give you an array of 6 horizontal items x 7 vertical items (since arrays start at 0).

If you ever use the GetRows property of the recordset object to retrieve info (great way to do it, by the way), it will output the results to a 2-dimensional array. So you may want to start by playing with that.

e.g.

SQL_Query = "some query"
RS.Open SQL_Query
myArray = RS.GetRows()
RS.Close

But, if it's working, it's working. So you may not want to mess with it too much.