Re: [Pypgsql-users] providing arguements updated

[Karsten H. <Kar...@gm...>]

> cur.execute("select daily_takings.cash, transactions.for_date from 
> transactions, daily_takings, daily_stats where transactions.id = 
> daily_takings.id and transactions.for_date >= %s and 
> transactions.for_date <= %s and transactions.for_venue = %s and 
> (EXTRACT(DOW FROM transactions.for_date)::integer+6) % 7 BETWEEN %s AND 
                                                       ^
you need to escape that %, eg. write %%

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346