On Mar 31, 12:50 am, "D'Arcy J.M. Cain" <da...@druid.net> wrote:
> On Tue, 30 Mar 2010 13:47:42 -0700 (PDT)
>
> ASh <anton.shish...@gmail.com> wrote:
> > Hi, please help me understand why am I getting error with this query
>
> > new_start_date = "NOW() - '29 days'::INTERVAL"
> > self.dyndb.orderdb.query('''update xxxx set creation_date
> > = %s
> > where id_order = %s''', (new_start_date, "123"))
>
> Put single quotes around the first %s in the query.
>
> --
> D'Arcy J.M. Cain <da...@druid.net> | Democracy is three
> wolveshttp://www.druid.net/darcy/ | and a sheep voting on
> +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
Tried like you said, got this error:
psycopg2.ProgrammingError: syntax error at or near "NOW"
LINE 1: update orderdb.orders set creation_date = 'E'NOW() - ''29
da...
^
--
http://mail.python.org/mailman/listinfo/python-list
