django db query, getting error

Question

here is my model :

 class company_profile(models.Model):
       user=models.ForeignKey(User, unique=True)
       company=models.CharField(max_length=200)

      def __unicode__(self):
            return self.company

and when i got django shell i did the following, it worked correctly :

  from my_app.models import company_profile
  everything = company_profile.objects.all()
  # this gives me the correct out put of the existing company names ,

but when i do the following :

  username = company_profile.objects.all().filer(user='rakesh')

  this is the error , that i am getting : 

  ValueError: invalid literal for int() with base 10: 'rakesh'

how can i solve this , or is my query wrong.

Typo: filer should be filter.

Ashwini Chaudhary
– Ashwini Chaudhary

2013-11-04 21:23:09 +00:00
Commented Nov 4, 2013 at 21:23 — Ashwini Chaudhary
– Ashwini Chaudhary, Commented Nov 4, 2013 at 21:23

Peter DeGlopper · Accepted Answer · 2013-11-04 21:23:16Z

5

Your query is wrong. The user="rakesh" clause needs to get either a User instance or the PK of a User instance.

You may mean filter(user__username='rakesh') or something, depending on what fields you have on User.

answered Nov 4, 2013 at 21:23

Peter DeGlopper

37.5k7 gold badges95 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

rgm Over a year ago

That did the trick, thanks for the answer , its a shame that i sometimes miss basic things

Collectives™ on Stack Overflow

django db query, getting error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related