Jump to content

Autoit - Not working with MySQL procedures?


Recommended Posts

Hello,

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 

_EzMySql_GetTable2d

 

 

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:

FJYXfYg.png

 

 

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

   Exit
EndIf

 

 

 

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...