[Zope] Simple question? Increment by 1!

[Michael Billimoria]

Hi there,

I hope this is going to the right forum - if not, my apologies. :-)

I'm hoping that this is a fairly simple question to be answered - I'm
fairly new to Zope and am only a novice programmer at best :-)

I am running a MySQL query (Find_Last_Callnote) which looks like this - 

select max(CALLNOTENUM) from callnote
where JOBID = '<dtml-sqlvar JobID type="int">'

so basically I'm trying to get the maximum value in field CALLNOTENUM
given a specific jobID.

This all works fine however what I want to do then is increment the last
CALLNOTENUM by 1 and then add a new callnote with that number

So my DTML Method looks something like this except I have left out the
bit where I would have to increment the number by 1 and then call the
update function - 

<dtml-in Find_Last_Callnote>

<dtml-if max(CALLNOTENUM)>
   <p>This is not the first callnote</p>
   ?????? WHAT DO I DO HERE ??????
<dtml-else>
   <p>This is the first callnote</p>
   <dtml-call Insert_First_Callnote>
</dtml-if>

</dtml-in>

Unfortunately when using SQL functions such as 'max' the dtml variables
assigned come back which Brackets in them - this means that if I try to
do a <dtml-if expr="max(CALLNOTENUM etc.)"> the dtml is not interpreted
correctly and results in an error.

I assume I might have write a python script to pull this off, is that
true? and if so how would I do that. Of course I'm probably trying to do
this the hard way, so if there is an easier way could you let me know?
:-)

Many thanks,

Michael