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 853 re der 05/05/2013 07:01AM
Re: Problem Stored Procedure Count 381 Peter Brawley 05/05/2013 09:38AM
Re: Problem Stored Procedure Count 373 re der 05/05/2013 04:25PM
Re: Problem Stored Procedure Count 344 Peter Brawley 05/05/2013 08:43PM
Re: Problem Stored Procedure Count 341 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.