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));
|
