Hi - I'm a django newbie, so sorry if I'm doing something stupid (I did try
to read the documentation.
I want to have a model, that has a manytomany field that stores days of the
week, selected via a checkbox widget. I read on the web, that I could put
something like this in the model.
DAYS_OF_WEEK = (('1', 'Monday'),('2', 'Tuesday'),('3', 'Wednesday'),('4',
'Thursday'),('5', 'Friday'),('6', 'Saturday'),('7', 'Sunday'),)
class Days(models.Model):
days = models.CharField(max_length=1, choices=DAYS_OF_WEEK)
The part of the model that references the days:
class Preferences(models.Model):
mail_days = models.ManyToManyField(Days)
The part of the form where the days are selected, is here:
DAYS_OF_WEEK = (
('1', 'Monday'),
('2', 'Tuesday'),
('3', 'Wednesday'),
('4', 'Thursday'),
('5', 'Friday'),
('6', 'Saturday'),
('7', 'Sunday'),
)
mail_days = forms.MultipleChoiceField(required=False,
widget=CheckboxSelectMultiple, choices=DAYS_OF_WEEK)
The form displays correctly, i.e. checkboxes for the days of the week
appear. When I select the boxes, and hit submit, everything looks ok. But
if I redisplay the form , the checkboxes are all empty. But changes to the
other form fields, that I made, get saved properly (As an aside, I'm using
form.save(), not using commit=False). So why do my checkboxes selections
disappear?
Here's the SQL database table, that gets created for the days model. It's
empty. It's not populated with anything. Shouldn't it be?
CREATE TABLE `myapp_days` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`days` varchar(1) NOT NULL,
PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=latin1;
LOCK TABLES `todo_days` WRITE;
UNLOCK TABLES;
The selected days are getting saved into a table called
myapp_preferences_my_days. So something is being saved. Is this a model
problem, or form problem? Thanks.- Mark
CREATE TABLE `myapp_preferences_mail_days` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`preferences_id` int(11) NOT NULL,
`days_id` int(11) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `preferences_id` (`preferences_id`,`days_id`),
KEY `myapp_preferences_mail_days_2d9474d5` (`preferences_id`),
KEY `myapp_preferences_mail_days_96c2dc77` (`days_id`)
) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
LOCK TABLES `myapp_preferences_mail_days` WRITE;
INSERT INTO `myapp_preferences_mail_days` VALUES (15,1,6),(14,1,4),(13,1,5);
UNLOCK TABLES;
--
You received this message because you are subscribed to the Google Groups
"Django users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/django-users?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
