this is pulling from an old oracle database i don't have access to correct any problems with data type mismatches.
so looks like there may be alpha characters or other junk in a "gallons" numeric field that is displayed... what i want to do is if i cant do a calculation to a field do to a data type miss match. to show say a RED X instead of its normal number. this way the database admin can physically correct the problem, but the record set will still display the rest of the content.. so how would i check for mis match. <cfif isNumeric(gallons)> <cfset tgallons=tgallons+gallons> <CFELSE> <cfset tgallons="SetX"> </cfif> <cfif isNumeric(tgallons)><cfoutput>#NumberFormat(tgallons,"99999.99")#</cfoutput> <cfelse> <strong><font color="#FF0000">X</font></strong></font> </cfif> you help is much appreciated! thank you -paul ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. http://www.cfhosting.com Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
