[thelist] writing to existing array with VBScript

[Joel D Canfield]

I'm creating an empty array, then looping thru the results of a database
query, writing the array elements as I go (for later use.) Here's what I've
got:

	aryEmps = Array()
	i=0
	Do While Not ListEmps.EOF
		strEmpID = ListEmps("EmpID")
		aryEmps(i) = strEmpID
		ListEmps.MoveNext
		i = i + 1
	Loop

I'm getting the expected results from my query, but this line

	aryEmps(i) = strEmpID

returns the error

	Type mismatch: 'aryEmps'

How do I write to the existing array values? I'm assuming I can say

	aryEmps(0) = "myNewValue"

to set it, increment the value in the parentheses, and loop, but I can't
find any comments on the exact syntax, so I could we way off.

Thanks.

Joel at spinhead.com