Remove decimal point from ZSQL query
Hi, I've got a ZSQL query e.g. sum(quantitya+quantityb) as totalc from.......... The result is stated in the form xx.0, how do I get rid of the .0? Regards, Mehmet
One of those days... sorry, solved it myself : <dtml-var expr="_.int(totalc)"> Regards, Mehmet On Friday 04 January 2002 07:26 am, you wrote:
Hi, I've got a ZSQL query e.g. sum(quantitya+quantityb) as totalc from.......... The result is stated in the form xx.0, how do I get rid of the .0?
Regards, Mehmet
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, try <dtml-var "_.int(_.float(totalc))"> just my 2 cents... Em Qui 03 Jan 2002 18:26, Mehmet Yousouf escreveu:
Hi, I've got a ZSQL query e.g. sum(quantitya+quantityb) as totalc from.......... The result is stated in the form xx.0, how do I get rid of the .0?
Regards, Mehmet
_______________________________________________ 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 )
- -- Fabiano Weimar dos Santos X3ng Web Technology Consultoria e Desenvolvimento Celular: 54 9114-7230 ICQ: 40187432 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE8NNDmTqbDpNXhEbERAkXGAKDHTIo9D/L/Ui2VKkTSCYtt+2/ICACgnzuV 3WPLqydC0sYfLehZUArPCSc= =56es -----END PGP SIGNATURE-----
participants (2)
-
Fabiano Weimar dos Santos -
Mehmet Yousouf