[Zope] ZSQL: Insert a result from a sql query

[Gitte Wange]

Hello,

I am trying to insert a result from a sql query into another query

I am selecting 1+max(ordernum) from a table as newordernum and then
tries to insert this into a table.
I call the sql method like this:
<dtml-call expr="sqlAddNewClip(ordernum=newordernum)"> but keeps getting
an error:
Error Type: NameError
Error Value: newordernum

Please .. I have searched the mailinglist archieves for an answer but
gets none

-- 
************************
Gitte Wange Jensen

System Squid Developer
MMManager Aps
+45 29 72 79 72

gitte@mmmanager.org
************************