CF / Lucee incompatibility for bit values and cfupdate

Description

Updating bit values in a database which are coming from checkboxes on a html page is resulting in an error.
Have a look to this sample code:
go_cbtest.cfm

go_cbtest_action.cfm

This code works fine on CF 9.01. Lucee throws this error:


Lucee can't decode the "on" value of the checkbox to a binary "1".

There is a workaround though, by adding value = "1" to the input tag:

So, not a real show stopper, but definitely an incompatibility which could be resolved with a limited amount of extra code.

Environment

None

Activity

Show:
Pothys - MitrahSoft
November 28, 2019, 3:02 PM

I've added a test case & fix for this ticket and confirmed the issue happened on Lucee Latest version 5.3.5.46 also. But in ACF works fine.

Pull Request: https://github.com/lucee/Lucee/pull/805

Assignee

Michael Offner

Reporter

Gunter Otté

Priority

Minor

Labels

Fix versions

None

Affects versions

Configure