i have come up with one of the most interesting query i have ever seen. I want to do this :
products = products.filter(productdetail__detail_value__gte = first_value) products = products.filter(productdetail__detail_value__lte = second_value) where first_value and second_value are integers and "productdetail__detail_value" are stored as a char. it is a very simple sql query but how can i do this using django queryset. the problem is that i need the products to stay as a queryset... because i need to filter it again if that is the case. taking the easy way out and changing the way the table is constructed is not an option. i have to store any kind of data in "detail_value" and filter the information. it's a generic filter and this is the only problem i don't have a solution to..... please help. --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---