This topic is locked

2 decimal placement

2/14/2007 12:40:32 PM
PHPRunner General questions
L
lawfour author

How do i get the DB to display decimal of $152.55 instead of $153.00 The total field in the table is set to Decimal.
I checked the forum but nothing worked.
I checked the locale.php and this is what it has
// currency settings

$locale_info["LOCALE_ICURRDIGITS"]="2";

$locale_info["LOCALE_ICURRENCY"]="0";

$locale_info["LOCALE_INEGCURR"]="0";

$locale_info["LOCALE_SCURRENCY"]="44";

$locale_info["LOCALE_SMONDECIMALSEP"]=".";

$locale_info["LOCALE_SMONGROUPING"]="3;0";

$locale_info["LOCALE_SMONTHOUSANDSEP"]=",";

// numbers formatting settings

$locale_info["LOCALE_IDIGITS"]="2";

$locale_info["LOCALE_INEGNUMBER"]="1";

$locale_info["LOCALE_SDECIMAL"]=".";

$locale_info["LOCALE_SGROUPING"]="3;0";

$locale_info["LOCALE_SNEGATIVESIGN"]="-";

$locale_info["LOCALE_SPOSITIVESIGN"]="";

$locale_info["LOCALE_STHOUSAND"]=",";

Z
zavka 2/14/2007

Hi
Set correct precision for decimal field in datebase

L
lawfour author 2/14/2007

Thanks that worked. I did not make changes in phprunner but it was set at 10. I used phpmyadmin to make chages. Can I make the decimal change in phprunner (10,2)?
That would be good to know for someone else.
Thanks

L

Alexey admin 2/15/2007

Larry,
you can modify tables structure in PHPRunner. However this option is available for tables you created with PHPRunner only.