[ic] Price Format

[Cameron B. Prince]

You might also consider changing the column types in the database
definitions to something like FLOAT(4) anywhere a dollar amount is stored. I
have had to do this before, especially if I needed to do something like
select sum(subtotal) from transactions.

Good luck,

Cameron

> -----Original Message-----
> From: interchange-users-admin@lists.akopia.com
> [mailto:interchange-users-admin@lists.akopia.com]On Behalf Of
> Hans-Joachim Leidinger
> Sent: Wednesday, January 17, 2001 1:56 PM
> To: interchange-users@lists.akopia.com
> Subject: Re: [ic] Price Format
>
>
> 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