I am using an integration to grab a bunch of numbers from an external source. Most of the numbers are fine, but some are exceptionally large or small to the point that they come in in scientific notation. Examples include:
2.2141276E - 5
and
2.1383022233807285E11
Both of these numbers give me separate errors. For the first, I'm getting an "invalid double value", which I seems to be due to the spaces in there so I need to I guess strip the spaces, despite it not being a string? I think one way or another I can find a way to deal with that. But the other error I get is when actually writing to the database. I keep getting an "Out of range value" error despite having set the db field to accept 20 digits.
Discussion posts and replies are publicly visible
HI Marco, what is the datatype you are using in your DB to store these values? did you try to use text() function to format the value?