2.8w+
社区成员
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>
...全文
当前发帖距今超过3年，不再开放新的回复
发表回复
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
那里有错误解释
基于java的企业人事管理系统设计--软件工程课程设计（含源码与论文设计）.rar 1 引言 4
1.1 课程设计目标 4
1.2 编程工具（编程环境）介绍 4
1.3 实施时间及主要实施步骤 4
2 需求分析 5
3 系统总体设计 6
4 数据库设计 6
5 主要功能模块的设计与实现 10
5.1 功能模块1详细设计（综合查询员工信息）..........................................................10
5.1.1 详细设计.......................................................................................................10
5.1.2 算法流程........................................................................................................15
5.1.3 界面设计及测试结果.....................................................................................15
6 调试分析 15
7 用户手册 16
8 测试结果 17
8.1 员工信息的添加...................................................................................................17
8.2 员工信息的修改...................................................................................................17
8.3 员工信息的删除...................................................................................................18
8.4 员工信息的综合查询...........................................................................................18
8.5 员工信息按性别统计的结果................................................................................19
8.6 员工信息按状态统计的结果...............................................................................19
8.7 员工信息按职称统计的结果................................................................................20
9 结论 20
10 参考文献 20
