Dos prompt to msgbox help

[mcgill]

I need some help sending the data I get from the dos prompt to my msgbox, right now its pulling my temp files. I think my run line is screwed up. I want to run the sql line and then export the data to a msgbox. Any help would be great, thanks

$hRun = Run (@comspec & " /c DIR osql -U sa -P -d Insync -Q " & $Sign & "sp_databases" & $Sign, @TempDir, @SW_SHOW, $STDOUT_CHILD)

; Read output

$sOutput = ""

While 1

$sOutput &= StdOutRead($hRun)

If @error Then ExitLoop

Sleep(50)

WEnd

; Display results

MsgBox(64, "Results", $sOutput)

[mcgill]

k, now i got it to work to send my data to the msgbox, is there a way I can clean it up to make it look pretty with the titles?

$hRun = Run ("C:\Documents and Settings\amcgill\Desktop\list.bat", "", @SW_SHOW, $STDOUT_CHILD)

; Read output

$sOutput = ""

While 1

$sOutput &= StdOutRead($hRun)

If @error Then ExitLoop

Sleep(50)

WEnd

; Display results

MsgBox(64, "Results", $sOutput)

[/dev/null]

k, now i got it to work to send my data to the msgbox, is there a way I can clean it up to make it look pretty with the titles?

how does it look like if you redirect the output into a file?

Cheers

Kurt

[mcgill]

Looks the same when I export to a file, is there a way to set width on a inputbox or msgbox so it displays correctly?

[Joon]

This is what I do to get rid of extra lines.

#include <Constants.au3>
$foo = Run(@ComSpec & " /c ipconfig", @SystemDir, @SW_HIDE, $STDERR_CHILD + $STDOUT_CHILD)
$IPConfig = ""
While 1
    $line = StringSplit(StdoutRead($foo), @CRLF)
    If @error Then ExitLoop
    For $i = 1 To UBound($line) - 1
        If $line[$i] <> "" Then $IPConfig &= $line[$i] & @LF
    Next
WEnd
MsgBox(0, "", $IPConfig)

Edited November 30, 2006 by Joon

[mcgill]

When I run this code it works but when I run it with the statement I had or point to a patch file the msgbox is empty.