Re: Problem with Mysql Queries in django

Hi Jagdeep,

Consider to use a query like this example:

sales = Sale.objects.extra(select={'month':'month(date_created)','year':'year(date_created)'}).values('year','month').annotate(month=11,year=2010)

It works on mysql.

More information http://docs.djangoproject.com/en/dev/ref/models/querysets/

Cheers

Rogério Carrasqueira

---
e-mail: rogerio.carrasqueira@gmail.com
skype: rgcarrasqueira
MSN: rcarrasqueira@hotmail.com
ICQ: 50525616
Tel.: (11) 7805-0074

2010/11/22 Jagdeep Singh Malhi <singh.malhi22@gmail.com>

Hi
I have two Problems with Mysql Query

First problem :
for example :-

>>>client = ClientJob.objects.filter(date__contains = '2010-11- ')
>>> client

Warning Message is :-
Warning: Incorrect date value: '%2010-11-%' for column 'date' at row 1

its doesn't work
I want use Mysql Query like :-
SELECT ... WHERE date LIKE '2010-11-%';

Second Problem:
I declayer two varables and want use in MySql Query
for example :-

def  function(request):
       if request.method == 'POST':
               form = MonthlyReport(request.POST)
               if form.is_valid():
                       cd = form.cleaned_data
                       month = cd['month']
                       year = cd['year']
                       client = ClientJob.objects.filter(date__contains = year-month-__)

I am using two  Variables year and month in query and got Syntax
error or
error:
unsupported operand type(s) for -: 'unicode' and 'unicode'

I want to use variables in Query.

Please help

Thanks


--
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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.

--
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+unsubscribe@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/django-users?hl=en.