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 -~----------~----~----~----~------~----~------~--~---