Jump to content

Autoit - Not working with MySQL procedures?

Recommended Posts


I am using a lot Autoit to make some SELECT/INSERT operation on a Mysql database using this UDF made by @Yoriz who is similar with the udf made by @ProgAndy




No problem until now using 




Now I have created in Mysql a procedure that i want to call with autoit and to get a 2d array.


The sql statment is: "CALL sp_GetResultByDate('2018-01-02', '2018-01-02');"

If i run the statement on Adminer on another server (not localhost) I get the table: Bg2VpFi.png 




But If I run with Autoit I get the following error:




My code is:

If Not _EzMySql_GetTable2d("CALL sp_GetResultByDate('2018-01-02', '2018-01-02');") Then
MsgBox(0, "Query Error", "Error: "& @error & @CR & "Error string: " & _EzMySql_ErrMsg())





Can anybody help me please?


Link to post
Share on other sites
  • 1 month later...

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
  • Recently Browsing   0 members

    No registered users viewing this page.

  • Create New...