在Asp中用SQL语句向Access中添加记录怎么不行啊!向高手请教
<%@ LANGUAGE="VBScript" %><html>
<head></head>
<!--#include file="Conn.asp"-->
<Link href="Css.css" rel=stylesheet>
<body>
<center>
<%
Dim stids, datas, coid, mark, note, i
stids = Split(Request("stids"), ";")
datas = Split(Request("datas"), ";")
coid = Request("coid")
i = 0
For Each stid In stids
mark = Left(datas(i),3)
note = mid(datas(i),4)
mysql = "INSERT INTO Sreport (stid, coid , mark, note)VALUES('stid,'coid','mark','note')"
objConn.Execute (mysql)
i = i + 1
Next
Response.Write("本次操作成功添加了【" & i & "】条成绩记录!")
objConn.Close
Set objConn = nothing
%>
</center>
</body>
</html> --------------------编程问答-------------------- 你总的说说是哪一行报错吧 --------------------编程问答-------------------- 谢谢,好的。
是这样的,
错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] INSERT INTO 语句的语法错误。
/as/UpdateAdd.asp, 第 18 行
--------------------编程问答-------------------- stid和coid 如果是整型的话,应该这样写的
"INSERT INTO Sreport (stid, coid , mark, note)VALUES("&stid&","&coid&",'"&mark&"','"¬e&"')" --------------------编程问答-------------------- mysql = "INSERT INTO Sreport (stid, coid , mark, note)VALUES('stid,'coid','mark','note')"
stid 后面少了个单引号 --------------------编程问答-------------------- 文本型不能这样写吗? --------------------编程问答-------------------- 添上单引号后
结果又变成这样的了,咋回事啊?
错误类型:
Provider (0x80004005)
未指定的错误
/as/Conn.asp, 第 6 行
其中Conn.asp的代码为:
<%
StrConnect = "Driver={Microsoft Access Driver (*.mdb)}; DBQ=E:\kcsj\02\data\cj.mdb"
'Set objConn = Server.CreateObject ("ADODB.Connection")
'objConn.OpenStrConnect
Set objConn = Server.CreateObject ("ADODB.Connection")
objConn.Open "gl"
%>
我是新手,还请大家多多帮忙啊!非常感谢!!!
补充:.NET技术 , ASP.NET