Apparently the total being checked is query.total.. the
total being set is variables.total, and when specifying
"total" without being scoped the query.total takes precedent.
~|
Logware (www.logware.us): a new and conven
I don;t think it is the test, but the set. Is total a field in a cf query? You
can't change query column values using cfset, but need to use QuerySetCell. Or
scope your variables better.
Jerry Johnson
Web Developer
Dolan Media Company
>>> [EMAIL PROTECTED] 02/22/05 03:19PM >>>
ABS(total) work
ABS(total) works fine for adding the numbers... Still that doesn't explain
WHY I can't test for a negative number.
> -Original Message-
> From: Dave Francis [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, February 22, 2005 3:18 PM
> To: CF-Talk
> Subject: Re:
Abs(total) ??
- Original Message -
From: "Jeff Waris" <[EMAIL PROTECTED]>
To: "CF-Talk"
Sent: Tuesday, February 22, 2005 3:04 PM
Subject: SIMPLE number conversion PROBLEM
>I am using SQL Server 7 and have a "total" field that is a Data Type of
> DECIMAL. In SQL server 7 Decimal and
Have you tried abs(total) to get the absolute value?
-Original Message-
From: Jeff Waris [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 22, 2005 1:05 PM
To: CF-Talk
Subject: SIMPLE number conversion PROBLEM
I am using SQL Server 7 and have a "total" field that is a Data Type of
DE
5 matches
Mail list logo
