28,409
社区成员
发帖
与我相关
我的任务
分享IE说 Cnn.Execute StrSQL 有错,请指教
各位老大,我是初学ASP,写了一段代码后IE老说我有错,以下为代码,望各位指教谢谢!!!
错误类型：
Microsoft VBScript 运行时错误 (0x800A01C2)
<%
Option Explicit
Response.Expires = 0
Dim Cnn, StrCnn
Set Cnn = Server.CreateObject("ADODB.Connection")
StrCnn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:\Inetpub\home\asp\Northwind.mdb"
Cnn.Open StrCnn
Dim StrSQL, rsTest
StrSQL = "DELETE FROM aa WHERE no = '111'"
Cnn.Execute StrSQL (IE 老是说这行有错,请指教)
%>
<HTML>
<BODY>
<%
Set rsTest = Cnn.Execute("Select * From aa")
Do While Not rsTest.EOF
Response.Write rsTest(0) & " " & rsTest(1) & " " & rsTest(2) & " " & "<BR>"
rsTest.MoveNext
Loop
Cnn.close
Set rsTest = Nothing: Set Cnn = Nothing
%>
</BODY>
</HTML>
错误类型：
Microsoft VBScript 运行时错误 (0x800A01C2)
<%
Option Explicit
Response.Expires = 0
Dim Cnn, StrCnn
Set Cnn = Server.CreateObject("ADODB.Connection")
StrCnn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:\Inetpub\home\asp\Northwind.mdb"
Cnn.Open StrCnn
Dim StrSQL, rsTest
StrSQL = "DELETE FROM aa WHERE no = '111'"
Cnn.Execute StrSQL (IE 老是说这行有错,请指教)
%>
<HTML>
<BODY>
<%
Set rsTest = Cnn.Execute("Select * From aa")
Do While Not rsTest.EOF
Response.Write rsTest(0) & " " & rsTest(1) & " " & rsTest(2) & " " & "<BR>"
rsTest.MoveNext
Loop
Cnn.close
Set rsTest = Nothing: Set Cnn = Nothing
%>
</BODY>
</HTML>
...全文
请发表友善的回复…
发表回复
Jazzlover 2001-07-24
- 打赏
- 举报
就用 delete aa where no = 111
ttt2 2001-07-20
- 打赏
- 举报
delete from aa where no=111
111是不是数据型的
111是不是数据型的
jackyliu 2001-07-20
- 打赏
- 举报
数据库是已经打开的,我显示数据库内容都可以但就是删除不行.
acheng 2001-07-20
- 打赏
- 举报
检查一下：
StrCnn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:\Inetpub\home\asp\Northwind.mdb"
StrCnn = "Provider = Microsoft.Jet.OLEDB.4.0; Data Source = C:\Inetpub\home\asp\Northwind.mdb"
jackyliu 2001-07-20
- 打赏
- 举报
各位老大救救我
jackyliu 2001-07-20
- 打赏
- 举报
我的NO字段是文本格式的
biggo 2001-07-20
- 打赏
- 举报
StrSQL = "DELETE FROM aa WHERE no = '111'可能错了，
你的no是否是数字字段，如果是那么就不用单引号括住111
你的no是否是数字字段，如果是那么就不用单引号括住111
l_walker 2001-07-20
- 打赏
- 举报
参数个数错误或无效的属性
去看看我的帖子，
http://www.csdn.net/expert/topic/190/190662.shtm
那里有错误解释
去看看我的帖子，
http://www.csdn.net/expert/topic/190/190662.shtm
那里有错误解释
