On Mon, Oct 12, 2009 at 11:33 AM, Victor Subervi victorsube...@gmail.comwrote:
for row in data:
i += 1
total = 0
quantity = form.getfirst('order_' + str(i), '')
if quantity != '':
sql = 'select * from products p join %s c on p.ID=c.ID where
c.ID=%s;' %
Hi;
I have the following code:
for row in data:
i += 1
total = 0
quantity = form.getfirst('order_' + str(i), '')
if quantity != '':
sql = 'select * from products p join %s c on p.ID=c.ID where
c.ID=%s;' % (client, str(i))
cursor.execute(sql)
Chris
On Mon, Oct 12, 2009 at 11:33 AM, Victor Subervi victorsube...@gmail.comwrote:
Hi;
I have the following code:
for row in data:
i += 1
total = 0
In the above line, you're setting total to 0 each time the loop runs.
quantity = form.getfirst('order_' +
On Mon, 12 Oct 2009 11:33:31 -0700, Victor Subervi
victorsube...@gmail.com wrote:
Hi;
I have the following code:
for row in data:
i += 1
total = 0
[snip]
As you can see, the total doesn't accumulate! There are two rows. The
second
Total 1: should show 1.98, not 0! What
Ouch! You're right!
;)
V
On Mon, Oct 12, 2009 at 1:38 PM, Rami Chowdhury rami.chowdh...@gmail.comwrote:
On Mon, 12 Oct 2009 11:33:31 -0700, Victor Subervi
victorsube...@gmail.com wrote:
Hi;
I have the following code:
for row in data:
i += 1
total = 0
[snip]
As you
Victor Subervi wrote:
Hi;
I have the following code:
[snip]
price = str(int(stuff[5]*100))
price = price[0:len(price)-2] + '.' + price[-2:]
[snip]
This is simpler:
price = %.2f % stuff[5]
(not that I like what you're doing with it; leaving it as a float and
just