CMS Made Simple • View topic - How to CALL stored procedure in mysql on from cms module

Language:

Home FAQ Search

View unsolved topics
View unanswered posts | View active topics

Board index » Official Boards » Developers Discussion

All times are UTC

How to CALL stored procedure in mysql on from cms module

Page 1 of 1

[ 1 post ]

Print view

Previous topic | Next topic

Author

Message

cve

Post subject: How to CALL stored procedure in mysql on from cms module

Posted: Sat Mar 19, 2011 12:15 pm

Forum Members

Joined: Wed Jul 07, 2010 10:54 am
Posts: 44

Hi,
I have this code:

Code:

$db = cmsms()->GetDb();
$q = 'CALL ADD_CHILD("Kategorie", "Somethink");';
    $dbr = $db->Execute($q);
    if (!$dbr)
        echo('Error executing query: ' . $db->sql . '<br/>' . $db->ErrorMsg());

And result is:

Code:

Error executing query: CALL ADD_CHILD("Kategorie", "Somethink");
PROCEDURE cveionic_cmsms.ADD_CHILD can't return a result set in the given context 

How can I solve that???

Top

Page 1 of 1

[ 1 post ]

Board index » Official Boards » Developers Discussion

All times are UTC

Who is online

Users browsing this forum: No registered users

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to: