<%dim conn,rs,typeid,sql,typename typeid=request("type1") if typeid="" then typeid=1 typeid=cint(typeid) set rs=conn.execute("select * from type1") do while not rs.eof %> <%if rs("id")=typeid then typename=rs("type1") rs.movenext loop rs.close %>