2. PHPRunner General questions
  3. Values disappear if set at currency
This topic is locked

Values disappear if set at currency

 		11/21/2012 6:53:35 AM
PHPRunner General questions
S
 swanside author

Hello.

I have just been informed that the values in one of my tables will not show.
If I set the field as blank in the view as, my field will display 24.95, if I set it as currency it displays nothing where it should display £24.95

Any ideas as to why this happens?

Thanks

Paul
C
 		cgphp 11/21/2012

Are you using alias fields?
S
 		swanside author 11/21/2012



Are you using alias fields?



I am using alias fields in the SQL statements, but not on the fields that are not displaying the values.

Strange thing is, I tried to make a demo to show the problem and it does not present the fault at all, so I can not simulate it.
Sergey Kornilov admin 11/21/2012

Something is not right with regional settings so 24.95 value is not recognized as a number? Really hard to tell what might be wrong based on this info.