Re: How to use subqueries in django

2009-11-18 Thread Radhikavk
thank you sir i found the solution -- View this message in context: http://old.nabble.com/How-to-use-subqueries-in-django-tp26387486p26408019.html Sent from the django-users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups

Re: How to use subqueries in django

2009-11-18 Thread Karen Tracey
On Wed, Nov 18, 2009 at 2:15 AM, Radhikavk wrote: > > in one query they have giver or conditions > but i need > i wil have one common query like > list=rooms.objects.all() # this is common query i m using > > and if the condition given like room status,type etc then i need to append > those wher

Re: How to use subqueries in django

2009-11-17 Thread Radhikavk
where room_type=this else nothing i have so many search criteria , i think this appending is useful but it is giving error queryset has no attribute append -- View this message in context: http://old.nabble.com/How-to-use-subqueries-in-django-tp26387486p26402998.html Sent from the django

Re: How to use subqueries in django

2009-11-17 Thread Adam Knight
On Nov 17, 2009, at 7:49 AM, Radhikavk wrote: > > hi, > > how to use search criteria using OR and AND in queries > user can search room by no,room_type, block etc i need the combination > > > Please can you refer the tutorial http://docs.djangoproject.com/en/dev/topics/db/queries/#complex-lo

Re: How to use subqueries in django

2009-11-17 Thread Radhikavk
hi, how to use search criteria using OR and AND in queries user can search room by no,room_type, block etc i need the combination Please can you refer the tutorial -- View this message in context: http://old.nabble.com/How-to-use-subqueries-in-django-tp26387486p26390239.html Sent from the

Re: How to use subqueries in django

2009-11-17 Thread Radhikavk
You received this message because you are subscribed to the Google Groups > "Django users" group. > To post to this group, send email to django-us...@googlegroups.com. > To unsubscribe from this group, send email to > django-users+unsubscr...@googlegroups.com. > For more o

Re: How to use subqueries in django

2009-11-17 Thread Radhikavk
ok i got it Thanks -- View this message in context: http://old.nabble.com/How-to-use-subqueries-in-django-tp26387486p26389937.html Sent from the django-users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups "Django

Re: How to use subqueries in django

2009-11-17 Thread Karen Tracey
On Tue, Nov 17, 2009 at 6:43 AM, Radhikavk wrote: > > I tried this i dis not get solution > > i m getting a list from rooms table > > room_list=rooms.objects.all() > > This will give me the room type id when i print room_list.room_type_id but > for this id i need a name which is in room_types tab

Re: How to use subqueries in django

2009-11-17 Thread Radhikavk
: http://old.nabble.com/How-to-use-subqueries-in-django-tp26387486p26388551.html Sent from the django-users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to

Re: How to use subqueries in django

2009-11-17 Thread Daniel Roseman
and to display the list of rooms the quesry should be > > select r.room_type_id,r.room_no,rt.room_type_name from room_types rt,rooms r > where rt.room_type_id=r.room_type_id > > How to give this query in django > > Thanks in advance > > -- > View this message in > cont

How to use subqueries in django

2009-11-17 Thread Radhikavk
to give this query in django Thanks in advance -- View this message in context: http://old.nabble.com/How-to-use-subqueries-in-django-tp26387486p26387486.html Sent from the django-users mailing list archive at Nabble.com. -- You received this message because you are subscribed to the Google