Hello all,
I know the error "invalid literal for int() with base 10: '' " has
been discussed a lot in the past, but this seems to be unique to my
situation.
I have 2 choice fields as defined below for both the model and form:
models.py
class Checkin(models.Model):
...
content = models.IntegerField(db_column='Content', blank=True,
default=0)
specie = models.IntegerField(db_column='Specie', blank=True,
default=0)
(I have tried a few variations on default and null=True etc)
(This is accessing a legacy database)
forms.py
CONTENT_CHOICES=(
(2, 'IDFB USA Method'),
(5, 'IDFB ADFC Official'),
(7, 'IDFB Canada Method'),
(8, 'IDFB Australian Method'),
(9, 'General Report Format'),
(3, 'European Method'),
(4, 'Japanese Method'),
(6, 'California Method'),
(10, 'GB/T (Chinese)'),
)
SPECIES_CHOICES=(
(4, 'Down'),
(5, 'Feather'),
(6, 'Down and Feather'),
(7, 'Pre-Down'),
(8, 'Pre-Feather'),
(9, 'Pre-Down and Feather'),
)
class CheckinForm(ModelForm):
...
content = forms.ChoiceField(required=False, choices=CONTENT_CHOICES,
widget=forms.RadioSelect())
specie = forms.ChoiceField(required=False, choices=SPECIES_CHOICES,
widget=forms.RadioSelect())
When I try to save the form and I do not select anything for these two
fields I get the above error and the two fields are not listed in the
POST area of the Request Information section of the error page.
However, if I select something for each of those tests, the form saves
just fine and all is well. I am using MySQL and the fields are INT(10)
Default Value 0 or Null (I've tried both) and Not Null has been
selected and not selected just for testing.
I assume the problem has something to do with trying to save an empty
string in an INT field, but my checkboxes that are unselected do not
raise errors and the only thing different is that they are TINYINT(1).
Any ideas on why this is happening. I'm trying to give as much info
without being too verbose. I will post more if needs be.
Thanks for all help both past and future.
Greg
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-us...@googlegroups.com.
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en.
