On Fri, Aug 21, 2009 at 4:22 AM, luca72 <[email protected]> wrote:

>
> I have solved using :
> Model.object.filter(id=2)values('columnname')
>

Note that it should have a dot:

Model.object.filter(id=2).values('columnname')

and that returns the item you want in a list. The proper way to do that is:

Model.object.get(id=2).columnname

where get returns an object, and all of the columnnames are just attributes
of it.

-Doug


>
> Thanks
>
> Luca
>
> On 21 Ago, 10:14, luca72 <[email protected]> wrote:
> > Thanks for your reply but i get this error:
> > Model object has no attribute 'values'
> >
> > Thanks
> >
> > On 21 Ago, 09:42, Kenneth Gonsalves <[email protected]> wrote:
> >
> > > On Friday 21 Aug 2009 1:00:32 pm luca72 wrote:
> >
> > > > how i can write this with the djago db api:
> > > > SELECT "column name" from "table_name" where "id"=2
> >
> > > Model.objects.get(id=2).values('columnname',)
> > > --
> > > regards
> > > kghttp://lawgon.livejournal.com
> >
>

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

Reply via email to