Topic awaiting preservation: ASP and Arrays (Page 1 of 1)

Hi there, I'm having troublw using arrays,

I want to create a dynamic array based on the amount of records I have in a table, so I wrote a piece of code like this...

SQL = "SELECT * FROM Table"

SET Rs = Server.CreateObject("ADODB.Recordset")

Rs.Open SQL, conn



I = 0



WHILE NOT Rs.EOF

 I = I + 1

 Rs.MoveNext

WEND

IF NOT Rs.BOF THEN Rs.MoveFirst



Dim fDayq(I)

Here you can see that I want fDayq to be my dynamic array and to have 'I' possibillities.

This doesn't work and I get an error 'Expected integer constant' where 'I' is so I guess I'm not doing this the right way, is there a way to create a dynamic array in ASP, what are the constraints?

TIA

Blaise.

Well gues what I managed to find the answer in the end (finally!)

My code now looks like this...

Dim fday()



SQL = "SELECT * FROM Table"

SET Rs = Server.CreateObject("ADODB.Recordset")

Rs.Open SQL, conn



I = 0



WHILE NOT Rs.EOF

 I = I + 1

 Rs.MoveNext

WEND

IF NOT Rs.BOF THEN Rs.MoveFirst



ReDim fDayq(I)

So to use a dynamic array you must first 'Dim' your variable with enpty parenthesis '()' then use the 'ReDim' term to assign how many items are in the array, hence 'ReDim fDayq(I)'

Well I hope this helps someone else!

Cya

Blaise.