That is because 8.5 automatically rounds up to 9. Try and set your variable
to itself - .5
-----Original Message-----
From: Jacob [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 12, 2000 12:03 PM
To: [EMAIL PROTECTED]
Subject: Number comparing
When I run this:
<cfif trim(cprlookup.cpr_rating) gte "7" and trim(cprlookup.cpr_rating) lt
"9">
<cfset cpr_ribbon = "red2ndshad.gif">
<cfelseif trim(cprlookup.cpr_rating) gte "9">
<cfset cpr_ribbon = "blue1stshad.gif">
</cfif>
I keep getting blue1stshad.gif for 8.5.
If the number is an 8, it gives it red2ndshad.gif. If the number is an 9,
it gives it blue1stshad.gif.
The column for the SQL server is as follows:
Column Name Datatype Length Precision Scale
CPR_Rating decimal 9 18 0
Any suggestions?
Thank You
Jacob
----------------------------------------------------------------------------
--
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
