0

Hi all,

I'm trying to run a stored procedure:

BEGIN

SELECT YFR_Master_Fundraisers.FRName, YFR_Master_Fundraisers.FRActive
FROM YFR_Master
INNER JOIN YFR_Master_Fundraisers
ON YFR_Master.FundRaiser = YFR_Master_Fundraisers.FRNameCode
GROUP BY YFR_Master.FundRaiser
HAVING MAX(YFR_Master.CollectionDate) < DATE_SUB(CURDATE(),INTERVAL 2 MONTH)
AND YFR_Master_Fundraisers.FRActive = 1;

END

But I'm getting the following error:

Procedure execution failed
1312 - PROCEDURE db355379982.Deactivate can't return a result set in the given context

Does anyone know why I might be getting this?

I've never used stored procedures before.

Thanks

2
Contributors
11
Replies
24
Views
4 Years
Discussion Span
Last Post by Tinnin
0

It runs fine from php. I'm using Navicat for MySQL. Could that be the problem?

MySQL Version 5.1.67-log
PHP Version 5.2.17

0

Same user as in PHP. If you are using a different one, with different priviliges, that could cause issues.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.