> For those cases
> were the field can contain text, e.g., a "n/a" string, I tried to use
> the following:
> <cfif isNumeric("GPA")>#numberFormat(GPA, '9.
> 999')#<cfelse>#GPA#</cfif>
>
> Obviously, this always displays the CFELSE portion because the
> original field is not numeric.
>
As I was reading my own post, I realized I had double quotes enclosing the
variable name (i.e., "GPA") in the isNumeric() function. I deleted the quotes,
and now the number amount is displayed with the right format, and the format
part is ignored if the field contains text.
So, the problem was solved.
Thanks,
Roberto
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://ad.doubleclick.net/clk;56760587;14748456;a?http://www.adobe.com/products/coldfusion/flex2/?sdid=LVNU
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:265996
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
