My admin form and site form (Joomla v3.3.3 and Seblod v3.3.6) contain a field 'price'. This field is a Text field with format Var50. Input and display of numbers is like 123.456.789,00. Everything worked well until I installed the plugin Search Ordering. The ordering jumped from 100,99 to 11 and not to 101,00. So I changed the format from Var50 into Decimal(10,2). After that, ordering is what it should be, but numbers are displayed like 123,456,789.00, input the same. Installing language Dutch in Joomla and Seblod, neither language overrides changed the way numbers are displayed. I have searched everything I could without success. How to change the way numbers are displayed in Seblod forms? Who knows?
Hi.
Maybe you can save numbers in flat format in some table and use core42 filed with number_format function to make numbers look like you want and render it also with this field.
Hi Randy,
Thanks for your reply, unfortunately it does not help me.
The plugin mask validates the input, it does not change a ',' in a '.' before storage of the input in the table and it does not change a '.' in a ',' on displaying the stored decimal in my list. Before I can use the Language field to show the right field and hide the wrong one, I must have the field with the right format, but that is the question.
My list must be ordered by 'price' and therefore 'price' must be a decimal. I am disappointed in Seblod's handling of decimals. It is to basic for an extra plugin like Code Pack.
Meanwhile, I have found a solution for the display of the feld 'price' in the list form. In my template a have changed
<? Php echo $ cck_renderFiled ('price');> to
<php echo number_format ($ CCK?> GetValue (prijs_eb), 2, ",", ".");? >.
For my list, it's this. For now I still need something for the input in the admin form.
Sorry, 'prijs_eb' must be 'price'.