On Jun 29, 11:34 am, John Aherne <[EMAIL PROTECTED]> wrote:
> I've been looking at django for a while. Been through the tutorial a few
> times and read 2 books several times and am still trying to find out how
> some things work.
>
> Instead of an empty form on first loading, I would like to be able to
> fill out some selection lists with data pulled from a database table.
>
> There are 2 things I would like to achieve:--
>
> First, I have a model with 30 fields but I want to extract 2 columns for
> use with a selection list. I want to get all rows in the table but only
> 2 columns. I have looked at using .values() but that returns a different
> format than a queryset.
>
> So I then found Managers. But before I start going through that I
> thought I would check and see if I have gone blind and missed some
> obvious way of getting my select list filled based on my table selection.
>
> Second thing is I want to select certain columns from a table but filter
> the selection based on input from the session data. At the moment, I'm
> not using session data, I just want to hardcode the options so I can
> concentrate on how I get my selection list filled. Once again my model
> has 10 fields, but I only want to get 2 of those to use in my selection
> list.
>
> I thought about filling out a dictionary and passing that in as per the
> samples in forms.py. But I then read that I should not be doing this.
> Choices in forms is for mainly static selections. So I then start
> looking for a way to get my data set up for a selection list. But as I
> say, I've looked at .objects.values() and then started to look at managers.
>
> Also I have googled all over for some reference to this problem I have
> and not found any link to my problem. I have some found some links that
> relate to some edge cases, but nothing simple. So I think I must be
> being a bit stupid or blind, since noone else is having this problem.
>
> I would be very pleased if someone could point me in the way to go on this.
>
> John Aherne
What you want is a ModelChoiceField. For example:
from django import newforms as forms
class MyForm(forms.Form):
mychoicefield =
forms.ModelChoiceField(queryset=MyModel.objects.all())
or you could put your filter as the queryset -
MyModel.objects.filter(field=criteria)
--
DR.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
