分不多,不知道有高手解答没有.
为什么有的时候用RS.CLOSE不出错.有的时候只要一用到就出错.这个东西还要有什么限制么.高手帮忙.
比如说下边这个里边为什么就不可以.
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="check_job_login.asp"-->
<!--#include file="../db/date.asp"-->
<%
id=request("id")
job_name=request("job_name")
job_write=replace(replace(request("job_write"),chr(13),"<br>"),chr(10)," ")
job_request=replace(replace(request("job_request"),chr(13),"<br>"),chr(10)," ")
job_start_date=request("job_start_date")
job_end_date=request("job_end_date")
set rs=server.CreateObject("adodb.recordset")
if id="" or job_name="" or job_write="" or job_request="" or job_start_date="" or job_end_date="" then
response.write "<script lanaguage=javascript>" & "alert('资料不完整,无法提交!请通过合法表单提交。');"&"window.location.href = 'job_manager.asp'"&"</script>"
else
sql="update job set job_name='"&job_name&"',job_write='"&job_write&"',job_request='"&job_request&"',job_start_date='"&job_start_date&"',job_end_date='"&job_end_date&"',job_date='"&date()&"' where id="&id
rs.open sql,conn,1,1
rs.close '就是这一行.
set rs=nothing
response.write "<script lanaguage=javascript>" & "alert('修改成功!');"&"window.location.href = 'job_manager.asp'"&"</script>"
end if
%>