4

I am new to Stored procedure in mysql

This is the procedure for returning difference of date excluding Weekends, but it returns error

#1312 - PROCEDURE blog1.DayCount can't return a result set in the given context

This is the procedure

DROP PROCEDURE IF EXISTS daycount; 
CREATE PROCEDURE DayCount( d1 DATE, d2 DATE ) 
SELECT dd.iDiff, dd.iDiff - dd.iWeekEndDays AS iWorkDays, dd.iWeekEndDays 
FROM ( 
  SELECT 
    dd.iDiff, 
    ((dd.iWeeks * 2) +  
    IF(dd.iSatDiff >= 0 AND dd.iSatDiff < dd.iDays, 1, 0) +  
    IF (dd.iSunDiff >= 0 AND dd.iSunDiff < dd.iDays, 1, 0)) AS iWeekEndDays 
  FROM ( 
    SELECT 
      dd.iDiff, 
      FLOOR(dd.iDiff / 7) AS iWeeks, 
      dd.iDiff % 7 iDays, 
      5 - dd.iStartDay AS iSatDiff, 
      6 - dd.iStartDay AS iSunDiff 
    FROM ( 
      SELECT 
        1 + DATEDIFF(d2, d1) AS iDiff, 
        WEEKDAY(d1) AS iStartDay 
      ) AS dd 
  ) AS dd 
) AS dd ; 


CALL DayCount( '2009-8-1','2009-9-15');
OMG Ponies
  • 325,700
  • 82
  • 523
  • 502
sathish
  • 6,705
  • 3
  • 30
  • 35

1 Answers1

0

Check this stored proc in mysql console, if it works fine you should check your call from PHP. I found that same problem is happen with other people.

smg
  • 173
  • 1
  • 8