I never really paid attention to this but when I u...
# luceea
amcfml
12/08/2022, 4:04 PMI never really paid attention to this but when I upgraded to 5.3.10.97 it seem to crash out all the paypal payflow transactions. The values for these transactions come out of a mssql database and paypal rejects then now because they have the 4 decimals (money datatype). I could go in an change the datatype or numbeformat before being sent to paypal but it is going to be a good deal of work. Any setting I can change anywhere that would change the way ms sql is formating or lucee is formating it as of the upgrade to Lucee?
z
zackster
12/08/2022, 4:05 PMwhich db?
zackster
12/08/2022, 4:06 PMsorry, i see mssql
zackster
12/08/2022, 4:10 PMalas, lucee is basically respecting the data type definition
a
amcfml
12/08/2022, 4:13 PM...which is of course good... but in my situation not so great 😞
p
Patrick
12/08/2022, 4:23 PMCan you not just numberFormat your own value you are passing into the Paypal api?
a
amcfml
12/08/2022, 4:29 PMYes, I am in the process of doing that... was hoping someone knew of a setting that could change its new behavior.
p
Patrick
12/08/2022, 4:46 PMdb column type change or code side; both seem pretty simple
a
amcfml
12/08/2022, 5:55 PMSimple yes, but the number of instances that have to be adjusted is why I was inquiring for a more global approach.