Question

ADODB.Recordset '800a0bb9' 参数类型不正确，或不在可以接受的范围之内，或与其他参数冲突。 \banner.asp

banner.asp的代码如下
<table width="980" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top">
<table width="960" height="194" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>

<%
set rsshow=server.createobject("adodb.recordset")
sql="select * from newpic"
rsshow.open sql,conn,1,3
pic1=rsshow("pic1")
pic2=rsshow("pic2")
pic3=rsshow("pic3")
pic4=rsshow("pic4")
pic5=rsshow("pic5")
pic6=rsshow("pic6")
movie1=rsshow("movie1")
movie2=rsshow("movie2")
movie3=rsshow("movie3")
movie4=rsshow("movie4")
movie5=rsshow("movie5")
movie6=rsshow("movie6")
rsshow.close
set rsshow=nothing
%>

<SCRIPT type=text/javascript>
var img=new Array();
var txt=new Array();
var lnk=new Array();

img[0]='<%=pic1%>'
lnk[0]=escape('<%=movie1%>');
txt[0]='';

img[1]='<%=pic2%>'
lnk[1]=escape('<%=movie2%>');
txt[1]='';

img[2]='<%=pic3%>'
lnk[2]=escape('<%=movie3%>');
txt[2]='';

img[3]='<%=pic4%>'
lnk[3]=escape('<%=movie4%>');
txt[3]='';

img[4]='<%=pic5%>'
lnk[4]=escape('<%=movie5%>');
txt[4]='';

var focus_width=984;
var focus_height=249;
var text_height=0;

Answer 1

如果错误提示是你的第11行代码处有错误,应该是conn对象没有创建,看看你是不是忘了将数据库连接对象包含进来了.