28,391
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
ShiningstarHu 2004-01-10
- 打赏
- 举报
在lx.asp中这样写：
<%
fieldNames = Split(request.Form("hobby"),",")
strSQL = "Select "
for each fieldName in fieldNames
strSQL = strSQL & fieldName & ","
next
strSQL = left(strSQL,Len(strSQL)-1)
strSQL = strSQL & " From yourTable"
set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSQL,conn,3,1
do while not rs.eof
for i =1 to UBound(fieldNames)
response.write rs(i) "<BR>"
next
rs.movenext
loop
rs.close
%>
<%
fieldNames = Split(request.Form("hobby"),",")
strSQL = "Select "
for each fieldName in fieldNames
strSQL = strSQL & fieldName & ","
next
strSQL = left(strSQL,Len(strSQL)-1)
strSQL = strSQL & " From yourTable"
set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSQL,conn,3,1
do while not rs.eof
for i =1 to UBound(fieldNames)
response.write rs(i) "<BR>"
next
rs.movenext
loop
rs.close
%>
lovelymiss 2004-01-10
- 打赏
- 举报
我不是这个意思
是这样的，我有一个表customer,共三个列：id,password,class
然后做了一个<select multiple>，其中option的value分别对应的是id,password,class
然后我想根据用户选中的option来显示customer表具体显示哪几列
如果用户选择了id和password，则customer表就显示id和password这两列
<form name="form1" method="post" action="lx.asp">
<p>
<select name="hobby" size="3" multiple>
<option value="id">id</option>
<option value="password">password</option>
<option value="class">class</option>
</select>
</p>
<p><input type="submit" value="现实结果" name="B1">
<input type="reset" value="重新选择" name="B2">
</p>
</form>
是这样的，我有一个表customer,共三个列：id,password,class
然后做了一个<select multiple>，其中option的value分别对应的是id,password,class
然后我想根据用户选中的option来显示customer表具体显示哪几列
如果用户选择了id和password，则customer表就显示id和password这两列
<form name="form1" method="post" action="lx.asp">
<p>
<select name="hobby" size="3" multiple>
<option value="id">id</option>
<option value="password">password</option>
<option value="class">class</option>
</select>
</p>
<p><input type="submit" value="现实结果" name="B1">
<input type="reset" value="重新选择" name="B2">
</p>
</form>
yyhyy23 2004-01-10
- 打赏
- 举报
<select name="ab">
<%do while not rst.eof%>
<option value=<%=rst("value")%>>rst("value")</option>
<%rst.movenext
loop
%>
</select>
<%do while not rst.eof%>
<option value=<%=rst("value")%>>rst("value")</option>
<%rst.movenext
loop
%>
</select>
