THANKS a ton! The service more than anything is what sets your product apart from others! Best, Ted -----Original Message----- From: Michel Pelletier [mailto:michel@digicool.com] Sent: Wednesday, July 21, 1999 9:57 AM To: 'Theodore Patrick'; zope@zope.org Subject: RE: [Zope] SQL DATA CONVERSION

-----Original Message----- From: Theodore Patrick [mailto:tpatrick@IndigoNetworks.com] Sent: Wednesday, July 21, 1999 9:06 AM To: zope@zope.org Subject: [Zope] SQL DATA CONVERSION

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

Use <!--#var fmt="..."--> in the ... you can put a C printf style format string and format the rendering of the #var anyway you want. http://www.zope.org/Documentation/Guides/DTML/DTML-HTML/DTML.5.1.html -Michel _______________________________________________ Zope maillist - Zope@zope.org http://www.zope.org/mailman/listinfo/zope (To receive general Zope announcements, see: http://www.zope.org/mailman/listinfo/zope-announce For developer-specific issues, zope-dev@zope.org - http://www.zope.org/mailman/listinfo/zope-dev )