[egenix-users] Simple mx.ODBC Update question

[M.-A. Lemburg]

Greg Corradini wrote:
> Hello all,
> Can I use mx.ODBC to write an UPDATE SQL statement using a list of tuples
> and a parameterized statement format?

Yes.

> For example, I can batch INSERT with the following parameterized statement
> using "?":
> *cursor.executemany("Insert into MYTABLE(ID,VALUE) values(?,?)",
> dataAsListofTuples)*
> 
> Using mxODBC  is there a parameterized Update statement like above?

Sure.

-- 
Marc-Andre Lemburg
eGenix.com

Professional Python Services directly from the Source
>>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
________________________________________________________________________
2008-07-07: EuroPython 2008, Vilnius, Lithuania

:::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,MacOSX for free ! ::::


   eGenix.com Software, Skills and Services GmbH  Pastor-Loeh-Str.48
    D-40764 Langenfeld, Germany. CEO Dipl.-Math. Marc-Andre Lemburg
           Registered at Amtsgericht Duesseldorf: HRB 46611