求助ADODB.Recordset 错误 '800a0bb9'

qq_41445869 2018-06-21 10:06:21

ADODB.Recordset 错误 '800a0bb9'

参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。

/aa/top.asp，行 23

<%@ CODEPAGE = "936" %>

<script>
function openbag(id) { window.open("basket.asp?
productid="+id,"","height=400,width=600,left=190,top=0,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no"):}
</script>
<script language="javascript">
function openscript(url, width, height){
var win=window.open(url,"openscript",'width=' + width + ',height=' + height + ',resizeable=1,scrollbars=yes,menubar=no,status=yes' );
}
</script><head>
<meta http-epuiv="content-type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="style2.css" type="text/css">
<title>欢迎您来本商城购物</title>
</head>
<%dim rs,sql
set rs=server.createobject("adodb.recordset")
sql="select * from sort"%>
<table width="780" bgcolor="#ffffff" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<table width="780" border="0" cellspacing="0" cellpadding="0" align="center" bgco

...全文

241 2 打赏收藏转发到动态举报

写回复

用AI写文章

2 条回复

切换为时间正序

请发表友善的回复…

发表回复

php_wsd 2018-06-22

打赏
举报

表名sort和sys需要加上中括号
改成[sort]和[sys]

qq_41445869 2018-06-21

打赏
举报

<%@ CODEPAGE = "936" %>

<script>
function openbag(id) { window.open("basket.asp?
productid="+id,"","height=400,width=600,left=190,top=0,resizable=yes,scrollbars=yes,status=no,toolbar=no,menubar=no,location=no"):}
</script>
<script language="javascript">
function openscript(url, width, height){
var win=window.open(url,"openscript",'width=' + width + ',height=' + height + ',resizeable=1,scrollbars=yes,menubar=no,status=yes' );
}
</script><head>
<meta http-epuiv="content-type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="style2.css" type="text/css">
<title>欢迎您来本商城购物</title>
</head>
<%dim rs,sql
set rs=server.createobject("adodb.recordset")
sql="select * from sort"%>
<table width="780" bgcolor="#ffffff" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<table width="780" border="0" cellspacing="0" cellpadding="0" align="center" bgcolor=<%sql="select * from sys"
rs.open sql,conn,3,3%>
<%=rs("sys_color")%>
<%rs.close