6 Aug
2003
6 Aug
'03
3:07 p.m.
Chris: That is the code I'm having problems with. If I run that in psql, I get the number of decimal places specified by the numeric casting but, if I run it in a zsql I get just un decimal place regardless of what is specified in the cast operation. As suggested by Neil Smith in the zope-db list I could use a formating mask in dtml or zpt but I think that default behavior should be to left the query as it is. Thanks for your reply. Luis. Chris Withers wrote:
Luis Mariano Luporini wrote:
I've put "select 3::numeric(10,2)" in a zsql method, in a zpt that calls that method
This is the code you want to fix. What is the code you currently have?
Chris