[ic] Price Format
Wed, 17 Jan 2001 12:24:59 -0800
Great advice, however my client has over 20,000 itmes in his local database which
all have this format. For him to change this would be extremely time consuming.
I hope there is another way to do this.
Hans-Joachim Leidinger wrote:
> Mathew Jones wrote:
> > I am having problems displaying the price of an item in the correct format
> > even though it appears the way I want it in my SQL table. In my SQL db the
> > price for example, would be $25,000. but when I pull up the book info, it
> > displays in interchange as $25.00
> > Is there a setting I need to change in the catalog.cfg, or a special tag I
> > need to place around the [item-price] tag and other price related tags such
> > as total, subtotal, extension??
> The best way is to format all price in your SQL talble without any
> character like $. Make a test and replace $25,000 to 25,000.00 or
> 25000.00 and see what you get.
> -------------Hans-Joachim Leidinger---------------------
> Interchange-users mailing list