I've got a oracle db query that returns a recordset with an amount column
which can sometimes be a negative value. I then have a QofQ to extract a
portion of data that uses SUM(amount)...It appears to be ignoring the fact
that some amounts are negative and it's giving me a total as if they're all
Nevermind! Was a user problem :-)
-Original Message-
From: Stacy Young [mailto:[EMAIL PROTECTED]]
Sent: Monday, September 30, 2002 12:58 PM
To: CF-Talk
Subject: QofQ and negative numbers
I've got a oracle db query that returns a recordset with an amount column
which can sometimes
Hi,
I cant figure out how to use numberformat to surround negative numbers with
brackets. Well, I can, but if I do, it appears that I also have to
incorporate the _ or the 9 for place settings, which I do not care for. Any
ideas? If there isn't one out there, I will try to roll my own.
Thanks
, July 31, 2002 9:40 AM
Subject: Another NumberFormat question - brackets for negative numbers
Hi,
I cant figure out how to use numberformat to surround negative numbers
with
brackets. Well, I can, but if I do, it appears that I also have to
incorporate the _ or the 9 for place settings, which I
Hi,
cfif var lte0
...CFML...
/cfif
-Brent
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 3:07 PM
To: CF-Talk
Subject: negative numbers
I want to check to see if this value is a 0 or a negative number. How would
I do
I want to check to see if this value is a 0 or a negative number. How would
I do this?
~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
FAQ:
cfset intFoo = -3
cfif isNumeric(intFoo) and intFoo lte 0
the value is 0 or a negative number
/cfif
-Tyson
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 5:07 PM
To: CF-Talk
Subject: negative numbers
I want to check to see
PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: negative numbers
Date: Fri, 31 Aug 2001 18:07:29 -0400
I want to check to see if this value is a 0 or a negative number. How
would
I do this?
~~
Structure your ColdFusion code with Fusebox. Get
= -3
cfif isNumeric(intFoo) and intFoo lte 0
the value is 0 or a negative number
/cfif
-Tyson
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 5:07 PM
To: CF-Talk
Subject: negative numbers
I want to check to see if this value is a 0
or, do a multiplication with a number like 5. if the result is 0, then
that number is a zero. if the result is a negative number, then that number
is negative.
Yes, but if you do the multiplication, then you still have the number to
check, it's just a different number. Doesn't that just add
-Talk [EMAIL PROTECTED]
Subject: negative numbers
Date: Fri, 31 Aug 2001 18:07:29 -0400
I want to check to see if this value is a 0 or a negative number. How
would
I do this?
~~
Structure your ColdFusion code with Fusebox. Get the official book
, then
that number is a zero. if the result is a negative number, then that number
is negative.
there's lots of ways :)
From: Joshua Tipton [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: CF-Talk [EMAIL PROTECTED]
Subject: negative numbers
Date: Fri, 31 Aug 2001 18:07:29 -0400
I want to check
isNumeric(intFoo) and intFoo lte 0
the value is 0 or a negative number
/cfif
-Tyson
-Original Message-
From: Joshua Tipton [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 31, 2001 5:07 PM
To: CF-Talk
Subject: negative numbers
I want to check to see if this value is a 0 or a negative
I have received your e-mail but will be out of the office 9/9/01. I will be checking
messages while away and will get back to you as soon as possible. If this is an
urgent request please contact Dan Tesenair.
Thank you,
Darren Houle
Sr. Web Developer
cf-talk 08/31/01 19:08
or, do a
14 matches
Mail list logo