Change in 4.2.1

[Gowrav]

Hi,
used the new 4.2.1 but the old code that was running in 4.2 is giving
error in here

in a model

in a function line
$this->dsql()->set('isCurrent', false)->do_update();

was working but here I am getting message
"Value "false" is not supported by SQL"

but this is working fine in 4.2.1 also .. is it a change ???
$this->dsql()->set('isCurrent', 0)->do_update();

[Romans Malinovskis]

Hi

MySQL does not support true / false. You should use 1 / 0 instead.

set(‘isCurrent’, 0);

models, on other hand, do support true/false but they will convert it to either 1/0 or Y/N depending on your field configuration.


Version 4.2 was ignoring that and would simply supply empty field into SQL which was failing with some SQL versions.

romans

> --
> FYI: If amount of emails you receive from this group is too much - switch to "Digest" mode. You'll receive no more than 1 email per day.
>
> To post to this group, send email to
> agile-too...@googlegroups.com
>
> To unsubscribe and view archive:
> http://groups.google.com/group/agile-toolkit-devel?hl=en
>
> To download Agile Toolkit, visit:
> http://agiletoolkit.org/