Re: Include a stored procedure ( that returns a recordset ) in another query

2007-01-22 Thread Paul DuBois
At 3:00 PM +1100 1/22/07, Daniel Kasak wrote: Hi all. I'd like to be able to define a stored procedure that returns a recordset ( I've done this bit ), and then select from this in another query, eg: CREATE [EMAIL PROTECTED] PROCEDURE `sp_MyClients`( IN ACCMAN INT ) BEGIN select * from

Include a stored procedure ( that returns a recordset ) in another query

2007-01-21 Thread Daniel Kasak
Hi all. I'd like to be able to define a stored procedure that returns a recordset ( I've done this bit ), and then select from this in another query, eg: CREATE [EMAIL PROTECTED] PROCEDURE `sp_MyClients`( IN ACCMAN INT ) BEGIN select * from mirror_Clients where AccMan = ACCMAN; END ... and