I also encorage you to look at the django-mptt package.
On May 27, 11:41 pm, adelaide_mike <mike.ro...@internode.on.net>
wrote:
> Thank you Tom and Daniel. Starting to see some light here.
>
> Mike
>
> On May 28, 1:25 am, Daniel Roseman <roseman.dan...@googlemail.com>
> wrote:
>
> > On May 27, 2:59 pm, Tom Evans <tevans...@googlemail.com> wrote:
>
> > > On Wed, 2009-05-27 at 06:27 -0700, adelaide_mike wrote:
> > > > Very beginner here.
>
> > > > My model has two classes, Suburb, the parent, and Street, the child:
>
> > > > class Suburb(models.Model):
> > > > suburb_name = models.CharField(max_length=72)
> > > > postcode = models.CharField(max_length=4)
> > > > def __unicode__(self):
> > > > return '%s %s' % (self.suburb_name, self.postcode)
>
> > > > class Street(models.Model):
> > > > street_name = models.CharField(max_length=72)
> > > > suburb = models.ForeignKey(Suburb)
> > > > def __unicode__(self):
> > > > return '%s, %s' % (self.street_name,
> > > > unicode(self.suburb))
>
> > > > In my view I populate the variable streets:
>
> > > > def search_street(request):
> > > > query = request.GET['query']
> > > > streets = Street.objects.filter(street_name__istartswith = query)
> > > > # Do a case-insensitive search on the starts-with name of the
> > > > street.
> > > > return render_to_response('wha/street_select.html', {'streets':
> > > > streets, 'query': query})
>
> > > > The page search_select.html contains:
>
> > > > <ul>
> > > > {% for street in streets %}
> > > > <li><a href=street.id>{{street.street_name}}
> > > > {{suburb.suburb_name}}</a></li>
> > > > {% endfor %}
> > > > </ul>
>
> > > > This displays only the street name, and not the suburb_name. I need
> > > > it to display as in the admin ie:
> > > > street_name suburb_name postcode
>
> > > > What change should I make or where can I see an example?
>
> > > > TIA
>
> > > > Mike
>
> > > {{ street.suburb.suburb_name }}
>
> > Note that although this does give the right answer, it'll be very
> > inefficient in terms of database access, as you'll need to hit the
> > database to look up the suburb on every single street.
>
> > Easy fix - add select_related() to the lookup in the view:
> > streets = Street.objects.filter(street_name__istartswith =
> > query).select_related()
> > --
> > 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
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
