Is there a way to get CF9 ORM to insert NULL Values into the database rather than an empty string?
I've got a numeric field which can be null, but throws an error because it's trying to enter ''.
Is there a way to get CF9 ORM to insert NULL Values into the database rather than an empty string?
I've got a numeric field which can be null, but throws an error because it's trying to enter ''.
Either:
yourEntity.setNumber(javacast("null",""));
or, add a removeNumber method:
function removeNumber()
{
structDelete(variables,"number");
}