大家慧眼给找找错误！

[zhusuhao]

<%
sql1="select * from vwnotingroup where loginid="&session("userid")&" order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open sql1,conn,1,1
if not rs.eof then
i=0
do while not rs.eof
i=i+1
%>
<table width="100%" border="1" align="center" cellspacing="0" bordercolordark="#ffffff" bordercolorlight="<%response.Write(session("tablecolor"))%>">
<tr <%if (i mod 2)=0 then%>bgColor="<%response.Write(session("tablecolor1"))%>" onmouseover="javascript:Mover(this)" onmouseout="Mout2(this)"<%else%>bgColor="#ffffff"<%end if%> onmouseover="javascript:Mover(this)" onmouseout="Mout1(this)" class="unnamed1" >

<td width="24%"><%=rs("friendname")%></td>
<td width="23%"><%=rs("handset")%> </td>
<td width="30%"><%=rs("email")%> </td>
<td width="15%"><%=rs("telhome")%> </td>

<td width="8%">
<div align="center"> <%
response.write "<a href='groupedit.asp?userbookid="&rs("id")&"&id="&id&"&method=delup'><img src='../images/arrow2.gif' border=0 alt='添加' onclick='if(confirm("您确定要加入本通讯组吗？")==false)return false;'></a>"
%>
</div></td>
</tr>
</table>

<%
rs.movenext
loop

else
response.write("还没有用户纪录")
end if

%>


以上是那段程序，如果
<%
sql1="select * from vwnotingroup where loginid="&session("userid")&" order by id desc"
set rs=server.createobject("adodb.recordset")
rs.open sql1,conn,1,1
%>是没有错误的
sql语句没有问题啊，能查处结果

vwnotingroup：
SELECT [id], [LoginID], [Friendname], [Handset], [TelHome], [TelCompany], [Address], [AddCompany], [Email], [Birth], [Fax], [QQCode], [Notes], [GroupName], [GroupID]
FROM vwaddress
WHERE (id NOT IN (SELECT id FROM vwaddress WHERE GroupID <>0));