Mailing List Archive: Zope: DB

gadfly dbms,multiple records

Index | Next | Previous | View Threaded

fabio.gravina at gmail

Oct 20, 2006, 9:33 AM

Post #1 of 3 (1634 views)
Permalink

gadfly dbms,multiple records

I want to store more than one records in a single call of zsql method, or
something like LOAD DATA in mysql..
Someone help me
by

--
"http://www.spreadfirefox.com/?q=affiliates&id=115991&t=1" Get
Firefox!
"http://counter.li.org/" LINUX COUNTER USER 394013

lists at zopyx

Oct 20, 2006, 9:49 AM

Post #2 of 3 (1519 views)
Permalink

Re: gadfly dbms,multiple records [In reply to]

--On 20. Oktober 2006 18:33:09 +0200 fabio gravina
<fabio.gravina [at] gmail> wrote:

> I want to store more than one records in a single call of zsql method, or
> something like LOAD DATA in mysql..

You can specify multiple INSERT statements within ZSQL method.

-aj

charlie at egenix

Oct 20, 2006, 10:53 AM

Post #3 of 3 (1526 views)
Permalink

Re: gadfly dbms,multiple records [In reply to]

Am 20.10.2006, 18:33 Uhr, schrieb fabio gravina <fabio.gravina [at] gmail>:

> I want to store more than one records in a single call of zsql method, or
> something like LOAD DATA in mysql..
> Someone help me

Use an ExternalMethod and executemany().

Charlie

--
Charlie Clark
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/
Try mxODBC.Zope.DA for Windows, Mac OS, Linux, Solaris, FreeBSD for free!
_______________________________________________
Zope-DB mailing list
Zope-DB [at] zope
http://mail.zope.org/mailman/listinfo/zope-db

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads