declaring arrays in vbscript

[MartDawg]

I need to declare an array in vbscript...

The number of elements in an array will be the value of a recordset that comes back...

Here's my code. It doesn't like the last line. Any hints?


dim count
gettypecount="select count(*) from Sometable"
set thecount=conn.execute(gettypecount)
count=thecount(0)

Dim CompType(count)

 

[JohnYingling]

Dim CompType()
dim count
gettypecount="select count(*) from Sometable"
set thecount=conn.execute(gettypecount)
count=thecount(0)
if count > 0 then
ReDim CompType(count - 1)
End if

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing

http://www.VBCompare.com

Compare Code

http://www.VBSortGen.com

Generate Sort Class in VB

http://www.Vbcompare.com/Check.Htm(1979

Check To MS)