1@LANGUAGE="VBSCRIPT" CODEPAGE="936"
1
2if (request.form("title")="") or (request.form("content")="" ) or (request.form("type")="" )then
3response.write "
<div align="center">内容不能为空!</div>
1"
2response.write "
<div align="center">redirect.<a href="javascript:history.back(1)">返回</a></div>
1"
2end if
在前面的判断中可以知道数据已经传到了request.form中了,可是在下面的输入数据库中不能输入数据,总是输入的空值。
连接数据库
1
2set rs=server.createobject("adodb.recordset")
3rs.open"news",conn,1,3
4rs.addnew
5rs(title)=request.form("title")
6rs(content)=request.form("content")
7rs(datetime)=now()
8rs.update
9rs.close
10conn.close
1<html>
2<head>
3<meta content="text/html; charset=utf-8" http-equiv="Content-Type"/>
4<title>数据插入</title>
5<link href="inc/style.css" rel="stylesheet" type="text/css"/>
6</head>
7<body>
=request.Form(title)
1</body>
2</html>
---------------------------------------------------------------
rs.addnew
rs("title")=request.form("title")
rs("content")=request.form("content")
rs("datetime")=now()
rs.update
字段名要用""号括起来。
---------------------------------------------------------------
1. rs.addnew
rs("title")=request.form("title")
rs("content")=request.form("content")
rs("datetime")=now()
rs.update
2. ``` =request.Form("title")
1
2\---------------------------------------------------------------
3
4:```
5=request.Form("title")
这里也要""