formatnumber函数返回错误 [英] formatnumber function returns error
问题描述
以下使用formatnumber函数的代码返回以下
代码。为什么?谢谢。
< td align =" right"><字体
class = content4><%= formatNumber(ars.Fields(" SOLD_AM OUNT) ;),2)%>< / td>
Microsoft VBScript运行时错误''800a000d''
类型不匹配:' 'formatNumber''
***通过开发人员指南 http:// www。 developersdex.com ***
不要只是参加USENET ......获得奖励!
The following code with formatnumber function returns me the following
code. Why? Thanks.
<td align="right"><Font
class=content4><%=formatNumber(ars.Fields("SOLD_AM OUNT"),2)%></td>
Microsoft VBScript runtime error ''800a000d''
Type mismatch: ''formatNumber''
*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!
推荐答案
你确定SOLD_AMOUNT是一个数字而不是空吗?
-
Aaron Bertrand
SQL服务器MVP
http://www.aspfaq.com/
" eddie wang" < EW *** @ kmg.com>写在留言中
新闻:uw ************** @ TK2MSFTNGP11.phx.gbl ...
Are you sure SOLD_AMOUNT is a number and it not null?
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"eddie wang" <ew***@kmg.com> wrote in message
news:uw**************@TK2MSFTNGP11.phx.gbl...
以下带格式编号的代码函数返回以下
代码。为什么?谢谢。
< td align =" right">< Font
class = content4><%= formatNumber(ars.Fields(" SOLD_AM OUNT)),2)%> < / td>
Microsoft VBScript运行时错误''800a000d''
类型不匹配:''formatNumber''
***已发送通过开发人员指南 http://www.developersdex.com ***
Don'只是参加USENET ...获得奖励!
The following code with formatnumber function returns me the following
code. Why? Thanks.
<td align="right"><Font
class=content4><%=formatNumber(ars.Fields("SOLD_AM OUNT"),2)%></td>
Microsoft VBScript runtime error ''800a000d''
Type mismatch: ''formatNumber''
*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!
eddie wang于2004年2月11日在microsoft.public.inetserver.asp.general上写道:
eddie wang wrote on 11 feb 2004 in microsoft.public.inetserver.asp.general:
<%= formatNumber(ars.Fields(" SOLD_AMOUNT"),2)%>
Microsoft VBScript运行时错误''800a000d' '
类型不匹配:''formatNumber''
<%=formatNumber(ars.Fields("SOLD_AMOUNT"),2)%>
Microsoft VBScript runtime error ''800a000d''
Type mismatch: ''formatNumber''
确保ars.Fields(" SOLD_AMOUNT")始终为数字
-
Evertjan。
荷兰。
(请将x''更改为我的电子邮件地址中的点数)
Make sure ars.Fields("SOLD_AMOUNT") is always a number
--
Evertjan.
The Netherlands.
(Please change the x''es to dots in my emailaddress)
有空值。无论如何都使用formatnumber和其他
函数来说如果有null则不使用formatnumber,否则使用
formatnumber ??
谢谢。
***通过开发人员指南发送http://www.developersdex.com ***
不要只是参加USENET ......获得奖励!
There is null value. IS there anyway to use formatnumber and other
functions to say if there is null then not to use formatnumber, else use
formatnumber??
Thanks.
*** Sent via Developersdex http://www.developersdex.com ***
Don''t just participate in USENET...get rewarded for it!
这篇关于formatnumber函数返回错误的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!