无法绑定由多个部分组成的标识符

'获得用户自定义显示
Dim rsu As ADODB.Recordset
rsu = conn.Execute("select ListNum from UserDataNum where UserID=" & Session("UserID") & " and SysObjectID =" & ObjectID)
Dim ListNum
If rsu.EOF Or rsu.BOF Then

ListNum = 23
Else
ListNum = CInt(rsu("ListNum").Value)
End If
rsu.Close()

rs.Open(sql, conn, 1, 1)

Dim pageNo = Request("pageNo")

If pageNo = "" Then
pageNo = 1
Else
pageNo = CInt(pageNo)
End If 问题是在这里，但是我改的都不正确，望您指点下。

rsu = conn.Execute("select ListNum from UserDataNum where UserID=" & Session("UserID") & " and SysObjectID =" & ObjectID)
如果SysObjectID是字符串型的，需要加单引号：
rsu = conn.Execute("select ListNum from UserDataNum where UserID=" & Session("UserID") & " and SysObjectID ='" & ObjectID&"'")

你这个查询不对，应该这么写： insert into dbo.dict_basedetail select * from sdtecase1.dbo.dict_basedetail a , dbo.dict_basedetail b where a.detailid<>b.detailid and a.id=b.id 其中a.id=b.id是两表关联的字段，具体是什么我不知道，你自己改