Re: Mysql Quires using raw()

On Tuesday 09 November 2010 12:25:30 Jagdeep Singh Malhi wrote:
> hi
> I am facing problem with raw() mysql quiers
> for example :
> maxid = Client.objects.raw('SELECT Max(id) FROM client')
>
> print maxid
>
> output is :-
> <RawQuerySet: 'SELECT Max(job_no) FROM client'>
>
> I am using Django 1.2 version.
> where I am wrong?

Nowhere. Output is correct and as documented - you get back *RawQuerySet*. Not
a single value.

So you have to do something like:

maxid = Client.objects.raw('SELECT MAX(job_no) as max_job_no FROM
CLIENT').values_list('max_job_no', flat=True)[0]

--

Jani Tiainen

--
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.