At 09:55 AM 2/14/2006, Charlie Griefer wrote: >1) use numberFormat(n, '9.99') or decimalFormat(n) to display the >value with 2 decimal places on the web page. whether it's stored as >4.1 or 4.10 in the database shouldn't be an issue. it's the same >value. displaying it in a specific format should be a function of the >presentation layer.
Thanks for the answer. So, if my variable is #GPA# and the value stored is "4", I should use numberFormat(#GPA#, '9.99') so that it is displayed as "4.00"? > > 2 - Each time one of the new numeric fields contains a comma and the > > field gets sent to the database, the system returns a generic error. > >2) again, numberFormat() will put the commas in on the presentation. >decimalFormat() might...not sure...need to check the docs. Ok, but the error described in 2) pertains to an input field in a form that contains a comma (e.g., "2,450.00") which is sent to a database. How could numberFormat() be used (if applicable) to format the number so that, when sent to the database, an error due to the comma is not generated? Thanks, Roberto ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:4:232298 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54