SQL AND ARRAYS

[bigbadbob]

the problem is that i dont know the code to select all the records in one column and put one record to a slo in the aray so like:
array(0)=record 1
array(1)=record 2
u kno what i mean i am really stuck with this i have made the connections and uses the connection to redim some arrays but i just can fiugure this bit of code

 

[codestorm]

Using ADO, how bout

dim vnt_ArrayFromRecordset
dim obj_Recordset
set vnt_ArrayFromRecordset = obj_Recordset.GetRows

(or just look up the GetRows function in VB) <insert witticism here>
codestorm