On Tue, 30 Mar 2010 15:46:12 -0700 (PDT)
ASh <anton.shish...@gmail.com> wrote:
> > > 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.
>
> 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...
Right. I misread it. Please show us the exact error that you get with
the original code.
--
D'Arcy J.M. Cain <da...@druid.net> | Democracy is three wolves
http://www.druid.net/darcy/ | and a sheep voting on
+1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
--
http://mail.python.org/mailman/listinfo/python-list
