I have a vbscript used to run a sql query...
In the past I have the whole results placed in memory (variable) and then write it to a file in the end.
I need to change this to write to the file as it reads it (writeline...comma separated)
The sql query returns 10 columns and hundreds of rows
anyone have any idea
(the old piece of code for the sql query section is below)
Set objConn = CreateObject("ADODB.Connection")
objConn.ConnectionTimeout = 0
objConn.CommandTimeout = 0
Set objRS = CreateObject("ADODB.Recordset")
objConn.Open StrConnectStringset objRS = objConn.Execute (arrlist)
intCount = 0
Do While Not objRS.EOF
nRow = nRow + 1
For i = 0 to objRS.Fields.Count - 1
stat1 = stat1 & objRS.Fields(i) & ","