[Zope] SQL DATA CONVERSION

Michel Pelletier michel@digicool.com
Wed, 21 Jul 1999 10:57:01 -0400


> -----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