MySQL connection

[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)

[BrettF]

I'd probably go with

While 1

...Do stuff...

If .EOF Then ExitLoop

Wend

I think that would work... muttley

[EddieAdams]

Object referenced outside a "With" statement.

[EddieAdams]

Object referenced outside a "With" statement.

The With statement was in an example on this forum.

[EddieAdams]

I mean, it was an original example script.

[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

[EddieAdams]

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