Numeric mysql query return number + m

[joancarlesadc]

Hi, after 6.5.5 update, my application return mysql query numeric (decimal) values as string number+m

[Satoshi]

I have the same issue.

[Teodor]

What database are you using and what server model? Also what is the exact database field type you are using?

[George]

See:

After 6.5.5 Update, decimal value on live site returns NAN!

Yes decimal fields are now fully supported and send to the client side app connect in a special notation ending with ‘m’ to be recognized and threaten as decimals client side as well - this is the new upcoming JavaScript standard as well. App Connect should pick up the new decimals and show and format them well. Do note that just as with the new bigint (those end with ‘n’) all involved numbers in an expression should be of the same type! So you can’t have: 22.44m + 1 But should be: 22.44m …

[brad]

Weren't decimal fields supported before? So is there anything different we need to be doing that we haven't done before? Or something that we were doing that we no longer need to do?

I'm just curious as it seems all of my decimal values are displaying correctly. I also use bigint a lot. Is there anything we should know about that?

[George]

Decimals fields were becoming regular numbers in client side JavaScript and calculations with those could result in rounding errors.

Now we support decimals and also the special decimal calculations that gives the right results.

[brad]

Hmmm, so is this still the recommended approach?

<td dmx-text="cost_amount.toNumber().formatCurrency('$', '.', ',', 2)"></td>

[George]

You don’t need to convert decimals to number, just format them directly.

[Satoshi]

Currency formatter does not work with the the output. Either formatted to number or just plain right decimal. Is there something else I should be doing? Plain number still shows my output with "m" and format currency doesnt do anything. It just display Ïnvalid Number"

[Satoshi]

DId you find a solution @joancarlesadc

[brad]

Seems to be working for me with PHP/MySQL. What server model and database are you using?

@Teodor

What database are you using and what server model? Also what is the exact database field type you are using?

[Satoshi]

HI @brad Node.js & MySQL (Decimal)

This is what I get without .formatCurrency. With format currency:

Nothing shows

PS: I did a Force Update all framework files when I updated to wappler 6.5.5.

[brad]

I found you have to convert to number for it to show. So convert your binding to number then format currency. It works for me 'sometimes'.

Hmmm, I don't get the m on the end with a straight binding either?

This displays properly:

<td dmx-text="decimal_value.toNumber().formatCurrency('$', '.', ',', 2)"></td>

This displays nothing:

<td dmx-text="decimal_value.formatCurrency('$', '.', ',', 2)"></td>

[patrick]

The Decimal support is still Work in Progress and was added by accident in the last update. We will revert that change so that the old behavior is back. Depending on the database driver you then get it as Number or as String.

We want to support Decimals because the default JavaScript Number is not very precise. With JavaScript Number 0.3 - 0.1 = 0.19999999999999998 and with Decimal 0.3 - 0.1 = 0.2.

MikeMcl/decimal.js: An arbitrary-precision Decimal type for JavaScript (github.com)

To recognize the number as a decimal in expressions we will use the m as a suffix. We also support BigInt with the n as suffix.

[Teodor]

An inline update has been released, it reverts the old behavior back, so no m will be added to the values.