Well, if he were to do calculations after he gets the query, CF doesn't
know or care that it's been casted to a string.
If he wants to do calculations in SQL Server in that particular query,
he doesn't need to use the str'd field.
----- Original Message -----
From: "Brian J. LeRoux" <[EMAIL PROTECTED]>
Date: Wednesday, July 24, 2002 10: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
> trailing0'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
> > >
> > >
> > >
> > >
> > >
> >
> >
>
>
______________________________________________________________________
Your ad could be here. Monies from ads go to support these lists and provide more
resources for the community. http://www.fusionauthority.com/ads.cfm
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
