| Subject: | wrong processing of non filled optional integer/date fields |
Using Class::DBI::FromCGI to update a Postgres v8 database, I've table with
possibly NULL integer/date field. But when I left one of this field empty,
letting SGBD putting the correct default value, I've got an error because
the generated SQL order contains : field = ''.
I suppose MySQL accept this syntax, but Postgres don't.
In order to avoid this, I've modified FromCGI.pm like this:
220c220
< $fields->{field} = $value if $value;
---
Show quoted text
> $fields->{field} = $value;
this apparently solves my problem.