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
SIMPLE number conversion PROBLEM
>
>
> 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
>
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 Typ
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 Da
I am using SQL Server 7 and have a "total" field that is a Data Type of
DECIMAL. In SQL server 7 Decimal and Numeric data types are supposed to be
equal. I am having a heck of time testing for negatives.
For example... Say my field contains -41.00 and I want to test and convert
it to 41.00.
This
6 matches
Mail list logo
