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.
