[ic] Price Format

Mathew Jones mat@booksellersolutions.com
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.

Thanks

Mat

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.
>
> Joachim
>
> --
> -------------Hans-Joachim Leidinger---------------------
>
> _______________________________________________
> Interchange-users mailing list
> Interchange-users@lists.akopia.com
> http://lists.akopia.com/mailman/listinfo/interchange-users