Problem: form-checkbox -> MySQL-table
I got a MySQL-table with lots of "boolean"-values, in the form of ENUM('Y',N'). In my webpage I got a bunch of checkboxes and I want to map the checkboxes to the fields in the table. The problem is that a checkbox-value is only available if the checkbox has been checked. I've tried using <dtml-if fieldname> in my sql to check for the presence of a checked checkbox, add it to the columns-list and value-list if present, but I get an error " Error Value : 1136, "Column count doesn't match value count at row 1". That would be ok, if I could just see the SQL-statement that didn't work. In short : how can I post a bunch of boolean-like values from a form to a sql-method using MySQL? Thanks in advance, Thomas
try the "missing" keyword on your dtml-vars: <dtml-var mycheckboxvalue missing="N"> jens On Monday, July 22, 2002, at 07:35 , Thomas Weholt wrote:
I got a MySQL-table with lots of "boolean"-values, in the form of ENUM('Y',N'). In my webpage I got a bunch of checkboxes and I want to map the checkboxes to the fields in the table. The problem is that a checkbox-value is only available if the checkbox has been checked. I've tried using <dtml-if fieldname> in my sql to check for the presence of a checked checkbox, add it to the columns-list and value-list if present, but I get an error " Error Value : 1136, "Column count doesn't match value count at row 1". That would be ok, if I could just see the SQL-statement that didn't work.
In short : how can I post a bunch of boolean-like values from a form to a sql-method using MySQL?
Thanks in advance, Thomas
At 1:35 PM +0200 7/22/02, Thomas Weholt wrote:
I got a MySQL-table with lots of "boolean"-values, in the form of ENUM('Y',N'). In my webpage I got a bunch of checkboxes and I want to map the checkboxes to the fields in the table. The problem is that a checkbox-value is only available if the checkbox has been checked. I've tried using <dtml-if fieldname> in my sql to check for the presence of a checked checkbox, add it to the columns-list and value-list if present, but I get an error " Error Value : 1136, "Column count doesn't match value count at row 1". That would be ok, if I could just see the SQL-statement that didn't work.
In short : how can I post a bunch of boolean-like values from a form to a sql-method using MySQL?
I found that putting a hidden input value above the checkbox with the "off" value solved this problem for ZPT. Won't work for multiple records because the two inputs will generate two records, so it there is a better ZPT method. I'd like to hear about it. Sincerely, Richard Wesley Co-President, Electric Fish, Inc. <http://www.electricfish.com/> (v) +1-206-493-1690x210 (f) +1-206-493-1697
Richard Wesley <hawkfish@electricfish.com> wrote:
At 1:35 PM +0200 7/22/02, Thomas Weholt wrote:
I got a MySQL-table with lots of "boolean"-values, in the form of ENUM('Y',N'). In my webpage I got a bunch of checkboxes and I want to map the checkboxes to the fields in the table. The problem is that a checkbox-value is only available if the checkbox has been checked. I've tried using <dtml-if fieldname> in my sql to check for the presence of a checked checkbox, add it to the columns-list and value-list if present, but I get an error " Error Value : 1136, "Column count doesn't match value count at row 1". That would be ok, if I could just see the SQL-statement that didn't work.
In short : how can I post a bunch of boolean-like values from a form to a sql-method using MySQL?
I found that putting a hidden input value above the checkbox with the "off" value solved this problem for ZPT. Won't work for multiple records because the two inputs will generate two records, so it there is a better ZPT method. I'd like to hear about it. Sincerely,
Use <input type="hidden" name="fieldname:default" value="1"> Florent -- Florent Guillaume, Nuxeo (Paris, France) +33 1 40 33 79 87 http://nuxeo.com mailto:fg@nuxeo.com
participants (4)
-
Florent Guillaume -
Jens Vagelpohl -
Richard Wesley -
Thomas Weholt