SQL syntax

[dazza]

$sqlCon = ObjCreate("ADODB.Connection")
$sqlCon.Open("Driver={SQL Server};Server=99.99.99.99;Database=inventory;Uid=id_name;Pwd=password;")
$RS=$sqlCon.EXECUTE("SELECT * FROM tblClass WHERE intClassTypeId = 125")

How do I put the results of the query into a string?

Many thanks.

Edited December 11, 2008 by dazza

[James]

You have. $RS now equals the value of the query you executed.

ConsoleWrite($RS & @CRLF)

Put that beneath the query.

[weaponx]

You have. $RS now equals the value of the query you executed.

ConsoleWrite($RS & @CRLF)

Put that beneath the query.

This is way off.

The Execute method returns a recordset object

While Not $RS.EOF
ConsoleWrite($RS.fields("column") & @CRLF);By column name
ConsoleWrite($RS.fields(0) & @CRLF);By index
$RS.MoveNext
WEnd