Jump to content
Sign in to follow this  
rony2006

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?

 

Share this post


Link to post
Share on other sites

Hello,

In my project again I saw that is necessary for me to get the table returned by a mysql procedure so any help will be appreciated.

I am willing to pay somebody just to show me how to solve my problem.

 

 

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  

  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...