3 replies to this topic

[GNGNUT]

Hi Guys

i need a little bit of help and advice on some code im trying to use to retrive data from sql 2008 r2 i can connect to my data base but cant seem to get any data back

im using MYsql from cdkid and have attached the file for you guys to have a look though

Please Help


this is the error i keep getting

C:\Program Files (x86)\AutoIt3\Include\Mysql.au3 (52) : ==> The requested action with this object has failed.:
Return $oConnectionobj.execute ($sQuery)
Return $oConnectionobj.execute ($sQuery)^ ERROR

$sUsername = "sa"
$sPassword = "####"
$sDatabase = "Testing"
$sServer = "(local)"
$sDriver = "{SQL Server}"
$iPort = 3306 

$sql = _MySQLConnect($sUsername, $sPassword, $sDatabase, $sServer, $sDriver) ; $iPort)
;msgbox(0,"connected to server", $sql   & ' - Error ' & @error,2)   ;=> confirm connection works 
$result = _Query($sql,$sQuery) msgbox (0,@error,$result.field(" Name ").value,0)    ;=> Value from the Sql query _MySQLEnd($sql)

Attached Files

•  Mysql.au3   18.99K   85 downloads

[jchd]

And the content of $sQuery is ???

I agree to give you your data back, says MySQL, but at the very least ask for it GNGNUT!

[GNGNUT]

$sQuery = "select dob from Persons where address='tonbridge'"

[jchd]

Is that supposed (garanteed) to give you back a non-empty resultset?

I believe you can test for that with .EOF() function on the resultset:

If $result.EOF() Then
  ; no row for this SELECT
Else
  ; process rows as needed
EndIf

At least this used to work with all ADO (~ODBC) interface I know of.