INSERT INTO 语句的语法错误。
<%@LANGUAGE="VBSCRIPT"CODEPAGE="936"%><!--#includefile="myconn.asp"--><%IfRequest.Ser...
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="myconn.asp"-->
<%
If Request.ServerVariables("REQUEST_METHOD")="POST" Then
content=Replace(Replace(Request("content")," "," "),chr(13),"<br>")
conn.Execute("Insert Into article(title,content,nclassid,classid,time) values('"&Request("title")&"','"& content &"',"&Request("nclassid")&","&Request("classid")&","&Request("time")&")")
Response.Redirect "articlelist.asp"
Else
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="?">
<table width="60%" border="1" cellpadding="4" cellspacing="0">
<tr>
<td align="right">标题：</td>
<td align="left"><input name="title" type="text" id="title"></td>
</tr>
<tr>
<td align="right">nclassid：</td>
<td align="left"><input name="nclassid" type="text" id="nclassid"></td>
</tr>
<tr>
<td align="right">classid：</td>
<td align="left"><input name="classid" type="text" id="classid"></td>
</tr>
<tr>
<td align="right">时间：</td>
<td align="left"><input name="time" type="text" id="time">
（格式如：2011-1-1）</td>
</tr>
<tr>
<td align="right">内容：</td>
<td align="left"><textarea name="content" cols="45" rows="10" id="content"></textarea></td>
</tr>
<tr>
<td align="right"> </td>
<td align="left"><input type="submit" name="Submit" value="修改" />
<input type="reset" name="Submit2" value="重置" />
<input type="button" name="Submit3" value="返回" onclick="history.back()"></td>
</tr>
</table>
</form>
</body>
</html>
<%End If%>
错误类型：
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/lin/addarticle.asp, 第 6 行 展开
<!--#include file="myconn.asp"-->
<%
If Request.ServerVariables("REQUEST_METHOD")="POST" Then
content=Replace(Replace(Request("content")," "," "),chr(13),"<br>")
conn.Execute("Insert Into article(title,content,nclassid,classid,time) values('"&Request("title")&"','"& content &"',"&Request("nclassid")&","&Request("classid")&","&Request("time")&")")
Response.Redirect "articlelist.asp"
Else
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<form id="form1" name="form1" method="post" action="?">
<table width="60%" border="1" cellpadding="4" cellspacing="0">
<tr>
<td align="right">标题：</td>
<td align="left"><input name="title" type="text" id="title"></td>
</tr>
<tr>
<td align="right">nclassid：</td>
<td align="left"><input name="nclassid" type="text" id="nclassid"></td>
</tr>
<tr>
<td align="right">classid：</td>
<td align="left"><input name="classid" type="text" id="classid"></td>
</tr>
<tr>
<td align="right">时间：</td>
<td align="left"><input name="time" type="text" id="time">
（格式如：2011-1-1）</td>
</tr>
<tr>
<td align="right">内容：</td>
<td align="left"><textarea name="content" cols="45" rows="10" id="content"></textarea></td>
</tr>
<tr>
<td align="right"> </td>
<td align="left"><input type="submit" name="Submit" value="修改" />
<input type="reset" name="Submit2" value="重置" />
<input type="button" name="Submit3" value="返回" onclick="history.back()"></td>
</tr>
</table>
</form>
</body>
</html>
<%End If%>
错误类型：
Microsoft JET Database Engine (0x80040E14)
INSERT INTO 语句的语法错误。
/lin/addarticle.asp, 第 6 行 展开
1个回答
展开全部
conn.Execute("Insert Into article (title,content,nclassid,classid,time) values ('"&Request("title")&"','"& content &"',"&Request("nclassid")&","&Request("classid")&","&Request("time")&")
你最后多了一个")
你最后多了一个")
追问
没有多啊
追答
我看错了....， 的确没多.这个"&Request("time")&" 应该不是数字型吧，'"Request("time")&"'是不是应该这样
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
