Can someone tell me how to take a variable and make it round up to the
next whole number?
Kristopher Pilles
Website Manager
Western Suffolk BOCES
507 Deer Park Rd., Building C
Phone: 631-549-4900 x 267
E-mail: [EMAIL PROTECTED]
<>
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubs
Can anyone help me on this. here is my querey and then the output. it seems to be
rounding the SUM (TimeTaken) as TotalTime variable.
im tring to get it to output something like 12.03 or 03.98 ect
SELECT ContestantID, SUM (AdjPoints) as TOTALPTS, SUM (Points) as PTS, SUM (TimeTaken)
as
Sorry for the noddy nature of the question but its 5.30 i've had a tooth out
today and i'm getting no sympathy :)
how do i round a number i've got as a result of a piece of arithmatic?
Thanks as always
Stew
--
Archives:
is it ceiling()
-Original Message-
From: Kristopher Pilles [mailto:[EMAIL PROTECTED]
Sent: Friday, January 23, 2004 3:24 PM
To: CF-Talk
Subject: Number rounding
Can someone tell me how to take a variable and make it round up to the next
whole number?
Kristopher Pilles
Website Manager
#int(var + 0.9)#
OR
#int(var + 0.5)# if you want usual mathematical rounding.
--
Ian Skinner
Web Programmer
BloodSource
www.BloodSource.org
Sacramento, CA
-Original Message-
From: Kristopher Pilles [mailto:[EMAIL PROTECTED]
Sent: Friday, January 23
#roundedUp#
hth
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Friday, January 23, 2004 3:29 PM
To: CF-Talk
Subject: RE: Number rounding
is it ceiling()
-Original Message-
From: Kristopher Pilles [mailto:[EMAIL PROTECTED]
Sent: Friday, January
THANKS!
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Friday, January 23, 2004 3:31 PM
To: CF-Talk
Subject: RE: Number rounding
#roundedUp#
hth
tony
-Original Message-
From: Tony Weeg [mailto:[EMAIL PROTECTED]
Sent: Friday
field for number and as Long Integer and General Number and Auto Decimal in
the field properties. The Default Value is 0.
Any other way I can prevent Access from auto-rounding?
Thanks.
Robert O.
__
Get the mailserver that powers
Hello:
I have the NumberFormat() func rounding up a number. The result is one
integer higher than the original integer.
Example:
NUMBERFORMAT(5111, '')
This yields 5112 on CF 4.5.
It's supposed to print 5111.
> Can anyone help me on this. here is my querey and then the
> output. it seems to be rounding the SUM (TimeTaken) as TotalTime variable.
> im tring to get it to output something like 12.03 or 03.98 ect
>
> datasource="#datasource#"
> dbtype=&
gn
Web Pro USA
406.549.3337 ext. 203
1.888.5WEBPRO
www.webpro-usa.com
- Original Message -
From: "Philip Arnold - ASP" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 12:43 PM
Subject: RE: SUM rounding
> > Can anyone hel
> Error Diagnostic Information
> ODBC Error Code = 37000 (Syntax error or access violation)
>
> [Microsoft][ODBC Microsoft Access Driver] Undefined function 'Convert' in
> expression.
>
> The error occurred while processing an element with a general
> identifier of
> (CFQUERY), occupying document
; <[EMAIL PROTECTED]>
Sent: Monday, February 19, 2001 1:41 PM
Subject: RE: SUM rounding
> > Error Diagnostic Information
> > ODBC Error Code = 37000 (Syntax error or access violation)
> >
> > [Microsoft][ODBC Microsoft Access Driver] Undefined function 'Convert'
We have some numbers to display that have 5 decimal places in the Database
but we only want to display two of the decimal places but without rounding
the up or down, in other words 10.69751 needs to display as 10.69. Using
Number( or LSNumber( and masks rounds the number up or down.
Anyone got
I am using a float datatype in the database and calculating some numbers
on the page.
The calculation seems to round up the numbers to the nearest integer,
even when I use
numberformat or decimal format. How can I prevent it doing this?
Example below
ctions can help me with this problem.
Shawn Regan
--_=_NextPart_001_01BFCF08.CAF928F0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
rounding numbers with CF
Hey CF people,
I have been using the round() function. It r
es
Ektron, Inc.
http://www.ektron.com
5 Northern Blvd, Suite 6
Amherst, NH 03031
Tel: 603-594-0249
Fax: 603-594-0258
> -Original Message-
> From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 06, 2000 12:42 PM
> To: '[EMAIL PROTECTED]'
> Subjec
formatting
section of the CF functions where you will find decimalformat, dollarformat,
numberformat, etc.
Dan
-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 9:42 AM
To: '[EMAIL PROTECTED]'
Subject: Rounding of numbers
Sor
Try:Round(number)
It returns a number to the closest integer.
Jim
-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 12:42 PM
To: '[EMAIL PROTECTED]'
Subject: Rounding of numbers
Sorry for the noddy nature of the questi
If your number variable is #Number#
Then you simply say #Round(number)#
-Original Message-
From: Stewart McGowan [mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 06, 2000 11:42 AM
To: '[EMAIL PROTECTED]'
Subject: Rounding of numbers
Sorry for the noddy nature of the questi
tewart McGowan [mailto:[EMAIL PROTECTED]]
> Sent: Thursday, July 06, 2000 9:42 AM
> To: '[EMAIL PROTECTED]'
> Subject: Rounding of numbers
>
>
> Sorry for the noddy nature of the question but its 5.30 i've had
> a tooth out
> today and i'm getting no symp
Thanks guys, got it sorted, (and purchased a whole load of pain killers)
Stew
-Original Message-
From: Mark Warrick [mailto:[EMAIL PROTECTED]]
Sent: 06 July 2000 22:01
To: [EMAIL PROTECTED]
Subject: RE: Rounding of numbers
You can use the ROUND() function. (Go figure)
There are many
;
>Any other way I can prevent Access from auto-rounding?
>
>Thanks.
>
>Robert O.
>
__
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/f
umber and as Long Integer and General Number and Auto Decimal
>in the field properties. The Default Value is 0.
>
> Any other way I can prevent Access from auto-rounding?
>
> Thanks.
>
> Robert O.
>
__
uh...sorry robert.
marlon's right...that was a braindead reply on my part. setting
the type to double should do it.
~ dina
- Original Message -
From: "Marlon Moyer" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Friday, May 31, 2
Change the number type to double.
-Original Message-
From: Robert Orlini [mailto:[EMAIL PROTECTED]]
Sent: Friday, May 31, 2002 11:14 AM
To: CF-Talk
Subject: Rounding in Access
I know this was answered nicely before and I tried the suggestion, but it
did not work.
In Access I have
I thought this would be simple. How can round a long integer eg: 2.146752 to
the first decimal point?
Thanks,
Rick
Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/
Unsubscribe: http:
Can anyone tell me why the following code from CFWebstore rounds numbers to
the nearest 1?
INPUT:
ACTION:
--
Jon Tillman
www.smokingpipes.com
www.tobaccoreviews.com
www.eruditum.org
~~
Structure your ColdFusion code with
Hi all,
Who knows the function for rounding UP to the nearest number?
Eg. If I have the number 2.33 etc, what's the CF syntax for rounding
this number UP to 3 (instead of down to 2)?
Thanks in advance,
Benjamin Falloon
~~
Structure
Has anyone done "Banker's rounding" with ColdFusion?
eg:
Function BRound(ByVal X As Double, _
Optional ByVal Factor As Double = 1) As Double
' For smaller numbers:
' BRound = CLng(X * Factor) / Factor
Dim Temp As Double, FixTemp As Doub
, December 05, 2001 11:37 AM
To: CF-Talk
Subject: NumberFormat() Rounding Up
Hello:
I have the NumberFormat() func rounding up a number. The result is one
integer higher than the original integer.
Example:
NUMBERFORMAT(5111, '')
This yields 5111
I am running ColdFusion server 5.0 and when flipping through the docs I do not see any
Math functions to round to a particular number of significant digits. Plus on
Allaire's site I know about the custom tag gallery, but I do not see a UDF (user
defined function) gallery. Then when I searched
> We have some numbers to display that have 5 decimal places in the Database
> but we only want to display two of the decimal places but without rounding
> the up or down, in other words 10.69751 needs to display as 10.69. Using
> Number( or LSNumber( and masks rounds the numbe
f __.__) and
neither has worked
Any ideas?
Thanks!
hatton
> -Original Message-
> From: Dave Carabetta [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, February 20, 2002 11:29 PM
> To: CF-Talk
> Subject: Re: Not Rounding Decimals
>
>
> > We have some numbers
You can easily turn that code into a nice UDF and upload it to cflib.
org :)
-Original Message-
From: Dave Carabetta [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, February 20, 2002 9:29 PM
To: CF-Talk
Subject: Re: Not Rounding Decimals
> We have some numbers to display that hav
es to the right, truncate, then
move it back):
But because of the way most computers represent base-10 floating point
numbers in their native binary format, this will in some instances cause a
rounding error at the last decimal point. For instance,
10.7894 --> 10.78
but
88954312.59
This is pretty simple:
#left(num, find('.', num) + 2)#
--
Bud Schneehagen - Tropical Web Creations
_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/_/
ColdFusion Solutions / eCommerce Development
[EMAIL PROTECTED]
http://www.twcreations.com/
_
I am not sure if this is a bug or not, nor if it has been discussed,
but I just ran into it so I'd thought I'd share
"booga#nfactor#W"
equals
"booga2.000W"
"booga#nfactor+1#W"
equals
"booga3W"
Kind of odd that it looses it's precision - but that may be by design
I suppose. You can use number
How can I make NumberFormat() round UP instead of down? For example:
NumberFormat(Evaluate(RETAIL1-(RETAIL1 * DiscountRate)), "999,999,999.00")
So, say we plug some numbers in there:
Retail Value: $82 dollars
Discount Rate: 5.25% off
NumberFormat(Evaluate(82-(82 * 0.0525)), "999,999,999.00")
T
Figured it out.
Thanks anyway!!
-Original Message-
From: Declan Maher
Sent: 24 September 2002 14:40
To: CF-Talk
Subject: Rounding numbers in coldfusion
I am using a float datatype in the database and calculating some numbers
on the page.
The calculation seems to round up the numbers
can you share with the rest of us who may be interested in your soliution?
-Original Message-
From: Declan Maher [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, September 24, 2002 9:42 AM
To: CF-Talk
Subject: RE: Rounding numbers in coldfusion
Figured it out.
Thanks anyway!!
-Original
After doing some calculations, I'm coming up with a number (for example)
143.129997919. I would like this to be displayed as 143.13. I have noticed
that there is a function called "round" and a few related functions but
these take away the two decimal places I do want to keep. Can anyone hel
I seem to have a dilema and I would hope that someone on this list could
help me. I need to round a number to the nearest nickel for instance 10.225
should go to 10.20 and so on. With the round function I can only round to
the nearest whole number. I have no idea what to do and would really
apprec
I'm going slightly crazy trying to figure out the best way to round a
decimal number up to the next whole number, like:
1.2 = 2
1.8 = 2
Don't want it to round 1.2 down to 1. Any suggestions?
Jack
__
This list and all House of
> I have been using the round() function. It rounds up or down to
> the nearest
> whole number only. Am I wrong on this? how can I round up decimal
> numbers. I
> need to round a number like 1.41 to 1.50. I'm doing a timecard application
> and I need to round to quarters .25 .50 .75 1.0 What would
try this:
RoundedValue = Round(10 * Value)/10
>>> [EMAIL PROTECTED] 11/16/00 09:17AM >>>
I thought this would be simple. How can round a long integer eg:
2.146752 to
the first decimal point?
Thanks,
Rick
On 11/16/00, Rick Lamb penned:
>I thought this would be simple. How can round a long integer eg: 2.146752 to
>the first decimal point?
That's not an integer. LOL
This is the way I do it:
= 2.1
Add another 0 for each decimal you want to round to:
= 2.15
= 2.147
--
Bud Schneehagen - T
You could use DecimalFormat(), which automatically rounds the number to 2
decimal places! :-)
- Original Message -
From: "Rick Lamb" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2000 11:17 AM
Subject: rounding to first
nTest,"_._")#
3: #NumberFormat(nLongTest,"_._")#
1: 5.68
2: 5.7
3: 555
-Original Message-
From: Rick Lamb [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 9:18 AM
To: CF-Talk
Subject: rounding to first decimal
I thought this would be simple. How
How would numberformat(var,'9.9') work for you?
Terry
- Original Message -
From: Rick Lamb <[EMAIL PROTECTED]>
To: CF-Talk <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2000 9:17 AM
Subject: rounding to first decimal
> I thought this would be sim
Look at the NumberFormat function; it allows you to specify a display mask.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 11:18 AM
To: CF-Talk
Subject: rounding to first decimal
I thought this would be simple. How can round a
Multiply by 10
Round to integer
Divide by 10
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Friday, November 17, 2000 4:18 AM
To: CF-Talk
Subject: rounding to first decimal
I thought this would be simple. How can round a long integer eg: 2.146752 to
the
And this helps...err. ...how???
-Original Message-
From: Kevin Schmidt [mailto:[EMAIL PROTECTED]]
Subject: Re: rounding to first decimal
You could use DecimalFormat(), which automatically rounds the number to 2
decimal places! :-)
IMPORTANT NOTICE:
This e-mail and any attachment to it
t: Re: rounding to first decimal
On 11/16/00, Rick Lamb penned:
>I thought this would be simple. How can round a long integer eg: 2.146752
to
>the first decimal point?
That's not an integer. LOL
This is the way I do it:
= 2.1
Add another 0 for each decimal you want to round to:
=
The CF function you are looking for is
ceiling()
Joseph DeVore
VeloxWeb Technologies
-Original Message-
From: Benjamin Falloon [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 26, 2001 7:56 PM
To: CF-Talk
Subject: Rounding a value UP
Hi all,
Who knows the function for rounding UP
nal Message-
From: Benjamin Falloon [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 27 November 2001 1:56 PM
To: CF-Talk
Subject: Rounding a value UP
Hi all,
Who knows the function for rounding UP to the nearest number?
Eg. If I have the number 2.33 etc, what's the CF syntax for rounding
thi
thanks Jared and Joseph !
Exactly what I was after...
Benajamin
- Original Message -
From: "Jared Clinton" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 2001 4:11 PM
Subject: RE: Rounding a val
> The first line should read:
>
> I have the NumberFormat() func formatting a number with zeros. The
> result is one integer higher than the original integer.
I'm assuming its just a bug in Cf 4.5
Do you just need to pad put the string to a set number of characters? If so
then you might want to
-
From: "nb" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, November 16, 2000 4:06 PM
Subject: RE: rounding to first decimal
Without having to find the perfect rarely used mathematical function:
Multiply by 10, round, and divide by 10?
Without having to find the perfect rarely used mathematical function:
Multiply by 10, round, and divide by 10?
n
-Original Message-
From: Rick Lamb [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 16, 2000 12:18 PM
To: CF-Talk
Subject: rounding to first decimal
I thought this
A rounding UDF:
http://www.cflib.org/udf.cfm?ID=136
===
Raymond Camden, Principal Spectra Compliance Engineer for Macromedia
Email: [EMAIL PROTECTED]
Yahoo IM : morpheus
"My ally is the Force, and a powerful ally
on [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 22, 2001 3:17 PM
To: CF-Talk
Subject: Rounding to significant digits
I am running ColdFusion server 5.0 and when flipping through the docs I do
not see any Math functions to round to a particular number of significant
digits. Plus on Allaire
I needed such a function a week or so ago to round numbers that were originally
calculated to 10 or more decimal points (air emission statistics). I used Roundit.cfm
by Troy D. Ely that I got off Allaire's site. It worked great and saved the day.
Susan Hamilton Allen
Information Technology M
The other day I found an obscure bug in the way AbleCommerce sums pricing for
totals and subtotals. In my case, it exhibited itself when I discounted an ite
m
using a 10% discount. This caused products to have three decimal places in the
discounted price ($14.95 discounted 10% is $13.455). The
s. I
believe that this solution will not correct the error in the CC process and CCs
will get charged the incorrect price. Obviously, the best solution here is to
alter the process of adding items to the basket and make sure that the rounding
has been done correctly prior to being inserted/updat
look
like it already should:
>When converting from string to double, to prevent rounding errors, this
>function adds a rounding factor of 1.5543122344752E-014 to the converted
>number. For example, without adding the rounding factor, converting the
>string value 1.275 to doub
On Thu, 14 Oct 2004 13:36:56 -0700, Jordan Michaels
<[EMAIL PROTECTED]> wrote:
> How can I make NumberFormat() round UP instead of down? For example:
>
> So, say we plug some numbers in there:
>
>
> The actual result of 82-(82 * 0.0525) is 77.695, so I need that number
> to round up to 77.70. In
Chris Johnston wrote:
> On Thu, 14 Oct 2004 13:36:56 -0700, Jordan Michaels
> <[EMAIL PROTECTED]> wrote:
> > How can I make NumberFormat() round UP instead of down? For example:
> >
> > So, say we plug some numbers in there:
> >
> >
> > The actual result of 82-(82 * 0.0525) is 77.695, so I need th
and this should do the trick
tw
On Thu, 14 Oct 2004 14:53:11 -0700, Jordan Michaels
<[EMAIL PROTECTED]> wrote:
> Chris Johnston wrote:
>
> > On Thu, 14 Oct 2004 13:36:56 -0700, Jordan Michaels
> > <[EMAIL PROTECTED]> wrote:
> > > How can I make NumberFormat() round UP instead of down? For exa
Add 50 cents then truncate, or just use the Round() CF function.
or
- Original Message -
From: "Jordan Michaels" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, October 14, 2004 2:36 PM
Subject: Rounding up dollar figure
r
>
>
>
> - Original Message -
> From: "Jordan Michaels" <[EMAIL PROTECTED]>
> To: "CF-Talk" <[EMAIL PROTECTED]>
> Sent: Thursday, October 14, 2004 2:36 PM
> Subject: Rounding up dollar figures
>
> > How can I make NumberFo
At 04:11 PM 8/30/2000 -0500, Kim Ahlbrandt wrote:
>After doing some calculations, I'm coming up with a number (for example)
>143.129997919. I would like this to be displayed as 143.13. I have noticed
>that there is a function called "round" and a few related functions but
>these take away the
Multiply by 20
Round
Divide by 20
Best of luck,
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork
-Original Message-
From: Chris Straight [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 1:33 AM
To: [EMAIL PROTECTED]
Subject: Rounding to the nearest nickel?
I
Actually $10.225 to the nearest nickel is $10.25 ;-)
See ya,
Lee (Bjork) Borkman
http://bjork.net ColdFusion Tags by Bjork
-Original Message-
From: Chris Straight [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 1:33 AM
To: [EMAIL PROTECTED]
Subject: Rounding to the nearest
> I seem to have a dilema and I would hope that someone on this
> list could
> help me. I need to round a number to the nearest nickel for
> instance 10.225
> should go to 10.20 and so on. With the round function I can
> only round to
> the nearest whole number. I have no idea what to do and wo
At 06:53 PM 8/30/2000 -0500, [EMAIL PROTECTED] wrote:
> > I seem to have a dilema and I would hope that someone on this
> > list could
> > help me. I need to round a number to the nearest nickel for
> > instance 10.225
> > should go to 10.20 and so on. With the round function I can
> > only r
This would round to the nearest penny. It should b
--K
-Original Message-
From: !jeff! [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 30, 2000 5:22 PM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Rounding to the nearest nickel?
At 06:53 PM 8/30/2000 -0500, [EMAIL
Sorry, that would round to the nearest cent. Close but no banana.
-Original Message-
From: !jeff! [mailto:[EMAIL PROTECTED]]
Sent: Thursday, August 31, 2000 10:22 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: Rounding to the nearest nickel?
At 06:53 PM 8/30/2000 -0500
D]; [EMAIL PROTECTED]
>Subject: RE: Rounding to the nearest nickel?
>
>
>
>
>
>
>
>At 06:53 PM 8/30/2000 -0500, [EMAIL PROTECTED] wrote:
> > > I seem to have a dilema and I would hope that someone on this
> > > list could
> > > help me. I need
try numberformat(mynumber","999.99") which will round properly based on
"standard" rounding rules.
DC
- Original Message -
From: "Kim Ahlbrandt" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, August 30, 2000 21:11
Subject:
From: Kim Ahlbrandt [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 30, 2000 5:12 PM
To: [EMAIL PROTECTED]
Subject: Rounding to two decimal places
After doing some calculations, I'm coming up with a number (for example)
143.129997919. I would like this to be displayed as 143.13. I ha
I've used that in the past. However, sometimes the imprecision of IEEE floating
point numbers expressing base 10 stuffs it all up, i.e. for some numbers:
round(a.bcde*100)/100=a.b(c-1)9
David Cummins
"!jeff!" wrote:
>
>
>
> At 04:11 PM 8/30/2000 -0500, Kim Ahlbrandt wrote:
> >After d
; <[EMAIL PROTECTED]>
Sent: Tuesday, August 13, 2002 3:05 PM
Subject: Rounding up to whole number
> I'm going slightly crazy trying to figure out the best way to round a
> decimal number up to the next whole number, like:
>
> 1.2 = 2
> 1.8 = 2
>
> Don
> I'm going slightly crazy trying to figure out the best way to round a
> decimal number up to the next whole number, like:
> 1.2 = 2
> 1.8 = 2
> Don't want it to round 1.2 down to 1. Any suggestions?
#Ceiling(mynumber)#
Isaac Dealey
Certified Advanced ColdFusion Developer
www.turnkey.to
954
Moving on from where I left off the other day, I would now like to be able to round the following output to zero decimal places.
Here's my query
=
SELECT *
FROM results
WHERE team_name IS NOT NULL
ORDER BY total_score DESC
And the resulting
int() ?
Mark Henderson wrote:
>Moving on from where I left off the other day, I would now like to be able to round the following output to zero decimal places.
>
>Here's my query
>=
>
> SELECT *
> FROM results
> WHERE team_name IS NOT NULL
> ORDER
hi Charlie,
int() might work. But then I thought round would too. I'm just not sure how to build it into the resulting output query.
regards
Mark
[Todays Threads]
[This Message]
[Subscription]
[Fast Unsubscribe]
[User Settings]
[Donations and Support]
ct: RE: Rounding number format to 0 decimal places
To: CF-Talk <[EMAIL PROTECTED]>
hi Charlie,
int() might work. But then I thought round would too. I'm just not
sure how to build it into the resulting output query.
regards
Mark
[Todays Threads
rds
Mark Henderson
Web Designer
mailto:[EMAIL PROTECTED]
205 Main Street
PO Box 143, Gore
Southland 9700
Phone: (03) 203
Fax: (03) 203 9900
-Original Message-
From: Joe Rinehart [mailto:[EMAIL PROTECTED]
Sent: Friday, August 06, 2004 1:35 PM
To: CF-Talk
Subject: Re: Rounding number
: Mark Henderson [mailto:[EMAIL PROTECTED]
> Sent: 06 August 2004 00:24
> To: CF-Talk
> Subject: Rounding number format to 0 decimal places
>
> Moving on from where I left off the other day, I would now like to be
able
> to round the following output to zero de
place numbers like 1.15 when I tell it to round
to two significant figures it rounds down to 1.1 while if I put 1.16 it will round to
1.2. In the cases that I tested where the rounding left only whole numbers I did not
see the problem
91 matches
Mail list logo
