Executing Query with Autoit

[Hiutaky]

Hi all ,

i'm using mysql.au3 UDF to make a script .

Now , when i'm adding value on the database it's all ok , but , when i search in it i don't recive the success value.

Here the code :

Global $_conn = _MySQLConnect($_sql_user, $_sql_pass, $_sql_db, $_sql_server)
$_r_p_query = ("SELECT Points FROM User_Points WHERE ID=1")
$_res = _Query($_conn, $_r_p_query)
MsgBox(0, "asd", $_res)

if i execute this query :

SELECT Points FROM User_Points WHERE ID=1

on navicat i get the value.

Thx

[jchd]

Post your schema and the code you use for insert(s).

[MHz]

If mysql.udf is the udf created by cdkid >here then I may expect $_res to be a COM object. If so, then examples exist in that topic of how to access info from the COM object.

[Hiutaky]

Post your schema and the code you use for insert(s).

To insert data into database i use this :

("INSERT INTO `User` VALUES ('" & $_r_record & "', '" & $_g_username[0] & "', '" & $_g_name[0] & "');

This is the DB Schema :

[jchd]

The result of a query is an array.

[Hiutaky]

I tried , but it gave me error :

"C:\Users\hiutaky\Desktop\AUTOIT\AskLike\testsql.au3" (19) : ==> Subscript used on non-accessible variable.:
MsgBox(0, "asd", $_res[0])
MsgBox(0, "asd", $_res^ ERROR

[Hiutaky]

#cs
    Function name: _Query
    Description:     Send a query to the database
    Parameter(s):  $oConnectionObj - As returned by _MySQLConnect. $query - The query to execute
    Return Value(s):On success returns the query result. On failure returns 0 and sets @error to 1
    Requirement(s):Autoit3 with COM support
    Author(s):        cdid
#ce

[jchd]

Then I run out of ideas from where I sit.

EDIT: oops, I'm so much used to higher-level functions that I overlook the need for walking thru the resultset!

Edited December 31, 2013 by jchd

[kylomas]

Hiutaky,

This is directly out of the thread that MHz pointed you to...

$sql = _MySQLConnect("sa", "sa", "mydb", "mywebsite.com")
$var = _Query($sql, "SELECT * FROM mytable WHERE user = 'username'")
With $var
    While Not .EOF
        FileWriteLine("c:\test.txt", .Fields("user_name").value & @CRLF)
        .MoveNext
    WEnd
EndWith
_MySQLEnd($sql)

[Hiutaky]

Solved , i got the value by database , but now , it gave me this error :

"C:UsershiutakyDesktopAUTOITAskLiketastsql3.au3" (16) : ==> Only Object-type variables allowed in a "With" statement.:
With $TableContents
With ^ ERROR

[jchd]

Add error checking.

[jdelaney]

If IsObj($TableContents) Then
    With $TableContents
    EndWith
EndIf