Re: select statements with specific fields across multiple tables...

2010-08-17 Thread Cindy
Ah *geez* not the "bug due to typo which you can't see b/c you've been looking at the code nonstop for way to long" problem *headdesk* That's what I get for looking at the django tables directly in mysql to recall the columns. Thanks, guys. Dammit, I hate it when I do that. So, I'm thinking

Re: select statements with specific fields across multiple tables...

2010-08-17 Thread Daniel Roseman
On Aug 17, 1:57 pm, Cindy wrote: > But that filter will just give me a list of tuples with > RaidPhysicalDrive's values.  I want to understand how I can include > in the list I send to my template, the *additional* values for system > name, storage name, and array name, so I can display/dump > all

Re: select statements with specific fields across multiple tables...

2010-08-17 Thread Cindy
But that filter will just give me a list of tuples with RaidPhysicalDrive's values. I want to understand how I can include in the list I send to my template, the *additional* values for system name, storage name, and array name, so I can display/dump all the info in a table. I don't want to put i

Re: select statements with specific fields across multiple tables...

2010-08-16 Thread Alec Shaner
1. What is your code for doing the filters? If you want to start with physical drives it would be something like: RaidPhysicalDrive.objects.filter(in_array__in_storage__in_system__id=) 2. In your template you've referenced pd.in_array_id, but don't you just want pd.in_array if you're wanting to

select statements with specific fields across multiple tables...

2010-08-16 Thread Cindy
I'm having some trouble constructing a filter that's intended to work across multiple tables with selected fields. Here's a simplified outline of my models: class System(models.Model): name = models.CharField(max_length=16) domain = models.CharField(max_length=255, default='example.com')