I'm kinda new to this program. I loved it's compatibilities and how you can blend it and combine this program whit other programs to get your results and what your looking for done.
I'm making a program, which in some part of the program it must connect to a remote server and obtain some information from MySQL database running on that server.
i did find this topic very helpful ==> http://www.autoitscript.com/forum/topic/20814-mysql-udfs/
i tested it, and it did what i wanted, but only in my testing script.
If i combine the test script with my original script, i'm getting this error in my console :
==> Only Object-type variables allowed in a "With" statement.:
With ^ ERROR
the code i'm using in my script ( which runs flawlessly in a separate au3 file )is :
$MYSQLUserName = "root" $MYSQLPassword = "pass" $MYSQLDatabase = "auth" $MySQLServerName = "127.0.0.1" $SQLInstance = _MySQLConnect($MYSQLUserName,$MYSQLPassword,$MYSQLDatabase,$MySQLServerName) $SQLCode = "SELECT * FROM realmlist" $TableContents = _Query($SQLInstance,$SQLCode) With $TableContents While Not .EOF $NameList = .Fields ("id").value & " " & .Fields ("name").value & @CRLF .MoveNext WEnd EndWith MsgBox(0,"Guest List",$NameList)
i'm assuming there is a conflict in my script with this code. so i'm adding all my includes :
and i did reinstall my ODBC, as "oshaker" mentioned in this topic :
Thanks for your help.
Edited by Siwa, 27 April 2012 - 01:13 PM.