[Pypgsql-users] providing arguements updated

[Timothy S. <ti...@op...>]

i have since found way around the % limitation only to be hit with a 
different problem
i am trying to perform a modal operation ( it's in order to change DOW 
from starting on a sunday to starting on a monday ) but i get the 
following error
ValueError: unsupported format character ' ' (0x20) at index 317

this is my code

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 
%s ORDER BY transactions.for_date",
            (FromDate, ToDate, SelectedVenue, FromDay, ToDay));