I have a slight problem… I’m working on a project management zope site, and I need to create a new sequential project ID for each project. I made a zsql statement as follows…

select MAX(ID)+1 from AllProjects

This gives the expected:

(Maximum(ALLPROJECTS.ID))+()

3

I now want to take that value(3) and use it as my ID. The column name is ID, So, here’s how I go about doing it.

<dtml-in getNewProjectID>

Here’s the ID: <dtml-var ID>

</dtml-in>

but it keeps giving me a ‘KeyError” – “ID”

of course, lowercase id just shows the name of the folder that the dtml document is in.

So, does anyone know how I can put that result into my webpage?

Thanks,

Derek S. Wilson

*****HIPAA Confidentiality Notice*****
The documents inside this electronic transmission contain confidential information belonging to the sender that is legally privileged. This information is intended only for the use of the individual or entity named above. The authorized recipient of this information is prohibited from disclosing this information to any other party and is required to destroy the information after its stated need has been fulfilled, unless otherwise required by law. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution, or action taken in reliance on the contents of these documents is strictly prohibited. If you received this electronic transmission in error, please notify the sender immediately to arrange for return.