Trim it... Might be white space.
...................... Ben Nadel Certified Advanced ColdFusion MX7 Developer www.bennadel.com Need ColdFusion Help? www.bennadel.com/ask-ben/ -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 5:13 PM To: CF-Talk Subject: RE: What is wrong with this? It coming back as a numeric value... Rick -----Original Message----- From: Ashish Gohri [mailto:[EMAIL PROTECTED] Sent: Monday, March 12, 2007 4:50 PM To: CF-Talk Subject: Re: What is wrong with this? Something like this works - <cfset a = NumberFormat("1234567","9999")> So problem is with the first arguement - Get_Property_Details.Sale_Price Check if its a valid number, use IsNumeric to check that. Also check for NULL value. Thanks, Ashish Gohri ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:272418 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
