do a Fix(cprlookup.cpr_rating). this will drop any decimal values. Chris Olive DOHRS Website Administrator [EMAIL PROTECTED] -----Original Message----- From: Jacob [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 12, 2000 2: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.
