[Zope] float calculation in ZSQL Method??

Atuc atuc@gmx.de
Mon, 04 Nov 2002 12:26:41 +0100


hallo,

i have the problem to make a calculation in an ZSQL Method, i would like to 
add the two floats like this. what i get is only a string adding!

i get this if i give the numbers 1 and 100, i would like to get 101

SQL used:
select * from RegionRef
where
ContainerId1 = 'c3b0fef5-4ab7fb9e-4abe43d4-7f149316' AND
RegionRef.positionX >= 1 AND
RegionRef.positionX <= 1100


any ideas if it is possible?

this is my ZSQL Method:

select * from RegionRef
where
ContainerId1 = <dtml-sqlvar ContainerId type=string> AND
RegionRef.positionX >= <dtml-sqlvar Position1 type=float> AND
RegionRef.positionX <= <dtml-sqlvar expr="Position1+Position3" type=float>

thanks
alex