[Zope] return decimal values from ZSQL (Oracle) [Q]

Jens Vagelpohl tommymi@concentric.net
Tue, 28 Dec 1999 17:18:13 -0500


hi bruno,

i ran into something similar. you can force zope to display the variable as
a float by doing domething like:

<dtml-var myfloatvalue fmt="%.2f">

jens


> -----Original Message-----
> From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Bruno
> Mattarollo
> Sent: Tuesday, December 28, 1999 15:31
> To: zope@zope.org
> Subject: [Zope] return decimal values from ZSQL (Oracle) [Q]
>
>
> Hello...
>
> 	I am sorry to repost this message, but I didn't receive any
> reply so I presume that, since I sent this email on Dec 25, it
> passed un-noticed ;-)
>
> 	I have an Oracle table where a field is a NUMBER .... I do
> a SELECT field FROM oratable and I get "2.29" ... (without quotes ;-)
>
> 	But when doing the same SELECT from a ZSQL I get "2" ... no
> decimals. I don't know if it's an Oracle specific problem...
> Anyone has a clue? I tryied using the TO_NUMBER(field, '9999.99')
> function but it returns "2"...
>
> 	TIA
>
>
> /B
>
> Bruno Mattarollo <brunomadv@ciudad.com.ar>
>
> _______________________________________________
> Zope maillist  -  Zope@zope.org
> http://lists.zope.org/mailman/listinfo/zope
> **   No cross posts or HTML encoding!  **
> (Related lists -
>  http://lists.zope.org/mailman/listinfo/zope-announce
>  http://lists.zope.org/mailman/listinfo/zope-dev )
>
>