<%
                      dim rs1
                      Set rs1 = Server.CreateObject("ADODB.Recordset")
                      int userid=rs("userid")
                      sql1="select username from users where userid=" & cstr(rs("userid"))
                      'response.write(sql1)
                      rs1.open sql1,conn,1,1
                      %>
                      <label><label><% =rs1("username")%></label></label>

   我想通过调用users表中的id 来显示 users表中 username项的信息 但是为什么行不通呢，还请大家帮忙一下 谢谢！！！
                     

int userid=rs("userid")
它后面那个rs是不是应该是rs1 啊

楼上说的对

<%
                      dim rs1
                      Set rs1 = Server.CreateObject("ADODB.Recordset")
                      userid=rs("userid")
                      sql1="select username from users where userid=" & userid
                      'response.write(sql1)
                      rs1.open sql1,conn,1,1
                      %>

真是太感谢大家了

rs("userid")从何而来