Hi,

Does anyone have any idea how to create an array so that I can write the recordsets into the textfile in a loop. How do I declare the array such that I write only 6 recordsets from the access database into textfiles instead of 8? Meaning I opt out 2 tables to export to textfiles.

Pls help! Thanks!

I suppose you are asking about dynamic array.

While defining array dont priovide the size.
ie,
Dim arr_var()

Then in the while loop just use redim
ie
ReDim preserve arr_var(i_count)

Where preserve is the keyword to keep the array elements as it is.
and i_count be your dynamic size.
The loop may look like this.

Dim arr_var()
Dim i_count
i_count = 1
.........
.....
While not rs.eof
  Redim preserve arr_var(i_count)
  arr_var(i_count)= rs(0)
  i_count = i_count + 1
  rs.movenext
wend


Hope this will help you.:)




Shibu Narayanan
Software Associates

Thanks Shibu!

Shibu,

How can I execute that piece of code in a function and return the entire array?

I'd like to create a function that retrieves data, loads it into an array and then returns that array? How is this accomplished in ASP?

Thanks!

There is a very simple method.

let rst be the name of the record set used to fetch data and arr be the name of array.

arr=rst.GetRows()

will fill the array with whatever records fetched by rst. It will be a two dimensional array.The first script identifies the field and second one the record number.