AW: [Zope-DB] ZADODA

[Charlie Clark]

On 2004-10-21 at 12:50:19 [+0200], juergen.hauptmann 
<juergen.hauptmann at imc-krems.ac.at> wrote:
> I use ZADODA when I call the last insert ID with
> 
> SELECT @@IDENTITY
> 
> I get an Sytnax error....
 
> Probably yes. Check the documentation of your RDBMS.

Please keep the discussion on list.

Where are you getting the syntax error? From Zope or your database? Zope 
normally gives quite helpful tracebacks. What kind of RDBMS are you using? 
Have you tried the same statement directly in Python?

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 ! ::::