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 )