[Zope] SQL DATA CONVERSION

[Theodore Patrick]

SIMPLE QUESTION,

How do you modify a sql values formatting?

Example:
Here is my page it accesses a SQL_METHOD named flash_method, It is pulling
an item from ORACLE 8 that is set to the type NUMBER

When ZOPE Publishes the data to this page specifically:

<!--#var ITEM_SEQ null=""--> it reads 1.0 rather than 1

How do you convert an NUMBER to an INTEGER within the <!--#var ....--> TAG ?

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

<!--#in flash_method size=500 start=query_start-->
<!--#var ITEM_TYPE null=""--><!--#var ITEM_SEQ null=""-->_ID, "<!--#var ID
null=""-->"
<!--#var ITEM_TYPE null=""--><!--#var ITEM_SEQ null=""-->_VID, "<!--#var
VID_CODE null=""-->"
<!--#var ITEM_TYPE null=""--><!--#var ITEM_SEQ null=""-->_ACTIVE, "<!--#var
ITEM_ACTIVE null=""-->"
<!--#var ITEM_TYPE null=""--><!--#var ITEM_SEQ null=""-->_URL, "<!--#var URL
null=""-->"
<!--#var ITEM_TYPE null=""--><!--#var ITEM_SEQ null=""-->_EVENT, "<!--#var
ITEM_EVENT null=""-->"
<!--#var ITEM_TYPE null=""--><!--#var ITEM_SEQ null=""-->_PHOTO, "<!--#var
ITEM_PHOTO null=""-->"
<!--#var ITEM_TYPE null=""--><!--#var ITEM_SEQ null=""-->_DESC, "<!--#var
ITEM_DESC null=""-->"
<!--#var ITEM_TYPE null=""--><!--#var ITEM_SEQ null=""-->_PRICE, "<!--#var
ITEM_PRICE null=""-->"
<!--#else-->
  NO DATA FOR YOU!!!
<!--#/in-->

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

Thanks in advance!

Theodore E. Patrick
Indigo Networks