If you have checkbox fields you also need to run ``prepare``:: ... manipulator.prepare(new_data) manipulator.do_html2python(new_data) ...
I hope this helps, -Mike On May 23, 12:11 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Can you post your manipulator code? > > On May 18, 1:35 pm, Mason <[EMAIL PROTECTED]> wrote: > > > 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 django-users@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---
