[web2py] dal trying to insert 0 instead of null?

2011-07-10 Thread cjwebb
Hello, this has been annoying me all day - any suggestions welcome. I am receiving an IntegrityError from web2py when trying to insert a record into a table named Foods. The table has a foreign key to Recipes, but I would like to add a row without a recipe_id. I receive this sql error: class

[web2py] Re: Possible bug in trunk dal.py

2011-07-10 Thread cjwebb
I have encountered this too. Are there any suggestions/fixes to solve this issue? On Jun 2, 9:54 am, Oskari oskari.pe...@gmail.com wrote: Yes I did. Dal seems to try to put 0 in database but MySQL rejects the value, since there is no row with index 0. I think the proper way to indicate None in