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