MySQL Stored Procedures
Posted: Tue Mar 23, 2010 1:13 am
Good evening,
I am attempting to execute a stored procedure after connecting to a local MySQL database and I get the the following error:
PROCEDURE denovo.Contact_SEL_ByLastName can't return a result set in the given context
According to the documentation at the mysql site, this is because the CLIENT_MULTI_RESULTS flag is not being passed when the connection is established.
http://dev.mysql.com/doc/refman/5.1/en/ ... eries.html
Does anyone here have any experience working with MySQL stored procedures from Revolution? I am hoping there is an answer to this riddle as the database I am working with relies heavily upon stored procedures.
Thank you
I am attempting to execute a stored procedure after connecting to a local MySQL database and I get the the following error:
PROCEDURE denovo.Contact_SEL_ByLastName can't return a result set in the given context
According to the documentation at the mysql site, this is because the CLIENT_MULTI_RESULTS flag is not being passed when the connection is established.
http://dev.mysql.com/doc/refman/5.1/en/ ... eries.html
Does anyone here have any experience working with MySQL stored procedures from Revolution? I am hoping there is an answer to this riddle as the database I am working with relies heavily upon stored procedures.
Thank you