Mailing List Archive: gadfly dbms,multiple records

gadfly dbms,multiple records

Oct 20, 2006, 9:33 AM

Post #1 of 3 (2625 views)

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

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

lists at zopyx

Oct 20, 2006, 9:49 AM

Post #2 of 3 (2491 views)

Permalink

--On 20. Oktober 2006 18:33:09 +0200 fabio gravina
<fabio.gravina@gmail.com> 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

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

charlie at egenix

Oct 20, 2006, 10:53 AM

Post #3 of 3 (2497 views)

Permalink

Am 20.10.2006, 18:33 Uhr, schrieb fabio gravina <fabio.gravina@gmail.com>:

> 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@zope.org
http://mail.zope.org/mailman/listinfo/zope-db