人身保险风险案例:ASP高手帮个忙！答对马上即日送分

来源：百度文库编辑：查人人中国名人网时间：2024/04/28 22:12:38

我程序出现问题了，已知数据库有表JOB，里面包括xueli 和 qiye

以下是表单提交页INDEX.ASP
<html><head><title></title></head><body>
<form action="search_job.asp" method="POST">
<p align="center">
<select name="qiye" size="1" id="qiye">
<option value="huijingxincheng">汇景新城</option>
<option value="linhexi">林和西</option>
</select>
<select name="xueli" size="1" id="xueli">
<option value="dazhuan" selected>大专</option>
<option value="benke">本科</option>
</select>
职位名称：
<input name="duix" type="text" id="duix" size="13">
<input type="submit" value="搜索" name="submit"></p>
</form></body> </html>
=============================

以下是搜索页search_job.asp

<title>查询页面</title>
<%
dim conn
dim connstr,db
on error resume next
db="Database\tyqiye.mdb"
Set conn = Server.CreateObject("ADODB.Connection")
connstr="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(db)
conn.open connstr
%>
<%
dim sheet
sheet=""
qiye=request("qiye")
xueli=request("xueli")
duix=request("duix")
sheet= qiye+xueli
select case xueli
case "dazhuan"
gradename="大专 "
case "benke"
gradename="本科 "
end select

'取得qiye名称
select case qiye
case "linhexi"
teamname="林和西"
case "huijingxincheng"
teamname="汇景新城"
end select
sql="select job * from " & qiye & " where duix like '%" &duix& "%'"
sql=sql & " order by time "
set rs=conn.execute(sql)
if rs.eof then
response.write "查无此职位！<a href=test.asp>返回主页</a>"
response.end
end if
response.write "<br><center>查找<font color=brul> "&name&" </font>结果如下:<a href=test.asp>返回再查</a></center>"
response.write "<br><center>"
response.write qiye & "该企业 "
response.write xueli & "学历符合的职位有以下"
response.write "</center>"
response.write "<br>"
response.write "<table border=1 align=center>"
response.write "<tr>"
response.write "<td>招聘对象</td>"
response.write "<td>招聘人数</td>"
response.write "<td>工作地点</td>"
response.write "<td>工资待遇</td>"
response.write "<td>发布时间</td>"
response.write "<td>有效期限</td>"
response.write "<td>招聘要求</td>"
response.write "<td>学历要求</td>"
response.write "</tr>"
do while not rs.eof
response.write "<tr>"
response.write "<td>"&rs("duix")&"</td>"
response.write "<td>"&rs("rens")&"</td>"
response.write "<td>"&rs("did")&"</td>"
response.write "<td>"&rs("daiy")&"</td>"
response.write "<td>"&rs("time")&"</td>"
response.write "<td>"&rs("qix")&"</td>"
response.write "<td>"&rs("yaoq")&"</td>"
response.write "<td>"&rs("xueli")&"</td>"
%>
<%
response.write "</tr>"
rs.movenext
loop
response.write "</table>"
rs.close
set rs=nothing
conn.close
set conn=nothing
%>
＝
小弟跪求请问高手哪里出现问题了？？？？

查询页面

qiye=request("qiye")
xueli=request("xueli")
duix=request("duix")

错误
应该是

qiye=request.form("qiye")
xueli=request.form("xueli")
duix=request.form("duix")

其它暂时没看，如果还有报错，请发出报错信息

我觉得ASP最好的一点就是脚本错误的提示信息...哪行错了改哪行..就OK

麻烦各位同仁们提示些报错信息好不？
这样哪个去看啊
还上上面那位朋友的，其实那不是什么错嘛

ASP高手帮个忙！答对马上即日送分 asp懂的来，小弟麻烦问高手1个小问题！答对马上送分！帮忙推荐一个免费ASP的OA系统！答得好马上即日_送_分 pcanywhere 问题！！答对马上送分！高手进，答对送分初一文言文,答对马上给分@_@ sql+asp中谓词like查询问题高手进急答对追加分求救‘答对送分请问大家一个问题!很容易的!答对马上给分! 认字高手来！答对加5分~