主题:  求救!这个东西老是报错!

沉默是金

职务:普通成员
等级:6
金币:11.2
发贴:4357
注册:2004/2/18 11:17:25
#12003/5/20 16:25:21
错误 '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
    
%>
            
            
>

">" border="1" width="120" height="120">

" target="_blank"><%=rsuser("username") & "(" & rsuser("nickname") & ")"%>

编辑历史:[这消息被arhui编辑过(编辑时间2003-05-20 16:31:09)]

难人一个……

idd

职务:普通成员
等级:1
金币:0.0
发贴:53
注册:2003/3/18 13:56:48
#22003/5/20 17:25:28
& rsphoto("userid")
后面好像还应该有个&
写成& rsphoto("userid")&



天之剑

职务:普通成员
等级:1
金币:0.0
发贴:302
注册:2002/9/20 13:55:28
#32003/5/21 9:47:06
strSql = "select username,nickname from loveuser where id =' " & rsphoto("userid")&"' "
set rsuser = cn.execute(strSql)
我有时也遇到,不知道怎么id成字符型了,只好加上引号才能过,你试试


每页显示15条 1/1 << <1 >>