_MySQL UDF

[Stormrage]

Hi!

i got a problem with the example script of _MySQL UDF

$query = "SELECT * FROM vp_nameparts;"
_MySQL_Real_Query($MysqlConn, $query)


$res = _MySQL_Store_Result($MysqlConn)

$fields = _MySQL_Num_Fields($res)

$rows = _MySQL_Num_Rows($res)
MsgBox(0, "", "rows: " & $rows & " fields: " & $fields)

Problem is that, it returns me rows 2928349283492983489 or something like that, when i have exctly 22 rows in total.

so i cant really work with it :S

any idea how to resolve it?

[ProgAndy]

Oh yeah. In previous AutoIt-Versions, the return of uint64 was wrong, so I included a func to fix it. Now the bug in AutoIt was fixed and my func returns now a wrong number. I'll reupload it now Done

PS: your query has a result of 57 rows.

Edited January 1, 2010 by ProgAndy

[Stormrage]

thanks for the reply, im looking forward.

[Stormrage]

ohh, another problem occured (and sorry for pm)

mysql.au3 (460) : ==> Variable used without being declared.:
If Not $MySQL_ptr Then Return SetError(3,0,0)
If Not ^ ERROR
>Exit code: 1    Time: 24.118

when i run the test.au3 in your package

Edited January 1, 2010 by Stormrage

[ProgAndy]

ohh, another problem occured (and sorry for pm)

mysql.au3 (460) : ==> Variable used without being declared.:
If Not $MySQL_ptr Then Return SetError(3,0,0)
If Not ^ ERROR
>Exit code: 1    Time: 24.118

when i run the test.au3 in your package

Oh no. A copy&paste error and i didn't use that particular function in my testscript... Please download again, it should be fixed now.

[Stormrage]

thanks again:)

I'm just learning how to use AutoIt and the MySQL UDF together and best way to learn to see examples (and also the official mysql api for the function descriptions and so on)