Re: Sub-Query

2013-04-23 Thread der_FeniX
Just make like this: times = time_stamp.objects.all().order_by('-time_stamp')\ .values('user_id','game_id')[0] -- You received this message because you are subscribed to the Google Groups "Django users" group.To unsubscribe from this group and stop receiving emails from it, send an email to d

Sub-Query

2013-04-23 Thread Nagarajan Dharmar Sitha
++-+-+-+ | id | user_id | game_id | time_stamp | ++-+-+-+ | 37 | 000u1 | 000g1 | 2013-04-08 10:35:30 | | 38 | 000u2 | 000g2 | 2013-04-08 10:35:30 | | 39 | 000u3 | 000g3 | 2013-04-08 10:35:30 | | 40

Re: MySQL limit sub-query problem

2012-01-26 Thread rahul jain
Works! Great! thanks!!! Lazy querysets! On Thu, Jan 26, 2012 at 12:32 PM, Alasdair Nicol wrote: > Hi RJ, > > > On 26/01/12 20:10, rahul jain wrote: >> >> All, >> >> I have a query. Its working fine on sqlite server but not working fine >> on mysql server. >> >> This is the error message on mysql

Re: MySQL limit sub-query problem

2012-01-26 Thread Alasdair Nicol
Hi RJ, On 26/01/12 20:10, rahul jain wrote: All, I have a query. Its working fine on sqlite server but not working fine on mysql server. This is the error message on mysql server: "This version of MySQL doesn't yet support 'LIMIT& IN/ALL/ANY/SOME subquery" This is the query: inner_q = obj_

MySQL limit sub-query problem

2012-01-26 Thread rahul jain
All, I have a query. Its working fine on sqlite server but not working fine on mysql server. This is the error message on mysql server: "This version of MySQL doesn't yet support 'LIMIT & IN/ALL/ANY/SOME subquery" This is the query: inner_q = obj_unassigned.values_list('pk', flat=True)[:diff]