DMZ 1.7.1 (DataMapper OverZealous Edition)

[eluser]NachoF[/eluser]
[quote author="OverZealous" date="1274603997"]@NachoF

I don't know what to tell you. If you set the field to an empty string, then DMZ has to assume you want to save it. An empty string is not a NULL, and when inserting new data, DMZ only excludes NULLs from the query.

The best solution is to not set fields you want to be NULL to an empty string.
[/quote]

But how exactly do I do that??.. there is a bunch of text fields in my form.. and the user should be able to write on whichever he chooses to... Basically, those fields should be numeric but NOT required.

I would like to keep my controller action as clean as possible (which is why im using your array extension and In only doing)

Code:

$object->from_array($_POST);
if($object->save())
{
redirect ("home");
}

could chainging the data type in the database to character varying but keeping the numeric validation rule in datamapper be a good approach?