First thanks for the help. Second, where can I get some good info on UDF's? I was thinking of making on out of it but I don't know how.
Phillip Broussard Tracker Marine Group 417-873-5957 ----- Original Message ----- From: "Brian J. LeRoux" <[EMAIL PROTECTED]> To: "CF-Talk" <[EMAIL PROTECTED]> Sent: Wednesday, July 24, 2002 11:53 AM Subject: RE: RE: Stupid number format problem > the problem is that function returns a string. Which is kinda sloppy to deal > with if you want to use the values for any type of calculations (it can be > done by converting the string back to a number but thats why its sloppy!). > > A cleaner solution would be to write your own udf that removes the trailing > 0's and returns the value. > > <cfscript> > function removeTrail(arg) { > // some kind of regex here? > // c'mon. I'm not writing the whole thing! > } > </cfscript> > > <cfoutput query="getNums">#removeTrail( getNums.theNum )#<cfoutput> > > After you write this udf upload it to www.cflib.org so others don't have to > waste precious keystrokes or braincells. > > Good luck, > Brian > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, July 24, 2002 9:30 AM > To: CF-Talk > Subject: Re: RE: Stupid number format problem > > > 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 > > > > > > > > > > > > > > > > > > > > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm 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