主题:怎么写不进数据?
<!--#include file="conn/dbconn.asp"-->
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from House"
rs.open sql,conn,1,3
rs.addnew
ID=Request.Form("ID")
rs("DistrictName")=trim(request.form("DistrictName"))
rs("AreaName")=trim(request.form("AreaName"))
rs("Address")=trim(request.form("Address"))
rs("RoomNo")=trim(request.form("RoomNo"))
rs("PropertyType")=trim(request.form("PropertyType"))
rs("Floor")=trim(request.form("Floor"))
rs("FloorAll")=trim(request.form("FloorAll"))
rs("PropertyOwn")=trim(request.form("PropertyOwn"))
rs("PropertyDirection")=trim(request.form("PropertyDirection"))
rs("CountF")=trim(request.form("CountF"))
rs("CountT")=trim(request.form("CountT"))
rs("CountW")=trim(request.form("CountW"))
rs("CountY")=trim(request.form("CountY"))
rs("Square")=trim(request.form("Square"))
rs("Price")=trim(request.form("Price"))
rs("Note")=htmlencode2(request.form("Note"))
rs("ContactName")=trim(request.form("ContactName"))
rs("Tel")=trim(request.form("Tel"))
rs("ModDate")=date()
rs.update
rs.close
response.redirect "bookin.asp"
%>
sql的数据库.写入数据以后.只增加了ID.字段里面全是空的
<%
Set rs=Server.CreateObject("ADODB.Recordset")
sql="select * from House"
rs.open sql,conn,1,3
rs.addnew
ID=Request.Form("ID")
rs("DistrictName")=trim(request.form("DistrictName"))
rs("AreaName")=trim(request.form("AreaName"))
rs("Address")=trim(request.form("Address"))
rs("RoomNo")=trim(request.form("RoomNo"))
rs("PropertyType")=trim(request.form("PropertyType"))
rs("Floor")=trim(request.form("Floor"))
rs("FloorAll")=trim(request.form("FloorAll"))
rs("PropertyOwn")=trim(request.form("PropertyOwn"))
rs("PropertyDirection")=trim(request.form("PropertyDirection"))
rs("CountF")=trim(request.form("CountF"))
rs("CountT")=trim(request.form("CountT"))
rs("CountW")=trim(request.form("CountW"))
rs("CountY")=trim(request.form("CountY"))
rs("Square")=trim(request.form("Square"))
rs("Price")=trim(request.form("Price"))
rs("Note")=htmlencode2(request.form("Note"))
rs("ContactName")=trim(request.form("ContactName"))
rs("Tel")=trim(request.form("Tel"))
rs("ModDate")=date()
rs.update
rs.close
response.redirect "bookin.asp"
%>
sql的数据库.写入数据以后.只增加了ID.字段里面全是空的