SQL output more than 1 row
Hi
I have a query which should return multiple rows from a database. I want to write these to file. However, my code only seems to output a single row.
How would i go about writing all the rows the query returns?
Thanks
; Specify an ini file to write to
$sIni = @ScriptDir & "\Documents.ini"
; Connect to the database
$conn = ObjCreate( "ADODB.Connection" )
$DSN = "DRIVER={SQL Server};SERVER=server1;DATABASE=database1;UID=test1;PWD=test1;"
$conn.Open($DSN)
;Create record set an
Searching this forum should give you answer too
; Specify an ini file to write to
$sIni = @ScriptDir & "\Documents.ini"
; Connect to the database
$conn = ObjCreate( "ADODB.Connection" )
$DSN = "DRIVER={SQL Server};SERVER=server1;DATABASE=database1;UID=test1;PWD=test1;"
$conn.Open($DSN)
;Create record set and run query
$rs = ObjCreate("ADODB.RecordSet")
$rs.Open("select filename+'.pdf' 'file' from test where id > 0", $conn)
If $RS.RecordCount Then
While Not $RS.EOF
Consolewrite(