HElp with query in Sql server

[tamagogi 0]

Hi, I have a problem inside a query with sql server. When i execute and i success with data then all right. When the query have no data has result my project crash. I use this code:

$conn = ObjCreate("ADODB.Connection")

$DSN = "DRIVER={SQL Server};" & "SERVER=XX.XX.XX.XX\SQLEXPRESS;DATABASE=Test;UID=SA;PWD=password;"

$rs = ObjCreate("ADODB.RecordSet")

$conn.Open($DSN)

$rs=$conn.EXECUTE("SELECT * from table where ....")

if $rs.RecordCount<>0 Then

MsgBox(1,"Found",$rs.Fields("value").Value)

EndIf

$rs.close

$conn.close

error is:

The requested action with this object has failed.:

$hQuery = $hConHandle.Execute($vQuery)

$hQuery = $hConHandle.Execute($vQuery)^ ERROR

thanks and sorry for my english

[ChrisL 11]

Have a look here at my UDF for SQL http://www.autoitscript.com/forum/index.php?showtopic=51952#

It has an error handler to prevent hard crashes and provide feedback on the errors.

Edited April 30, 2009 by ChrisL

[tamagogi 0]

Many thanks