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' % (total_commission)), +plt.legend(('Income - GBP', 'Discounts', 'Google AdWords - %s GBP', 'Commission - %s GBP' % (total_adwords, total_commission)), 'upper right', shadow=True) i get the following traceback: Traceback (most recent call last): File "commission.py", line 119, in <module> plt.legend(('Income - GBP', 'Discounts', 'Google AdWords - %s GBP', 'Commission - %s GBP' % (total_adwords, total_commission)), TypeError: not all arguments converted during string formatting what am i missing? thanks norman On Fri, Jun 24, 2011 at 12:18 PM, Peter Otten <__pete...@web.de> wrote: > 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:59:59 >> (2L, Decimal('173.958344'), Decimal('159.966349')) 2011-06-22 00:00:00 >> 2011-06-23 23:59:59 > > What should the result look like? Can you give a simplified example with > input and output data? > >> the problem is that i am unsure how best to set the BETWEEN range in >> the SQL query using the python datetime function. > > My guess is that you can move more of the problem from Python into SQL if > you add a GROUP BY clause. > > > _______________________________________________ > Tutor maillist - Tutor@python.org > To unsubscribe or change subscription options: > http://mail.python.org/mailman/listinfo/tutor > -- ˙ʇı ɹoɟ ƃuıʎɐd ǝɹ,noʎ ʍou puɐ ǝɔıoɥɔ ɐ ʞooʇ ı ʇɐɥʇ sı 'ʇlnɔıɟɟıp sı ʇɐɥʍ ˙uʍop ǝpısdn p,uɹnʇ pןɹoʍ ǝɥʇ ǝǝs noʎ 'ʇuǝɯɐן sǝɯıʇ ǝɥʇ puɐ 'ʇuǝʇuoɔ ǝq s,ʇǝן ʇǝʎ %>>> "".join( [ {'*':'@','^':'.'}.get(c,None) or chr(97+(ord(c)-83)%26) for c in ",adym,*)&uzq^zqf" ] ) _______________________________________________ Tutor maillist - Tutor@python.org To unsubscribe or change subscription options: http://mail.python.org/mailman/listinfo/tutor
