星际 喷漆:ASP的问题,高手求助

来源:百度文库 编辑:高考问答 时间:2024/05/10 06:28:33
<!--#include file="conn.asp" -->
<%
name=Trim(Request.Form("name"))
six=Trim(Request.Form("six"))
oicq=Trim(Request.Form("oicq"))
email=Trim(Request.Form("email"))
homepage=Trim(Request.Form("homepage"))
content=Replace(request.form("content"),vbcrlf,"<br>")

set re=server.createobject("adodb.recordset")
sql="select *from book where (id is unll)"
rs.open sql,conn,1,3

rs.addnew
rs("name")=name
rs("six")=six
rs("oicq")=oicq
rs("email")=email
rs("homepage")=homepage
rs("content")=content
rs.updata

rs.close
set rs=nothing
conn.close
set conn=nothing
%>

<html>
<meta http-equiv="refresh" content="2;URL=index.asp">
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
color: #999999;
}
-->
</style><table width="622" height="251" border="0">
<tr>
<td> 
<div align="center">
<p>留言成功..!</p>
<p>2秒后自动<a href="index.asp">返回首页</a>...</p>
</div></td>
</tr>
</table>
</html>

为什么,提示rs无效?
从rs.open sql,conn,1,3这里开始

set re=server.createobject("adodb.recordset")

你建立的是re,而不是后面打开的rs,把上面的re=改为rs=就行了!