Jump to content
Sign in to follow this  
EddieAdams

MySQL connection

Recommended Posts

EddieAdams

Script below gives this error, any idea? The variable $TableContents has value 0 after query. Don't know if it has even made connection to the database, i assume it did.

CODE
Temp.au3 (15) : ==> Only Object-type variables allowed in a "With" statement.:

With $TableContents

With ^ ERROR

CODE
#include "MySQL.au3"

$UserName = "root"

$Password = ""

$Database = "db"

$MySQLServerName = "localhost"

$SQLInstance = _MySQLConnect($UserName,$Password,$Database,$MySQLServerName)

$SQLCode = "SELECT * FROM tbl"

$TableContents = _Query($SQLInstance, $SQLCode)

With $TableContents

While Not .EOF

$NameList &= .Fields ("columnname") & @CRLF

.MoveNext

WEnd

EndWith

_MySQLEnd($sql)

MsgBox(0,"Guest List",$NameList)

Share this post


Link to post
Share on other sites
BrettF
EddieAdams

Object referenced outside a "With" statement.

Share this post


Link to post
Share on other sites
EddieAdams

Object referenced outside a "With" statement.

The With statement was in an example on this forum.

Share this post


Link to post
Share on other sites
EddieAdams

I mean, it was an original example script.

Share this post


Link to post
Share on other sites
PsaltyDS

Object referenced outside a "With" statement.

Then put it inside the "With" statement:
If IsObj($TableContents) Then
    With $TableContents
        While 1
            $NameList &= .Fields("columnname") & @CRLF
            .MoveNext
            If .EOF Then ExitLoop
        WEnd
    EndWith
Else
    MsgBox(16, "Error", "$TableContents is not an object.")
EndIf

:P


Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law

Share this post


Link to post
Share on other sites
EddieAdams

Got it working now. Did not install mysql-connector-odbc-3.51.26-win32.exe.

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×