Yeah you are right depending on my DB you may or may not be allowed to do a LIKE comparison on that, try doing an exact match
Dates don't really 'contain' or 'start with'. that doesn't really make sense, I can do lookups against the year month or day by doing, __year, __month, or __day respectively Dates aren't strings, unless (cough) you're in sqlite. Matías Costa wrote: > On Fri, Jan 2, 2009 at 7:48 AM, Praveen <[email protected]> > wrote: > > > > <form action="." method="GET"> > > > > <label for="q">By product name : </label> > > <input type="text" name="q" value="{{ query|escape }}"> > > <label for="p">By date approval : </label> > > <input type="text" name="p" value="{{ query1|escape }}"> > > <input type="submit" value="Search"> > > </form> > > > > views.py > > import Q > > > > def proreport(request): > > query = request.GET.get('q', '') > > query1 = request.GET.get('p', '') > > print query > > print query1 > > if query and query1 : > > qset = ( > > Q(product_name__startswith=query) & > > Q(date_approval__icontains=query1) > > ) > > results = Products.objects.filter(qset).distinct() > > else: > > results = [] > > return render_to_response("admin/report/product_report.html", > > { "results": results, "query": query, "query1": query1}) > > > > database > > in table date_approval field is saving in the format of (yyyy-mm-dd) > > > > error > > > > when i am giving the value 2008-10-10 in text box of p > > > > Caught an exception while rendering: Incorrect date value: > > '%2008-10-10%' for column 'date_approval' > > You only can search for text inside text. Here django tries to make > text-pattern-matching on a date type. The code should be something as > > qset = ( > Q(product_name__startswith=query) & > Q(date_approval=query1) > ) --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
