django-users@googlegroups.com wrote on 02/09/2006 07:20:35 PM:

> So this is a strange problem...I'm getting the Following error when try 
to 
> view the list mode of my court_detals object in the Admin interface.
> 

snip.

To be a little less verbose, I think the SQL handler in django is not 
handling my One to One relationship correctly. 

SELECT 
`contrack_court_details`.`sector`,`contrack_court_details`.`type`,`contrack_court_details`.`district`,`contrack_court_details`.`court_id`
 
FROM `contrack_court_details` ORDER BY `contrack_locations`.`id` DESC


It _should_ be this (I constructed this by hand and it works):

SELECT 
`contrack_court_details`.`sector`,`contrack_locations`.`id`,`contrack_court_details`.`type`,`contrack_court_details`.`district`,`contrack_court_details`.`court_id`
 
FROM `contrack_court_details`, `contrack_locations` ORDER BY 
`contrack_locations`.`id` DESC


So django is leaving out the table to which OneToOneField is tied to...

Please tell me I'm doing something wrong and it's not a bug.  :)



James S. Martin, RHCE
Contractor
Administrative Office of the United States Courts
Washington, DC
(202) 502-2394

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

Reply via email to