Hi Robert, You hit the nail on the head.
When I moved to the new server, I upgraded the ODBC connector. I will have to add format= Thanks Steve From: Robert Shubert [mailto:rshub...@tronics.com] Sent: Thursday, June 21, 2018 10:22 AM To: TeraScript-Talk@terascript.com Subject: RE: TeraScript-Talk: Numeric display default TS won’t process numbers unless you pass them through a number formatter using format= or @FORMAT or @CALC I suspect the default precision on your database is different now, what was 0 is now 6. Might also be a quirk of a new ODBC connector (maintaining more precision). If the column type is INT, this shouldn’t happen. It should happen on decimal/numeric/float types, however. TS doesn’t have a way to drop extra precision automatically. You may need to do a little experimentation to see nail down the root cause and the best fix for you. Let me know if you have a specific question or test case you want me to look at. Robert From: Fogelson, Steve [mailto:foge...@askics.net] Sent: Tuesday, June 19, 2018 11:40 AM To: TeraScript-Talk@terascript.com<mailto:TeraScript-Talk@terascript.com> Subject: TeraScript-Talk: Numeric display default I recently moved our TeraScript 7.1.3 apps to a new server. We are using MySQL 5.7 for the DB. Some of the tafs are now displaying numeric differently. IE: 9.000000 instead or 9 The tag is not formatted as indicated in the following example <@var request$InventoryValues[<@var request$InventoryRow>,InOwnerAvailable2]> Does anyone know of a default within the server.ini or somewhere else that defines a default for displaying a number if not formatted within the tag? Thanks Steve Fogelson Internet Commerce Solutions ________________________________ To unsubscribe from this list, please send an email to lists...@terascript.com<mailto:lists...@terascript.com> with "unsubscribe terascript-talk" in the body. ________________________________ To unsubscribe from this list, please send an email to lists...@terascript.com<mailto:lists...@terascript.com> with "unsubscribe terascript-talk" in the body. ---------------------------------------- To unsubscribe from this list, please send an email to lists...@terascript.com with "unsubscribe terascript-talk" in the body.