下面这段代码为什么总不执行跳转到 <a href="searchResult.asp?keywords=<%=rb("corpuser_info.username")%>"> <%=rb("corpuser_info.username")%></a> 这上一句请问如何改或
<table width="962" border="0" align="center" cellpadding="0" cellspacing="0" class="CONTENT" bgcolor="#FFFFFF">
<td width="960"></tr>
<tr>
<td height="24"><table width="778" border="0" cellspacing="0" cellpadding="0">
<tr>
<% set rb=server.createobject("adodb.recordset")
id=request("id")
sql="select * from corp_producttype,corpuser_info where corp_producttype.id='"&id&"' and corp_producttype.guanlian in(corpuser_info.jobFunction1,corpuser_info.jobFunction2,corpuser_info.jobFunction3)"
rb.open sql,conn,1,1
if rb.recordcount<>"" then
%>
<a href="searchResult.asp?keywords=<%=rb("corpuser_info.username")%>"> <%=rb("corpuser_info.username")%></a>
<%
id=request("id")
if len(id)=6 then%>
<%set rs = server.CreateObject("adodb.recordset")
sql = "SELECT * FROM corp_producttype where parent="&id&""
rs.open sql,conn,1,1
%>
<a href="searchResult.asp?keywords=<%=rb("corpuser_info.username")%>"> <%=rb("corpuser_info.username")%></a>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="6%"><img src="images/arrow01.gif" width="9" height="12" align="absmiddle"></td>
<td width="94%"><a href="searchResult.asp?keywords=<%=rb("corpuser_info.username")%>"> <%=rb("corpuser_info.username")%></a>
</table>
<%else%>
<%set rs = server.CreateObject("adodb.recordset")
sql = "SELECT * FROM corp_producttype where parent="&id&""
rs.open sql,conn,1,3
%><%if rb.recordcount<>"" then
%>
<% if len(id)=2 or len(id)=4 then%>
<a href="producttype_list.asp?id=<%=rs("id")%>" class="link4"><%=rs("corp_producttype")%><%=rb.recordcount%><%response.write("公司")%></a></td>
<% do while not rs.eof %>
<table width="100%" border="0" cellspacing="0" cellpadding="5">
<tr>
<td width="6%"><img src="images/arrow01.gif" width="9" height="12" align="absmiddle"></td>
<td width="94%">
<%rs.movenext%>
<%loop%>
<% else%>
<%
response.redirect "searchResult.asp?keywords="&rb("corpuser_info.username")
%>
<%end if%>
<%end if%>
<% end if%>
<% end if%> </tr>