错误 '80020009'
发生意外。
源代码：
<%
strSql = "select count(lovephoto.id) as counts from lovephoto,loveuser where loveuser.id = lovephoto.userid"
set rsphoto = cn.execute(strSql)
count = rsphoto("counts")
strSql = "select lovephoto.id as id,userid,audit from lovephoto,loveuser where lovephoto.userid = loveuser.id and lovephoto.audit = 1 order by id desc"
set rsphoto = cn.execute(strSql)
%>
|
<%
for i = 1 to counts
' userid = rsphoto("userid")
'报错行：
strSql = "select username,nickname from loveuser where id = " & rsphoto("userid")
set rsuser = cn.execute(strSql)
%>
<%
if i mod 4 = 0 then response.write ""
rsphoto.movenext
next
%>
编辑历史:[这消息被arhui编辑过(编辑时间2003-05-20 16:31:09)]
难人一个……
|
idd
职务：普通成员
等级：1
金币：0.0
发贴：53
|
#22003/5/20 17:25:28
& rsphoto("userid")
后面好像还应该有个&
写成& rsphoto("userid")&
|
天之剑
职务：普通成员
等级：1
金币：0.0
发贴：302
|
#32003/5/21 9:47:06
strSql = "select username,nickname from loveuser where id =' " & rsphoto("userid")&"' "
set rsuser = cn.execute(strSql)
我有时也遇到，不知道怎么id成字符型了，只好加上引号才能过，你试试
|
|
