On Fri, 2007-03-09 at 14:39 +0000, [EMAIL PROTECTED] wrote:
> Pehraps I'm doing something wrong here. I should mention I am using
> the multiple-database branch, so perhaps it's a bug...but thought I'd
> check if my syntax is correct.
>
> I'm trying to trim down the data returned from a query to speed things
> up, as I only need three fields for this particular piece.
>
> My code is:
>
> userids = list([(field.user_id) for field in userroles])
> if len(userids) >0:
> allobligors =
> UserInfo.objects.filter(user_id__in=userids).values('user_id',
> 'first_name','last_name')
> else:
> allobligors = None
>
> if allobligors:
> obligors = [(obj.user_id, obj.last_name + ", " +
> obj.first_name) for obj in allobligors] ## errors on this line
> noneobj = ('','')
> obligors.insert(0,noneobj)
> else:
> obligors = [('','')]
>
>
> ( This works without the .values clause... all the properties are
> correct )
>
> The error I'm getting is:
> dict' object has no attribute 'user_id'
The .values() method returns a list of dictionaries, not a QuerySet
(which looks like a sequence of objects). So you need to change things
like obj.user_id to obj["user_id"] in the values() case.
Regards,
Malcolm
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to [email protected]
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
-~----------~----~----~----~------~----~------~--~---
