28,391
社区成员
发帖
与我相关
我的任务
分享菜鸟求助
节选其中一段
<form method="post" action="tea.asp?xm=<%=xm%>&name1=<%=name1%>">
<select name="b_study" size="1" id="评选人数1">
<option value="4" selected>优</option>
<option value="3">良</option>
<option value="2">中</option>
<option value="1">差</option>
</select>
<select name="b_work" size="1" id="评选人数2">
<option value="4" selected>优</option>
<option value="3">良</option>
<option value="2">中</option>
<option value="1">差</option>
</select>
<select name="b__zj" size="1" id="评选人数3">
<option value="4" selected>优</option>
<option value="3">良</option>
<option value="2">中</option>
<option value="1">差</option>
</select>
请问怎样在tea里分别把各自不同的value值提取出来？
<form method="post" action="tea.asp?xm=<%=xm%>&name1=<%=name1%>">
<select name="b_study" size="1" id="评选人数1">
<option value="4" selected>优</option>
<option value="3">良</option>
<option value="2">中</option>
<option value="1">差</option>
</select>
<select name="b_work" size="1" id="评选人数2">
<option value="4" selected>优</option>
<option value="3">良</option>
<option value="2">中</option>
<option value="1">差</option>
</select>
<select name="b__zj" size="1" id="评选人数3">
<option value="4" selected>优</option>
<option value="3">良</option>
<option value="2">中</option>
<option value="1">差</option>
</select>
请问怎样在tea里分别把各自不同的value值提取出来？
...全文
请发表友善的回复…
发表回复
qq_38307847 2017-04-14
- 打赏
- 举报
<!-- #include file="conn.asp" -->
<%
Response.Buffer=True
xm=request.querystring("xm")
name1=session("name1")
sql1="select * from xxk "
rs.Open sql1,conn,1,1
i=rs("态度优评")
i1=rs("态度良评")
i2=rs("态度中评")
i3=rs("态度差评")
pingy1=rs("评语")
xs1=rs("已评学生")
i=i+1
i1=i1+1
i2=i2+1
i3=i3+1
rs.close
if i=1 then
pingy1=trim(request("s1"))
else
pingy1=pingy1&"|"&trim(request("s1"))
end if
xs1=name1&","&xs1
aver=b_tatol/i
sql="update xxk set 态度优评='"&i&"',态度良评='"&i1&"',态度中评='"&i2&"',态度差评='"&i3&"',评语='"&pingy1&"',已评学生='"&xs1&"' where 教师姓名='"&xm&"'"
rs.Open sql,conn,1,1
set rs=nothing
'response.end
response.write "<SCRIPT language=JavaScript>alert('谢谢你评阅');window.location.href='index2.asp';</script>"
%>
qq_38307847 2017-04-14
- 打赏
- 举报
我把两个表贴出来吧
<!-- #include file="conn.asp" -->
<%
xm=request("xm")
name1=session("name1")
sql1="select * from xxk where 教师姓名='"&xm&"'"
rs.Open sql1,conn,1,1
xs1=rs("已评学生")
z=instr(xs1,name1)
if z<>0 then
response.write "<SCRIPT language=JavaScript>alert('该老师已评');history.back(1);</script>"
response.end
else%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>教师考核评价表</title>
<link rel=stylesheet href="style.css" type="text/css">
<style type="text/css">
<!--
.style1 {font-size: 24px}
-->
</style>
</head>
<body topmargin="0">
<p align="center" class="style1">评价选项</p>
<div align="center">
<table border="0" width="700" cellspacing="0" cellpadding="0">
<tr>
<td width="100%">
<form method="post" action="teacher1.asp?xm=<%=xm%>&name1=<%=name1%>">
<table border="1" width="100%" bordercolorlight="#008080" cellspacing="3" cellpadding="3" bordercolordark="#FFFFFF">
<tr>
<td><font color="#FF0000">注意</font>：请认真对[<%=xm%>]老师打分和评语</td>
<center>
<td width="14%"> 项目分数 </td>
</tr>
<tr>
<td width="100%"><span style="mso-bidi-font-size: 13.5pt; font-family: 宋体; mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman; mso-bidi-font-family: Times New Roman; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">1.上课思路清晰，语言生动简练，表达流畅准确，不讲与教学无关的话。</span></td>
<td width="14%" align="center">
<select size="1" name="b_study">
<option value="4" selected>优</option>
<option value="3">良</option>
<option value="2">中</option>
<option value="1">差</option>
</select></td>
</tr>
<tr>
<td width="100%"><span style="mso-bidi-font-size: 13.5pt; font-family: 宋体; mso-ascii-font-family: Times New Roman; mso-hansi-font-family: Times New Roman; mso-bidi-font-family: Times New Roman; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA">2.学识渊博，专业功底扎实，能及时准确回答我们提出的问题。</span></td>
<td width="14%" align="center">
<select size="1" name="b_work">
<option value="4" selected>优</option>
<option value="3">良</option>
<option value="2">中</option>
<option value="1">差</option>
</select></td>
</tr>
<tr>
<td width="100%" colspan="2" align="left">我还有话说（不能超过100个字）：
<p>
<!--webbot bot="Validation" b-value-required="TRUE"
i-maximum-length="20"
s-validation-constraint="Less than or equal to"
s-validation-value="100" --><textarea rows="5" name="S1" cols="59"></textarea></p>
<p align="center"> <input type="submit" value="提交" name="B1"></p>
</td>
</tr>
</table>
<p> </p>
</form>
</td>
</tr>
</table>
</div>
</body>
</html>
<%
session("name1")=name1
end if
%>
Msxindl_Com 2017-04-14
- 打赏
- 举报
request.form("b_study")
request.form("b_work")
request.form("b__zj")
request.querystring("xm")
request.querystring("name1")
qq_38307847 2017-04-14
- 打赏
- 举报
我是想把表1里的选择写进数据库对应的字段里头
