Thanks for the tip, however, it doesn't really help me out. I've read
the docs, repeatedly, my problem is that I can't seem to get data from
a related table (see my question above).
Thanks
On Apr 12, 7:00 pm, Ovnicraft <ovnicr...@gmail.com> wrote:
> 2009/4/12 jrs_66 <jrs...@yahoo.com>
>
>
>
>
>
> > Hi,
>
> > I'm new to django, but not new to SQL. I have a (seemingly) trivial
> > query to run. In SQL it looks like-
>
> > SELECT media.*, media_and_containers.order
> > FROM media
> > INNER JOIN media_and_containers ON
> > media.id = media_and_containers.media_id
> > WHERE media.id = 1
>
> > In the django ORM I think it should be-
>
> > media = MediaLocal.objects.select_related('order').filter(
> > mediaandcontainer__media__exact = 1
> > )
>
> > Yet, it seems, media.order does not exist...
>
> > What am I missing?
>
> > On a broader level, is Django's ORM intended for people who don't know
> > how to write SQL? It seems that many hoops have to be jumped through
> > to get basic SQL results...
>
> remember MVC, so That is not just for dont write SQL, it is to make the code
> more clean and no has mixed lang and many reasons you can find, but if you
> need write SQL would be better if you read the documentation.
>
> http://docs.djangoproject.com/en/dev/topics/db/queries/
>
>
>
> > Thanks,
>
> > jim
>
> --
> Cristian Salamea
> CEO GnuThink Software Labs
> Software Libre / Open Source
> (+593-8) 4-36-44-48
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
