I'm a Newbie at Django (release ver. 0.96) and I've got a problem with
saving data from a Django checkbox to MySQL.

The code that I'm running looks like this:

            manipulator.do_html2python(new_data)
            print "\nnew data: ", new_data
            new_baseline_fsr = manipulator.save(new_data)

The print statement shows that new_data is providing [True] or [False]
values for the boolean fields which are appearing as check boxes, but
the error message from the web server is reporting either empty
strings or 'on' values as follows:

OperationalError at /fsr/create_new/140101,13-1001/
(1366, "Incorrect integer value: 'on' for column 'coldwork' at row 1")
Request Method: POST
Request URL:    http://127.0.0.1:8000/fsr/create_new/140101,13-1001/
Exception Type: OperationalError
Exception Value:        (1366, "Incorrect integer value: 'on' for column
'coldwork' at row 1")
Exception Location:     C:\Python24\lib\site-packages\MySQLdb
\connections.py in defaulterrorhandler, line 35

Does anyone out there have any ideas about what I'm doing wrong?


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"Django users" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to