Check out the functions: numberFormat() and decimalFormat() in http://localhost/CFDOCS/CFML_Reference/Functions2.html or the machine where you have cf installed.
When all else fails, type in your question at http://localhost/CFDOCS/search.cfm and inevidably cf has a function to answer. -----Original Message----- From: Phillip B [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 7:07 PM To: CF-Talk Subject: Stupid number format problem I need to store numbers in a SQL 2000 database and output them on a web page. The numbers will range from being .012345 - 999,999 I set up the datatype to be numeric with a precision of 16 and scale of 6. When I output the values to a web page I get numbers like 96.000000, 96.200000, 1234.000000. I am still new to SQL 2000 and I have never had this problem before. Can some one help me out? I am sure this is soooo basic but I just can't see the problem. Phillip Broussard Tracker Marine Group 417-873-5957 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
