Sign in to follow this  
Followers 0
Stormrage

_MySQL UDF

6 posts in this topic

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.

Posted Image

so i cant really work with it :S

any idea how to resolve it?

Share this post


Link to post
Share on other sites



#2 ·  Posted (edited)

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 by ProgAndy

*GERMAN* [note: you are not allowed to remove author / modified info from my UDFs]My UDFs:[_SetImageBinaryToCtrl] [_TaskDialog] [AutoItObject] [Animated GIF (GDI+)] [ClipPut for Image] [FreeImage] [GDI32 UDFs] [GDIPlus Progressbar] [Hotkey-Selector] [Multiline Inputbox] [MySQL without ODBC] [RichEdit UDFs] [SpeechAPI Example] [WinHTTP]UDFs included in AutoIt: FTP_Ex (as FTPEx), _WinAPI_SetLayeredWindowAttributes

Share this post


Link to post
Share on other sites

thanks for the reply, im looking forward.

Share this post


Link to post
Share on other sites

#4 ·  Posted (edited)

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 by Stormrage

Share this post


Link to post
Share on other sites

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.

*GERMAN* [note: you are not allowed to remove author / modified info from my UDFs]My UDFs:[_SetImageBinaryToCtrl] [_TaskDialog] [AutoItObject] [Animated GIF (GDI+)] [ClipPut for Image] [FreeImage] [GDI32 UDFs] [GDIPlus Progressbar] [Hotkey-Selector] [Multiline Inputbox] [MySQL without ODBC] [RichEdit UDFs] [SpeechAPI Example] [WinHTTP]UDFs included in AutoIt: FTP_Ex (as FTPEx), _WinAPI_SetLayeredWindowAttributes

Share this post


Link to post
Share on other sites

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)

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  
Followers 0