Re: question!

From: Matt Foster <matt.foster_at_ed.ac.uk>
Date: Tue, 28 Mar 2000 10:05:07 +0100
Message-ID: <38E075C3.C77293E3_at_ed.ac.uk>


Chrystian Barragan wrote:
>
> Hi everybody!
>
> I have a problem, and I hope any of you could help me.
>
> I'm working with OAS 4.0.8.1 on NT, I'm developing some "test
> applications" using the PL/SQL cartridge and in one of them I'm using
> the function: owa_util.cellsprint(), which generates a table in HTML
> format with the result of a query, well, what I want to do is to format
> a column which contains a quatity of money, I mean, if you have this:
> 23456.6, I want it to be printed this way: $ 23, 2456.60, but I don't
> know how to specify the format. In this procedure there is an attributte
> which is for format number, but I don't know what values are allowed...
>
> Thanks in advance for any help!!

The format of the result should be $999,990.00 or if database is set to work in currency other than dollars you can use L999,990.00 to get this currency symbol.

MF Received on Tue Mar 28 2000 - 11:05:07 CEST

Original text of this message