How to CALL stored procedure in mysql on from cms module
Posted: Sat Mar 19, 2011 12:15 pm
Hi,
I have this code:
And result is:
How can I solve that???
I have this code:
Code: Select all
$db = cmsms()->GetDb();
$q = 'CALL ADD_CHILD("Kategorie", "Somethink");';
$dbr = $db->Execute($q);
if (!$dbr)
echo('Error executing query: ' . $db->sql . '<br/>' . $db->ErrorMsg());
Code: Select all
Error executing query: CALL ADD_CHILD("Kategorie", "Somethink");
PROCEDURE cveionic_cmsms.ADD_CHILD can't return a result set in the given context