Speed this up?

[Static]

Ive got some SQL that will be dumping large amounts of data out to CSV files for excel to open

currently I have it looping through each line and dumping it into the CSV. is there a way to get ALL the results from the SQL into one string without having to loop through?

EX:

SQL = "Select FName ||','|| LName from Customers"

[open RS here]
[Open CSV file]

Do while No Rs.EOF
Print #1, rs.fileds(0).value
loop

etc.
etc.

is there a command or something that has ALL the data without having to use the Do While?

thnx

[S@NSIS]

Have you tried rs.GetString ?

It should do what you are after.

[Static]

ok tried playing with it..cant seem to get it to work right?

How do you use it?

what about .getrows? ever try that?

[S@NSIS]

GetString is the one you want.

How is your data stored in the recordset and how do you want it to be formatted?

[Static]

Data is a Single field (comma seperated) its going to be dumped to a .CSV file for Excel to open.

I tried the get rows....then I can dump each line in a for next loop seems to be faster then going directly from the RS.


Unless I can grab all at once (with getstring) and split every 1000 lines?

0 - 1000 into first file
1001 - 2000 into 2nd etc...

thanx S@NSIS