Thanks for replying. I don't mean to sound crass but I did mention what the problem was.
Quote: I've even tried specifying in select_related which exact tables and fields I want returned however, only the results from Torrent table is returned. The problem is it only returns results from the Torrent table when I need it to provide the corresponding results from TorrentInfo and TorrentTrackers as well. Perhaps I don't understand what select_related is supposed to do but I thought it was to get all the related results from the db based on the matching foreign keys. It's very possible that I'm attacking this problem the wrong way and what is being returned by this line... result = Torrent.objects.filter(name__icontains=query).select_related () is the proper result. If that's the case, I need to find a way to get related data out of the db and I would like to accomplish this without writing raw sql. Thanks for taking the time to help Malcom. Dave --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
