subject:"\[PHP\] Stored Proc \- Date not inserting into the Record"

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

2010-02-25 Thread Peter

FYI Please Pass your input within quotes $db->query("CALL Insert_OHC_Sun(*'*{$nDate}*'*,{$cDate})"); surly it will work - Peter Don Wieland wrote: I nave 2 stored procedures: DROP PROCEDURE IF EXISTS `Insert_OHC_Sun`; DELIMITER $$ CREATE definer=`do...@`` PROCEDURE `Insert_OHC_Sun`(theDate

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

2010-02-25 Thread Peter

Change the input argument type as a varchar instead of date Ex: CREATE definer=`do...@`` 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

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

2010-02-25 Thread Don Wieland

I nave 2 stored procedures: DROP PROCEDURE IF EXISTS `Insert_OHC_Sun`; DELIMITER $$ CREATE definer=`do...@`` 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");