27 Nov
1999
27 Nov
'99
9:58 p.m.
hi everyone, i found a strange behavior regarding values returned from a ZOracleDA ZSQL query. maybe someone here knows how to get around it: ->table PAYMENT: AMOUNT ------ 5000 1.5 ->query select sum(AMOUNT) as total_cash from PAYMENT i am getting 5001 in zope instead of 5001.5 and even applying formatting to it like <dtml-var total_cash fmt="%.1f"> comes out to 5001.0, so i assume the value must get truncated by zope or by the database adapter. the same query in SQLPlus works as intended. has anyone come against this and found a workaround? jens
9627
Age (days ago)
9627
Last active (days ago)
0 comments
1 participants
participants (1)
-
Jens Vagelpohl