[此贴子已经被作者于2007-9-21 11:44:07编辑过]
下面这段代码为什么总不执行跳转到 <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>