数据进不了数据库?

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") 

这里也要""

Published At
Categories with Web编程
Tagged with
comments powered by Disqus