On Mar 14, 1:36 am, Dennis Lee Bieber <[EMAIL PROTECTED]> wrote: > On Thu, 13 Mar 2008 19:55:27 -0700 (PDT), [EMAIL PROTECTED] declaimed > the following in comp.lang.python: > > > > > Thanks for the reply, Carsten, how would this work with UPDATE > > command? I get this error: > > > cmd = "UPDATE items SET content = ? WHERE id=%d" % id > > cmd = "update items set content = ? where id = ?" > > > self.cursor.execute(cmd, content) > > self.cursor.execute(cmd, (content, id)) > > would be the preferred method...
Thanks very much - this works perfectly -ak > > -- > Wulfraed Dennis Lee Bieber KD6MOG > [EMAIL PROTECTED] [EMAIL PROTECTED] > HTTP://wlfraed.home.netcom.com/ > (Bestiaria Support Staff: [EMAIL PROTECTED]) > HTTP://www.bestiaria.com/ -- http://mail.python.org/mailman/listinfo/python-list
