Guriddo » Topic: How to allow empty date field?

How to allow empty date field?

Guriddo
date_field empty
How to allow empty date field?

Tagged: date_field empty

This topic has 2 replies, 2 voices, and was last updated 8 months, 2 weeks ago by bogdanm.

Creator

Topic
September 9, 2022 at 10:09 am #128010
bogdanm
Participant
How do I allow empty date fields in Add and Edit?If I don’t add a date, I get the message:
```
SQLSTATE[22007]: Invalid datetime format: 1292 Incorrect date value: " for column db.table.column at row 1
```
I didn’t get this error in an older version (5.1.1)
Creator

Topic

Viewing 2 replies - 1 through 2 (of 2 total)

Author

Replies
September 10, 2022 at 5:08 pm #128013
guriddo.support
Participant
Hello,

The code of insert and update is not changed in ver. 5.1.1 and 5.5.5

Maybe you change the version of database or something else.

Again, please set debug to true – see the output. I do not think that this is jqGrid related problem.

You can test this very simple – from the debug try to execute the same statement in the SQL console and see the result. It is just a request.

If possible, please answer if the problems you posted are resolved or not. If you resolve it other way, please share it. This will help other users,

Kind Regards,

Will
- This reply was modified 8 months, 2 weeks ago by tony.
Guriddo Support Team
September 12, 2022 at 11:09 am #128016
bogdanm
Participant
I think you’re right, it’s not the new jqGrid, but a new version of MySQL (MariaDB actually) that is not working as before. I ended up creating two columns for each one that was of type date that I needed to accept nothing being entered and also displaying an empty field if ‘0000-00-00’ was in the database, but one hidden and editable and the other visible and not editable.
```
$grid->SelectCommand = 'SELECT 
 ...
 (IF(invoices.srlinvoicedate!=\'0000-00-00\', invoices.srlinvoicedate, \'\')) srlinvoicedatedisplay,
 (invoices.srlinvoicedate) srlinvoicedate, 
 ...
 FROM invoices'

$grid->setColProperty('srlinvoicedatedisplay', array("label"=>"Invoice date", "width"=>"80", "fixed"=>true, "align"=>"center", "search"=>false, "editable"=>false));
$grid->setColProperty('srlinvoicedate', array("label"=>"Invoice date", "hidden"=>true, "width"=>"80", "fixed"=>true, "align"=>"center", "formoptions"=>array("rowpos"=>4, "colpos"=>3, "label"=>"SRL - Invoice date"), "search"=>false, "editrules"=>array("edithidden"=>true)));
```
Author

Replies