Active Server Pages, ASP 0126 (0x80004005) --> 找不到包含文件
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21) --> sql语句出错(数据类型不匹配或表名(字段名)错误或表处于编辑状态,或表不存在于conn打开的数据库中)
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) --> sql语句出错(字段名错误,或数据类型不匹配)
Microsoft OLE DB Provider for ODBC Drivers (0x80040E07) --> sql语句出错(要插入或更新的字段的类型与变量数据类型不匹配)
Microsoft OLE DB Provider for ODBC Drivers (0x80040E57) --> sql语句出错(要插入或更新的数据溢出)
Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) --> sql语句出错(update字段名或要更新的数据类型错误)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) --> sql语句出错(要插入或更新的字段的数值不能为空值)
Microsoft OLE DB Provider for ODBC Drivers (0x80004005) --> 打开数据库出错,没有在指定目录发现数据库
Microsoft OLE DB Provider for ODBC Drivers (0x80040E37) --> 没有发现表
Microsoft VBScript 运行时错误 (0x800A000D) --> 错误引用rs变量(rs对像已关闭或未定义)
Microsoft VBScript 运行时错误 (0x800A01C2) --> vbscript脚本错误(vbscript语句出错)
Microsoft VBScript 运行时错误 (0x800A0006) --> vbscript脚本错误(溢出错误)
Microsoft VBScript 编译器错误 (0x800A040E) --> 缺少loop
Microsoft VBScript 编译器错误 (0x800A03EA) --> 缺少if或end if
Microsoft VBScript 编译器错误 (0x800A03EE) --> 语句未结束(缺少")")
Microsoft VBScript 编译器错误 (0x800A03F6) --> if语句出错(缺少end if)
Microsoft VBScript 运行时错误 (0x800A005B) --> 缺少set
Microsoft VBScript 运行时错误 (0x800A0005) --> 变量未定义
Microsoft VBScript 编译器错误 (0x800A03F9) --> if语句缺少then
Microsoft VBScript 编译器错误 (0x800A0411) --> dim语句定义错误
Microsoft VBScript 编译器错误 (0x800A0408) --> sql语句错误(?????????????????)
错误类型:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
/hyoem/marcketinfo.asp, 第 79 行
use KeHu
go
Create Table [Markets]
( [商品][Nvarchar](50) not null,
[企业][Nvarchar](20)not null,
[报价][Nvarchar](50)not null,
[对手][Nvarchar] (10)not null,
[市场行情][Nvarchar](100)not null
)
go
字段名没错误,你看数据类型匹配吧。还有the command contained one or more errors.
浏览器类型:
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0; .NET CLR 1.1.4322)
页:
GET /hyoem/marcketinfo.asp
-----------------------------------------------------------
----------------------------------------------------------------
<%
if session("user")="" and session("pass")="" then
response.write "你不是管理员,请返回重新登陆!!! <br><br>"
response.write "<a href='adminlogin.asp'>返回</a>"
response.end
end if
%>
<html>
dim edit,id
edit=trim(request("action"))
id=cstr(request("id"))
'删除记录
if edit = "delete" then
sql = "DELETE FROM [Markets] WHERE id=" + id
conn.execute sql
if err.number <> 0 then
response.write "数据库操作错误:" + err.description
err.clear
end if
end if
'保存记录
if edit = "editsave" then
sql = "UPDATE [Markets] SET "
<div align="center"><center>
<%set rs=server.createobject("adodb.recordset")
if edit="search" then
sql="select * from [Markets] where 商品 like '%"+trim(request("search"))+"%'"
else
sql="select * from [Markets] order by id desc "
end if
rs.open sql,conn,3,3
if rs.eof and rs.bof then
response.write "没有记录"
else
%>
<table border="1" cellspacing="0" width="536" bordercolorlight="#000000"
bordercolordark="#FFFFFF" cellpadding="0" align="center">
<tr>
<td width="12%" align="center" bgcolor="#FEEC85">
<strong>商品</strong>
</td>
<td width="19%" align="center" bgcolor="#FEEC85">
<strong>企 业</strong></td>
<td width="20%" align="center" bgcolor="#FEEC85">
<strong><b>报 价</b></strong></td>
<td width="14%" align="center" bgcolor="#FEEC85" height="20">
<b>对 手</b>
</td>
<td width="15%" align="center" bgcolor="#FEEC85">
<b>市场行情</b>
</td>
<td width="20%" align="center" bgcolor="#FEEC85">
<b>编 辑</b>
</td>
</tr>
<%
dim curpage, i
if request("page")="" then
curpage = 1
else
curpage = cint(request("page"))
end if
rs.pagesize = 12
rs.absolutepage = curpage
for i = 1 to rs.pagesize
%>
<tr>
<td bgcolor="#FFFCD9" height="17" width="12%">
<p align="center" bgcolor="#E8E8E8">
<%=rs("商品")%>
</td>
<td bgcolor="#FFFCD9" height="17" width="19%">
<p align="center"><%=rs("企业")%>
</td>
<td bgcolor="#FFFCD9" height="17" width="20%">
<p align="center"><%=rs("报价")%>
</td>
<td bgcolor="#FFFCD9" height="17" width="14%">
<p align="center"><%=rs("对手")%></td>
<td bgcolor="#FFFCD9" width="15%"><div align="center">
<%=rs("市场行情")%></div></td>
<td bgcolor="#FFFCD9" height="17" width="20%">
<p align="center">
<a href="marcketinfo.asp?action=edit&id=<%=rs("ID")%>&page=<%=curpage%>">编辑</a>
</td>
</tr>
<%rs.movenext
if rs.eof then
i = i + 1
exit for
end if
next
%>
</table>
</center></div>
错误类型:
Microsoft OLE DB Provider for SQL Server (0x80040E14)
/hyoem/marcketinfo.asp, 第 79 行
问题为:
rs.open sql,conn,3,3我试过改为
rs.open sql,conn,2,4