ASP留言板

来源:百度知道 编辑:UC知道 时间:2024/05/13 07:06:17
我有个ASP留言板我写好了数据库文件就是存不了数据,请问数据处理页面怎么写啊,
size=30 name=title> </LABEL></TD></TR>
<TR>
<TD class=graya14 height=30>
<DIV align=center>地址:</DIV></TD>
<TD>   <INPUT class=form1 id=address size=40
name=address></TD></TR>
<TR>
<TD class=graya14 height=30>
<DIV align=center>姓名:</DIV></TD>
<TD>   <INPUT class=form1 id=name size=10
name=name></TD></TR>
<TR>
<TD class=graya14 height=30>
<DIV align=center>单位:</DIV></TD>
<TD>   <INPUT class=form1 id=company size=40

<%
if request.form("action")="save" then
sql="select * from message_object"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,2
rs.addnew
rs("Mo_object")=trim(request.form("Moobject"))
rs("Mo_name")=trim(request.form("Moname"))
rs("Mo_sex")=trim(request.form("Mosex"))
rs("Mo_tel")=trim(request.form("Motel"))
rs("Mo_email")=trim(request.form("Moemail"))
rs("Mo_qq")=trim(request.form("Moqq"))
rs("Mo_http")=trim(request.form("Mohttp"))
rs("Mo_content")=trim(request.form("Mocontent"))
rs("Mo_adddate")=now
rs.update
rs.close
set rs=nothing
response.write "<script>alert('您的留言成功,请确定!');document.location.href='?';</script>"