[Phpgroupware-tracker] [bugs #3475] so_sql has error for date postgresql fields when using save function

[Dave Hall]

This mail is an automated notification from the bugs tracker
 of the project: phpGroupWare.

/**************************************************************************/
[bugs #3475] Latest Modifications:

Changes by: 
                Dave Hall <address@hidden>
'Date: 
                Sun 06/06/2004 at 23:26 (Australia/Melbourne)

            What     | Removed                   | Added
---------------------------------------------------------------------------
         Assigned to | None                      | Caeies







/**************************************************************************/
[bugs #3475] Full Item Snapshot:

URL: <http://savannah.gnu.org/bugs/?func=detailitem&item_id=3475>
Project: phpGroupWare
Submitted by: Johnson
On: Mon 05/05/2003 at 16:50

Category:  eTemplates
Item Group:  None
Severity:  5 - Average
Priority:  5 - Normal
Resolution:  None
Assigned to:  Caeies
Status:  Open
Component Version:  None
Platform Version:  None
Reproducibility:  None


Summary:  so_sql has error for date postgresql fields when using save function

Original Submission:  Empty date fields are set to '' but postgresql returns 
error

Postgresql wants null date values set to null (not '')



Follow-up Comments
------------------


-------------------------------------------------------
Date: Wed 05/14/2003 at 03:13       By: jecinc
Looks like you prepared for this since there is an $empty_on_write = "NULL"; 
near the top of the so_sql class but the save function uses  
$this->empty_on_write that doesn't seem to be set equal to "NULL"

I added  $this->empty_on_write = "NULL"; immediately above $cols .= ($cols ? 
',' : '') . $db_col; and the save started to work for me.

I realize this is a hack but should help you find where the problem really is.

Would this also solve postgresql 7.3 bugs for fields not liking '' for apps 
using so_sql?  I think it would



-------------------------------------------------------
Date: Mon 05/05/2003 at 18:45       By: ralfbecker
Ok, I will fix it soon.












For detailed info, follow this link:
<http://savannah.gnu.org/bugs/?func=detailitem&item_id=3475>

_______________________________________________
  Message sent via/by Savannah
  http://savannah.gnu.org/