[Zope-DB] ZADODA

[Charlie Clark]

On 2004-10-21 at 09:47:37 [+0200], juergen.hauptmann 
<juergen.hauptmann at imc-krems.ac.at> wrote:
> Hi
> 
> I have the following problem. I cannot do more than one INSERT in a ZSQL 
> Method.
> 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.

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,Linux,Solaris,FreeBSD for free ! ::::