tony on Edit Form Allow Empty Date Field

Wed, 18 Apr 2012 12:24:19 +0300

Hello,

Please post he problem in the rigth forum

http://www.trirand.net/forum/

Thank you

Regards

scrombie on Edit Form Allow Empty Date Field

Tue, 17 Apr 2012 21:36:27 +0300

I have an add/edit form that needs to accept blank entries for a date field. When the entry is submitted blank, I get the following error...

PHP Notice: Undefined offset: 0 in C:\Inetpub\wwwroot\Resources\jqGrid42\php\jqGrid.php on line 4093 PHP Notice: Undefined offset: 0 in C:\Inetpub\wwwroot\Resources\jqGrid42\php\jqGrid.php on line 4093 PHP Notice: Undefined offset: 0 in C:\Inetpub\wwwroot\Resources\jqGrid42\php\jqGrid.php on line 4093

If I enter 'null' in the field, it responds as desired (entering a NULL in the database field); however, I cannot expect my users to enter 'null' for this field.

The following is the configuration for the field and form...

$grid->setColProperty('PaidDate',array(
   "align"=>"center",
   "width"=>60,
   "label"=>"Paid Date",
   "formatter"=>"date",
   "formatoptions"=>array("srcformat"=>"Y-m-d H:i:s","newformat"=>"m/d/Y"),
   "editable"=>true,
   "editoptions"=>array("dataInit"=>"js:".$mydatepicker),
   "searchoptions"=>array("dataInit"=>"js:".$mydatepicker),
   "formoptions"=>array("elmsuffix"=>" (mm/dd/yyyy)")
));

$grid->setNavOptions('edit', array("height"=>"auto","width"=>"auto","dataheight"=>"auto","closeAfterEdit"=>true,"editCaption"=>"Edit Cash NSF Sale"));
$grid->setNavOptions('add', array("height"=>"auto","width"=>"auto","dataheight"=>"auto","closeAfterAdd"=>true,"addCaption"=>"Add Cash NSF Sale"));

I'm using php and SQL Server.

How can I get NULL entered in the database for a date field with no input?

Steven

jQuery Grid Plugin - jqGrid - Topic: Edit Form Allow Empty Date Field

tony on Edit Form Allow Empty Date Field

scrombie on Edit Form Allow Empty Date Field