On 07/12/06, Rory Campbell-Lange ([EMAIL PROTECTED]) wrote:
> I'm not sure how to do a join against a related record:
>
> g=SiteEnergy.objects.filter(siteyear=9, energy__isofsite=False)
> raise TypeError, "Cannot resolve keyword '%s' into field" % name
> TypeError: Cannot resolve keyword 'energy' into field
...
my sql was somewhat incorrect.
> SELECT
> se.*
> FROM
> bm_siteenergy se, data_energy e
> WHERE
> se.typer_id = e.id
> AND
> e.isoffsite=FALSE
AND
se.siteyear = 9;
--
Rory Campbell-Lange
<[EMAIL PROTECTED]>
<www.campbell-lange.net>
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
