[Zope] Simple question? Increment by 1!

[Arno Gross]

Hello Michael,

Change your select statement a little bit and adjust your DTML method:

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

and adjust the DTML method:

<dtml-in Find_Last_Callnote>
 <dtml-if theMaximum>
  We have a Maximum:  <dtml-var theMaximum>
  <dtml-let theMaximum="theMaximum+1">
    New Maximum: <dtml-var theMaximum>
  </dtml-let>
 <dtml-else>
  We have no Maximum
 </dtml-if>
</dtml-in>

G'day
  Arno

On Sat, 09 Jun 2001, Michael Billimoria wrote:
> 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
> 
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists - 
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )