2. PHPRunner General questions
  3. Column type money?
This topic is locked

Column type money?

 		1/20/2005 10:03:45 AM
PHPRunner General questions
author

If you have a price column, is there a way to have mysql, or your program, automatically put the dollar sign in front of the value when it is displayed in the table?
Sergey Kornilov admin 1/20/2005

Zack,
try to set View as type for this field to Currency.
G
 		gluckett 3/18/2009

How do you do this in EDIT/ADD mode? I would like the user see the Currency in the TEXT box.
thanks

gordon

If you have a price column, is there a way to have mysql, or your program, automatically put the dollar sign in front of the value when it is displayed in the table?
J
 		Jane 3/19/2009

Gordon,
use Edit page: Before display event on the Events tab for this purpose.

Here is a sample:

global $control_FieldName;

$control_FieldName["params"]["value"] = format_curency($control_FieldName["params"]["value"]);