Hi everyone.
SQLAlchemy 0.5.3
TurboGears 2.0
MySQL
Windows
I am trying to execute a stored procedure call from my controller using:
result = conn.execute("CALL test_2resultsets").fetchall()
However, result will only hold the first result set. I was anticipating
result holding all of the result sets. In this case, the test stored
procedure is returning 2 separate result sets.
Is there a separate call I have to make to pull the second result set?
I have included the stored procedure code below.
delimiter //
CREATE PROCEDURE test_2resultsets ()
BEGIN
SELECT 1 AS my_id, 'Rodney' AS my_name;
SELECT 2 AS her_id, 'Angela' AS her_name;
END;
//
delimiter ;
Thanks for any help.
-Rodney
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
