帮忙解决问题~~
sel1.asp---------
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK REL=StyleSheet HREF="../../site.css" TYPE="text/css">
<title>无标题文档</title>
<script language="JavaScript" src="../../JS/js_win.js"></script>
</head>
<body background="../../images/bg2.gif"><div align="center">
<div align="center">
<p><em><font color="#125B6D" size="5"><u>查询</u></font></em>
<%dim sou
dim num
sou=request.Form("sel")%>
<%
set conn = server.createobject("adodb.connection")
cnor="driver={sql server};server=wgg;uid=sa;pwd=swgzs;database=ccdams"
conn.open cnor
set rs=server.createobject("adodb.Recordset")
rs.Source="表管理"'表或sql语句‘若写成sql语句形式,无法判数据源
rs.ActiveConnection=conn
rs.CursorType=1
rs.LockType=3
rs.open%>
<%
i=1
do until rs.eof
if cint(sou)=i then
truesel=1
sou1=rs("tablename")
Session("columnnum")=i
num=i%>
<% end if
i=i+1
rs.movenext
loop
rs.movefirst()
%>
<%if truesel=1 then
rs.close
set rs = server.createobject("adodb.Recordset")'创建Recordset对象
rs.Source=sou1'表或sql语句‘若写成sql语句形式,无法判数据源
session("mysourse")=sou1%>
<%rs.ActiveConnection=conn
rs.CursorType=1
rs.LockType=3
rs.open
set conn = server.createobject("adodb.connection")
cnor="driver={sql server};server=wgg;uid=sa;pwd=swgzs;database=ccdams"
conn.open cnor
set chinars=server.createobject("adodb.Recordset")
chinars.ActiveConnection=conn
chinars.CursorType=1
chinars.LockType=3
chinars.Source="表字段"
chinars.open
end if%>
<%j=1%>
<%Session("passsel1")=1%>
<%if truesel<>1 then%>
</p>
<p> </p>
</div>
<form action="sel1.asp" method="post">
<%j=0%>
<div align="center">请选择您要查询的表格名称:
<select name="sel">
<!-- 若选取了表,则从 3 开始-->
<option value=<%=(i)%>></option>
<%do until rs.eof
j=j+1%>
<option value=<%=j%>><%=rs("chinaname")%></option>
<!-- 第零个字段开始,故一个字段的只零-->
<%=rs("chinaname")%>
<%rs.movenext
loop
%>
</select>
<input name="" type="submit" value="确 定"></P>
</div>
</form>
<div align="center">
<%end if%>
</div>
<form action="sel2.asp" method="post">
<%if rs.source<>"表管理" then%>
<p align="center"> </p>
<p align="center"> 请选择您要查询的条件项:</p>
<p align="center">
<select name="mutisel" size="5" multiple>
<%for each obj in rs.fields%>
<option value="<%=obj.name%>"><%=chinars(num-1)%></option>
<%chinars.movenext%>
<%next%>
</select>
</p>
<p align="center">
<input name="" type="submit" value="确 定">
<input name="" type="button" value="返 回" onClick="location.href='sel1.asp'">
</form>
<%end if%>
<script language="JavaScript" src="../../JS/Calendar.js"></script>
</body>
</html>
这是第一个页面。