是一个ASP的问题,急急

来源:百度知道 编辑:UC知道 时间:2024/05/26 20:03:46
Microsoft VBScript 运行时错误 错误 '800a000d'
类型不匹配

/bbsshow.asp,行 233

<%case"topmoney"
dim allmoney
i=0
set rs=conn.execute("select top 10 userid,name,money,grade,alltopicnum from [user] order by money desc,lasttime desc")

do while not rs.eof
i=i+1
if i>10 then exit do
allmoney=int(allmoney)+rs("money")//////这是223行
rs.movenext
loop
%>
如果改成这个代码:
<%case"topmoney"
dim allmoney :allmoney=0
i=0
set rs=conn.execute("select top 10 userid,name,money,grade,alltopicnum from [user] order by money desc,lasttime desc")

do while not rs.eof
i=i+1
if i>10 then exit do
allmoney=allmoney+cint(rs("money"))//////这是223行
rs.movenext
loop
%>
则提示:Microsoft VBScript 运行时错误 (0x800A000D)
类型不匹配
/dtmk/cs/ytf/bbss/bbsshow

<%case"topmoney"
dim allmoney :allmoney=0
i=0
set rs=conn.execute("select top 10 userid,name,money,grade,alltopicnum from [user] order by money desc,lasttime desc")

do while not rs.eof
i=i+1
if i>10 then exit do
allmoney=allmoney+cint(rs("money"))//////这是223行
rs.movenext
loop
%>

是不是缺少连接到vb的数据库啊,不太清楚