divide tx by 100 before using, rather than trying that trick with the
decimal point. (this will also work better for the value of 4, which in
your example would evaluate to .40 rather than .04.
Jerry Milo Johnson
On Thu, Feb 10, 2011 at 9:14 AM, Rick Sanders c...@webenergy.ca wrote:
Hey all,
This is a tax rate, so I need to get the tax on the subtotal.
cfset tax = #subtot# * .#tx#
Have you tried CFSET tax = subtot * tx /100 ?
~|
Order the Adobe Coldfusion Anthology now!
why not do #myquery.taxrate/100#?
On Thu, Feb 10, 2011 at 8:14 AM, Rick Sanders c...@webenergy.ca wrote:
Hey all,
I'm pulling up an integer from the database which is 15.
This is a tax rate, so I need to get the tax on the subtotal. Say the
#subtot# is 100 and #tx# is 15.
cfset tax
You need to do this:
cfset tax = subtot * (tx / 100) /
This actually converts the tx to a decimal.
Also you don't need the #s in the cfset. :)
Steve
-Original Message-
From: Rick Sanders [mailto:c...@webenergy.ca]
Sent: Thursday, February 10, 2011 9:14 AM
To: cf-talk
Subject:
Thank you. this worked great. I didn't realize you had to convert it to a
decimal in cf.
-Original Message-
From: DURETTE, STEVEN J (ATTASIAIT) [mailto:sd1...@att.com]
Sent: Thursday, February 10, 2011 10:24 AM
To: cf-talk
Subject: RE: decimals and variables
You need to do
Does this mean you are in Nova Scotia?
On Thu, Feb 10, 2011 at 9:14 AM, Rick Sanders c...@webenergy.ca wrote:
Hey all,
I'm pulling up an integer from the database which is 15.
This is a tax rate, so I need to get the tax on the subtotal. Say the
#subtot# is 100 and #tx# is 15.
Yup, I certainly am! Paying the highest taxes in North America! lol!
-Original Message-
From: Michael Grant [mailto:mgr...@modus.bz]
Sent: Thursday, February 10, 2011 10:33 AM
To: cf-talk
Subject: Re: decimals and variables
Does this mean you are in Nova Scotia?
On Thu, Feb 10, 2011
: Michael Grant [mailto:mgr...@modus.bz]
Sent: Thursday, February 10, 2011 10:33 AM
To: cf-talk
Subject: Re: decimals and variables
Does this mean you are in Nova Scotia?
On Thu, Feb 10, 2011 at 9:14 AM, Rick Sanders c...@webenergy.ca wrote:
Hey all,
I'm pulling up an integer from
: Michael Grant [mailto:mgr...@modus.bz]
Sent: Thursday, February 10, 2011 10:33 AM
To: cf-talk
Subject: Re: decimals and variables
Does this mean you are in Nova Scotia?
On Thu, Feb 10, 2011 at 9:14 AM, Rick Sanders c...@webenergy.ca wrote:
Hey all,
I'm pulling up an integer from
Cool. I'm in London. Was working in K-W for a while, but back in the forest
city.
I've always wanted to visit NS but it just never seems to happen. It looks
beautiful.
~|
Order the Adobe Coldfusion Anthology now!
10 matches
Mail list logo