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
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 should be easy:
<cfif total LT 0>
<cfset total = total * -1>
</cfif>
Why the heck doesn't the conversion or the test work??? Is it that the data
type is decimal instead of numeric?? Am I missing something stupid...
Thanks... Jeff.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Logware (www.logware.us): a new and convenient web-based time tracking
application. Start tracking and documenting hours spent on a project or with a
client with Logware today. Try it for free with a 15 day trial account.
http://www.houseoffusion.com/banners/view.cfm?bannerid=67
Message: http://www.houseoffusion.com/lists.cfm/link=i:4:195971
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
