On Mar 31, 3:10 am, "D'Arcy J.M. Cain" <da...@druid.net> wrote: > 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 > wolveshttp://www.druid.net/darcy/ | and a sheep voting on > +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.
Error: cursor.execute(sql, params) File "/opt/local/lib/python2.5/site-packages/psycopg2/extras.py", line 118, in execute return _cursor.execute(self, query, vars, async) 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