OK. This is a wretched solution, but you could convert the number to a string, CFLOOP as long as Right(MyString,1) = "0", and then within the loop remove that last character. At the end of it, you convert it back to a number.
I'm almost sorry for even suggesting such an ugly, albeit workable, solution. Hope it helps, Matthieu -----Original Message----- From: Phillip B [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 23, 2002 11:04 PM To: CF-Talk Subject: Re: Stupid number format problem I thought of that but there aren't any functions that I can find that will handle all the variants I could have. I just need to make sure all the extra zero's wont be displayed. Phillip Broussard Tracker Marine Group 417-873-5957 ----- Original Message ----- From: "Brian J. LeRoux" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Tuesday, July 23, 2002 9:13 PM Subject: RE: Stupid number format problem > 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 > > > > > ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
