On 7 jan, 08:02, Praveen <praveen.python.pl...@gmail.com> wrote:
> Models.py
>
> class Listing(models.Model):
> name = models.CharField(max_length=20)
> description = models.TextField(max_length = 100)
> website = models.URLField()
> category = models.ForeignKey(Category)
>
> class Category(models.Model):
> category_code = models.CharField(max_length = 50, primary_key=True,
> blank=False)
> category_name = models.CharField(max_length = 50,)
> def __unicode__(self):
> return self.category_code
>
> i have cat_list.html which list all the category with name only as
> link if some one wants to know more details he/she may click on that
> link.
>
> urls.py
>
> (r'^category/category_view/$','mysite.library.views.categories'),
> (r'^category/category_view/(?P<category_code>\w+)/
> $','mysite.library.views.category_info'),
>
> views.py
>
> def categories(request):
> result_category = Category.objects.all()
> return render_to_response("cat_list.html",
> {'result_category':result_category})
>
> def category_info(request, category_code):
> result_category = get_object_or_404(Category, pk = category_code)
> --------->result_listing = get_object_or_404(Listing, pk = id)
> print result_category
> return render_to_response("category_view.html",
> {'result_category':result_category,'result_listing':result_listing})
>
> see ------>result_listing in category_info function. i want to display
> some info of Listing tables of corresponding category_code.
Then why don't you just use the reverse relationship ?
related_listing_list = result_category.listing_set.all()
which you can as well call directly from within the template, so you
don't even need to code for it in the view...
> when i use
>
> 1--> result_listing = get_object_or_404(Listing, pk = id) then i get
> an error
> id() takes exactly one argument (0 given)
Indeed. id(obj) is a builtin python function that returns the OID of
an object. Where do you thing this 'id' name came from ?
> 2--> result_listing = get_object_or_404(Listing, pk = category_id)
> then i am not getting the exact result cause Category(category_code)
> is checking with Listing(id).
You're getting the exact result you asked for : a listing instance
which primary key has the value category_id.
> i do not know how may i access corresponding records from two tables.
That's explained in whole details in the online documentation. Go to
djangoproject.com, click the "documentation" link, then follow the
"models : accessing related objects" link.
<rant>
If i was one of Django's doc writer, I'd probably start to despair.
Why spending so much _volunteer_ time writing a pretty good *and* well-
organized documentation when no one seems to bother reading it ?
</rant>
--~--~---------~--~----~------------~-------~--~----~
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
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
