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