Re: [Tutor] set the BETWEEN range in the SQL query using the python datetime function

2011-06-24 Thread Norman Khine
On Fri, Jun 24, 2011 at 1:31 PM, Christian Witts wrote: > On 2011/06/24 01:19 PM, Norman Khine wrote: > > thank you, it was simpler than what i was trying to do, here is the > revised version: > > http://pastie.org/2115586 > > one thing i am getting an error is on like 103, in that if, i change >

Re: [Tutor] set the BETWEEN range in the SQL query using the python datetime function

2011-06-24 Thread Christian Witts
On 2011/06/24 01:19 PM, Norman Khine wrote: thank you, it was simpler than what i was trying to do, here is the revised version: http://pastie.org/2115586 one thing i am getting an error is on like 103, in that if, i change (http://pastie.org/2115615): -plt.legend(('Income - GBP', 'Discounts',

Re: [Tutor] set the BETWEEN range in the SQL query using the python datetime function

2011-06-24 Thread Peter Otten
Norman Khine wrote: > thank you, it was simpler than what i was trying to do, here is the > revised version: > > http://pastie.org/2115586 > > one thing i am getting an error is on like 103, in that if, i change > (http://pastie.org/2115615): > > -plt.legend(('Income - GBP', 'Discounts', 'Googl

Re: [Tutor] set the BETWEEN range in the SQL query using the python datetime function

2011-06-24 Thread Norman Khine
thank you, it was simpler than what i was trying to do, here is the revised version: http://pastie.org/2115586 one thing i am getting an error is on like 103, in that if, i change (http://pastie.org/2115615): -plt.legend(('Income - GBP', 'Discounts', 'Google AdWords - GBP', 'Commission - %s GBP'

Re: [Tutor] set the BETWEEN range in the SQL query using the python datetime function

2011-06-24 Thread Peter Otten
Norman Khine wrote: > hello, i have this code http://pastie.org/2112997 > > but i am not sure how to make the date range so that i get a list > based on the daily totals not the results i am now getting: > > (2L, Decimal('173.958344'), Decimal('159.966349')) 2011-06-23 00:00:00 > 2011-06-23 23:5

[Tutor] set the BETWEEN range in the SQL query using the python datetime function

2011-06-23 Thread Norman Khine
hello, i have this code http://pastie.org/2112997 but i am not sure how to make the date range so that i get a list based on the daily totals not the results i am now getting: (2L, Decimal('173.958344'), Decimal('159.966349')) 2011-06-23 00:00:00 2011-06-23 23:59:59 (2L, Decimal('173.958344'), De