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

[Bruno Mattarollo]

Hello...

	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>