Skip navigation links

MySQL Forums :: Stored Procedures :: Problem Stored Procedure Count


Advanced Search

Problem Stored Procedure Count
Posted by: re der ()
Date: May 05, 2013 07:01AM

Hello
this is my first post.
I'm migrating a query this on an ASP page to the MySQL engine, with phpmyadmin.

The problem is that I do not get any results, where am I wrong?
This is the SP:

DELIMITER $$
DROP PROCEDURE IF EXISTS `anc_ese`.`sp_count_soci_italia` $$
CREATE PROCEDURE `sp_count_soci_italia`(
IN stranno VARCHAR(10),
OUT TotalCount INT
)
BEGIN
SELECT COUNT(*)
INTO TotalCount
FROM soci
WHERE datai like CONCAT('%', @stranno, '%');
SELECT @TotalCount;
END $$
DELIMITER ;



Edited 1 time(s). Last edit at 05/05/2013 07:10AM by re der.

Options: ReplyQuote


Subject Views Written By Posted
Problem Stored Procedure Count 975 re der 05/05/2013 07:01AM
Re: Problem Stored Procedure Count 432 Peter Brawley 05/05/2013 09:38AM
Re: Problem Stored Procedure Count 422 re der 05/05/2013 04:25PM
Re: Problem Stored Procedure Count 389 Peter Brawley 05/05/2013 08:43PM
Re: Problem Stored Procedure Count 381 re der 05/06/2013 10:48AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.