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

[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', '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

You've got 'Google AdWords - %s GBP' with no arguments and 'Commission - 
%s GBP' with 2 arguments.

-- 

Christian Witts
Python Developer

//

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/tutor/attachments/20110624/a8cd50ce/attachment.html>