charlie at egenix.com
Thu Oct 21 06:05:25 EDT 2004
On 2004-10-21 at 09:47:37 [+0200], juergen.hauptmann
<juergen.hauptmann at imc-krems.ac.at> wrote:
> I have the following problem. I cannot do more than one INSERT in a ZSQL
> I always get the error:
> Any Ideas??
Yes, don't use <dtml-sqldelimiter>! Write each SQL call as an individual
ZSQL method and call them sequentially from a PythonScript to stay in the
same transaction. This makes debugging a lot easier.
> The Second Problem I have is how can I read the Last inserted ID form the
> DB? Is there a function?
Probably yes. Check the documentation of your RDBMS.
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,Linux,Solaris,FreeBSD for free ! ::::
More information about the Zope-DB