<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<%
'****************************ACCESS**********************************
dbpath=server.mappath("../data/article###.mdb")
connstr= "provider=microsoft.jet.oledb.4.0;data source=" & dbpath
set conn=server.createobject("adodb.connection")
conn.open connstr
'*********************************************************************
%>
<%
'获取表单中信息
dim texttitle,fabu,select1,textnr
texttitle=request.form("texttitle")
fabu=request.form("fabu")
select1=request.form("select1")
textnr=request.form("textnr")
%>
<%
dim rs,sql
set rs=server.CreateObject("adodb.recordset")
sql="select * from article"
rs.open sql,conn,1,1
%>
<%
'insert into
sqll="insert into article(text-title,author,text-fl,text-nr,adddate) values('"&texttitle&"','"&fabu&"','"&select1&"','"&textnr&"','"&now()&"')"
conn.execute(sqll)
response.Redirect("../article.asp")
%>
都成功就sqll:
技术信息(用于支持人员)
- 错误类型:
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/at168/admin/admin_article_fab.asp, 第 28 行
- 浏览器类型:
Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; Trident/4.0; 360SE) - 网页:
POST 9474 ??? /at168/admin/admin_article_fab.asp - POST Data:
texttitle=%D7%D4%C9%ED&fabu=%D7%D4%C9%ED&select1=1&textnr=%CA%C7%D7%D4%C9%ED%B5%C4%CA%C7%D7%D4%C9%ED%B5%C4%CA%C7%D7%D4%C9%ED%B5%C4%CA%C7%D7%D4%C9%ED%B5%C4%CA%C7%D7%D4%C9%ED%B5%C4%CA%C7%D7%D4%C9%ED%B5% . . . - 时间:
2009年10月21日, 13:14:23
高手帮着看下