Php Tunnel Not For Stored Procedures

[Nicky Larstrup]

I've tried SQLyog and found a small but very annoying issue. It gives trouble, when trying to run a Stores Procedure wich gives data back to the client.

The error code is this:

Error Code : 1312

PROCEDURE testdb.sp_PostCount can't return a result set in the given context

The stored procedure:

CREATE PROCEDURE `sp_PostCount`()

BEGIN

DECLARE message_count_1,message_count_2,comment_count,linksxchange_count INT;

SELECT COUNT(id) INTO message_count_1 FROM message where deleted=0 and id_user=1;

SELECT COUNT(id) INTO message_count_2 FROM message where deleted=0 and id_user=2;

SELECT COUNT(id) INTO comment_count FROM comment where deleted=0;

SELECT COUNT(id) INTO linksxchange_count FROM linksxchange where deleted=0;

SELECT message_count_1,message_count_2,comment_count,linksxchange_count;

END$$

As far as i have read on the php and mysql forums, it's the use of the mysql instead of the mysqli connector. And the fact that php, as a standard, comes with older mysql connectors made for the 4x branch of mysql.

It would be just great if you could find the time to implement mysqli in your php tunnel.

Other than that, i can't find anything to complain about. SQLyog is just the greatest mysql manager made. Thanks.

Cheers,

Nicky Larstrup

[peterlaursen]

We don't support 'returns' form a SP yet.

Please refer to: http://www.webyog.com/faq/14_81_en.html

Hope to fix it soon!

[Nicky Larstrup]

Thanks for your fast answer.

Didn't see that in the FAQ – Maybe i should read that more carefully before writing in here the next time :o)

Cheers

Nicky Larstrup

[Author]

Posts