Use the SQL Server str() function in your query to format the number the way you want it.
----- Original Message ----- From: "Cornillon, Matthieu" <[EMAIL PROTECTED]> Date: Wednesday, July 24, 2002 10:23 am Subject: RE: Stupid number format problem > 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 > machinewhere > > 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/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists