getting output values from procedures

[jerry kendall]

Hi all.



I have being exploring stored procedures using the C API.

How do you get output values from the procedures back into the calling 'C' program?

I know you create a stored procedure and add OUT/INOUT params.

CREATE PROCEDURE MyCount (IN tag TEXT, OUT cnt INT)
BEGIN
SELECT COUNT(*) INTO cnt FROM tbl WHERE tagname = tag;
END

But when calling from the C API, how do you get the cnt value ?


long Count = 0;
normally, rc = mysql_query(connection, "CALL MyCount("A1", Count)");


I have tried a few things but can't seem to make it work.

--
Jerry Kendall, CISSP
[e-mail]
Pentego technologies Ltd.
www.pentego.com