[Zope] Re: sql returning number

also sprach Derek S. Wilson <dwilson@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@madduck invalid/expired pgp subkeys? use subkeys.pgp.net as keyserver! unix, because rebooting is for adding new hardware.