[Zope] Re: sql returning number

[martin f krafft]

also sprach Derek S. Wilson <dwilson at vhswest.com> [2003.09.25.2214 +0200]:
> select MAX(ID)+1 from AllProjects

make that

  select MAX(ID)+1 as NEXTID from All Projects

and then

> <dtml-in getNewProjectID>
> 
> Here's the ID: <dtml-var ID>

<dtml-var NEXTID>

> 
> </dtml-in>

-- 
martin;              (greetings from the heart of the sun.)
  \____ echo mailto: !#^."<*>"|tr "<*> mailto:" net at madduck
 
invalid/expired pgp subkeys? use subkeys.pgp.net as keyserver!
 
unix, because rebooting is for adding new hardware.
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.zope.org/pipermail/zope/attachments/20030926/2aeba48f/attachment.bin