UC知道access插入新记录问题
来源：百度知道 编辑：UC知道 时间：2024/06/05 02:13:19
哪位高手帮我看看错在哪儿
第一次:
<%
title=request.Form("textfield")
remen=cbool(request.Form("rm"))
tuijian=cbool(request.Form("tj"))
type1=request.Form("select")
type2=request.Form("select2")
laiyuan=request.Form("source")
zuozhe=request.Form("zuozhe")
shijian=now()
dianshu=cint(request.Form("textfield2"))
neirong=request.Form("textarea")
%>
<%
sql="insert into wenzhang(title,hot,tuijian,dalei,type,time,content,count,writer,source) values('"
&title&"',"&remen&","&tuijian&",'"&type1&"','"&type2&"','"shijian"','"&neirong&"',"&dianshu&",'"&zuozhe&"','"&laiyuan&"')"
conn.execute sql
conn.close
response.Write("插入记录成功！")
%>
第一次:
<%
title=request.Form("textfield")
remen=cbool(request.Form("rm"))
tuijian=cbool(request.Form("tj"))
type1=request.Form("select")
type2=request.Form("select2")
laiyuan=request.Form("source")
zuozhe=request.Form("zuozhe")
shijian=now()
dianshu=cint(request.Form("textfield2"))
neirong=request.Form("textarea")
%>
<%
sql="insert into wenzhang(title,hot,tuijian,dalei,type,time,content,count,writer,source) values('"
&title&"',"&remen&","&tuijian&",'"&type1&"','"&type2&"','"shijian"','"&neirong&"',"&dianshu&",'"&zuozhe&"','"&laiyuan&"')"
conn.execute sql
conn.close
response.Write("插入记录成功！")
%>
第一个可能是：
<%
sql="insert into wenzhang(title,hot,tuijian,dalei,type,time,content,count,writer,source) values('"
&title&"',"&remen&","&tuijian&",'"&type1&"','"&type2&"','#"shijian"#','"&neirong&"',"&dianshu&",'"&zuozhe&"','"&laiyuan&"')"
第二个是缺少set：
<%
set rs=server.CreateObject("adodb.recordset")
sql="select * from wenzhang"
rs.open sql,conn,1,3 '第25行
<%
set rs=server.CreateObject("adodb.recordset") '楼主看清了,少set
sql="select * from wenzhang"
rs.open sql,conn,1,3 '第25行
rs.addnew
...
%>