[Zope] ZSQL dtml request problem

[Davis Mr MR]

Hi,

Thanks for everyone's help with this.

I managed to fix it by rejigging the way my results were called, as I'm
using ZPT with macros for the displays. Instead of retrieving the record in
the macro, I moved the retrieve out, and just used the macro for the display
(would be better for reuse anyway, I think).

So the record just inserted can easily be retrieved just using the same SQL
statement.

INSERT INTO suppliers etc..
<dtml-var sql_delimiter>
SELECT * FROM suppliers WHERE supplierid=last_insert_id()

Works fine.
Thanks
Michael

-----Original Message-----
From: Dieter Maurer [mailto:dieter@handshake.de]
Sent: 13 June 2003 21:46
To: Davis Mr MR
Cc: 'zope@zope.org'
Subject: Re: [Zope] ZSQL dtml request problem


Davis Mr MR wrote at 2003-6-12 17:11 +0100:
 > I'm trying to push the last_inset_id from an Insert statement onto the
 > request namespace, so I can pick it up and retrieve the new record for
 > display.
 > 
 > My ZSQL method looks like this.
 > 
 > INSERT INTO suppliers (insert statements removed)
 > <dtml-var sql_delimiter>
 > SELECT last_insert_id() AS lastinsertid
 > <dtml-call "REQUEST.set('id',lastinsertid)">
 > 
 > It comes back with a NameError - global name 'lastinsertid' is not
defined.

The results of ZSQL methods are not automatically added to the
DTML namespace. You can use


     <dtml-with expr="your_ZSQL_Method()[0]"> ... </dtml-with>

to push the first result row onto the DTML namespace ("during" the with).


Dieter