Re: [PHP] Stored Proc - Date not inserting into the Record

Change the input argument type as a varchar instead of date

Ex:
CREATE DEFINER=`donw`@`` PROCEDURE `Insert_OHC_Sun`(theDate 
VARCHAR(50),theDateRaw INT)

surly it will work

- Peter


Don Wieland wrote:
> I nave 2 stored procedures:
>
> DROP PROCEDURE IF EXISTS `Insert_OHC_Sun`;
> DELIMITER $$
> CREATE DEFINER=`donw`@`` PROCEDURE `Insert_OHC_Sun`(theDate 
> DATE,theDateRaw INT)
> BEGIN
>       INSERT INTO Office_Hours_Cuttoff 
> (ohc_Date,ohc_Date_Raw,Office_Status)
>       VALUES (theDate,theDateRaw,"Closed");
> END
> $$
>
> DROP PROCEDURE IF EXISTS `Insert_OHC_Day`;
> DELIMITER $$
> CREATE DEFINER=`donw`@`` PROCEDURE `Insert_OHC_Day`(theDate 
> DATE,theDateRaw INT)
> BEGIN
>       INSERT INTO Office_Hours_Cuttoff (ohc_Date,ohc_Date_Raw)
>       VALUES (theDate,theDateRaw);
> END
> $$
>
> Then I have PHP Code to insert a YEAR of days in a table:
>
>     if($_POST['new_year'])  {
>     //New Year
>     if(in_array($_POST['pick_year'], $ExistingYears))  {
>     $Message = "<br>The year ".$_POST['pick_year']." is already 
> existing.<br>Please use the DELETE YEAR feature first. Then ADD the 
> year again.<br>";
>     } else {
>
>     //Add Year
>     $first_day = mktime(0,0,0,1, 1, $_POST['pick_year']);
>     $last_day = mktime(0,0,0,12, 31, $_POST['pick_year']);
>
>     $cDate = $first_day;
>     $num = 1;
>
>
>     while($cDate <= $last_day) {
>       
>     $nDate = Date('Y-m-d', $cDate);
>
>     $db->next_result();
>     if(date('D', $cDate) == "Sun") {
>         $db->query("CALL Insert_OHC_Sun({$nDate},{$cDate})");
>     }else{
>            $db->query("CALL Insert_OHC_Day({$nDate},{$cDate})");
>     }
>
>     $cDate+=86400;
>     $num++;
>
>     }
>     }
>     }
>
>
>
> The records are inserting into the table BUT the field "och_Dates" is 
> not getting the proper value. It gets "0000-00-00".
>
> Frustrating. My code looks right and I echoed the value on the page 
> and it is formatted properly. The field in mySQL is formatted as a 
> DATE type.
>
> Little help please :-)
>
>
> Don Wieland
> D W   D a t a   C o n c e p t s
> ~~~~~~~~~~~~~~~~~~~~~~~~~
> [email protected]
> Direct Line - (949) 305-2771
>
> Integrated data solutions to fit your business needs.
>
> Need assistance in dialing in your FileMaker solution? Check out our 
> Developer Support Plan at:
> http://www.dwdataconcepts.com/DevSup.html
>
> Appointment 1.0v9 - Powerful Appointment Scheduling for FileMaker Pro 
> 9 or higher
> http://www.appointment10.com
>
> For a quick overview -
> http://www.appointment10.com/Appt10_Promo/Overview.html
>
>