我加加了以下这段,可是也现在出现(Microsoft VBScript 编译器错误 错误 '800a03f6'
缺少 'End'
/iisHelp/common/500-100.asp,行242
Microsoft VBScript 运行时错误 错误 '800a0009'
下标越界: '[number: 0]'
/abl/main.asp,行222
)不知道是什么原因,朋友帮忙看看
<%sqlstr="dbq="+server.mappath("data/info.mdb")+";driver=microsoft access driver (*.mdb);"
set conn=server.createobject("adodb.connection")
conn.open sqlstr
sql="select * from product order by id desc"
set rs=conn.execute(sql)
i=0
response.write "<table width='100%' border='0' height='450' cellspacing='6' >"
do while not rs.eof and i<8
response.write "<tr>"
for j=1 to 2
Dim picarray,pic
pic=rs("picname")
picarray = Split(pic,"|",-1)
if rs("picname")<>"" then
response.write "<td><table width='100%' border='0' cellspacing='0' cellpadding='0' ><tr><td width='79' height='85' rowspan='4' background='images/nj2.jpg'><div align='center'><a href='cp/show.asp?cpname="&rs("cpname")&"' target='_blank'><IMG height=73 alt="&rs("cpname")&" src='images/bj.jpg' width=69 align=middle border='0'></a></div></td><td > <font color='#3399FF'>产品类型:"&rs("fenlei")&"</font></td></tr><tr><td> <font color='#CCcccc'>产品名称:"&left(rs("cpname"),8)&"</font></td></tr><tr><td><div align='left'> <a href='cp/show.asp?cpname="&rs("cpname")&"' target='_blank'><IMG height=16 alt=详细信息 src=images/ck.jpg width=54 border='0'></a> <a href='dj/default.asp?cpname="&rs("cpname")&"' target='_blank'><IMG height=16 alt=订购 src=images/d.jpg width=19 border='0' ></a></div></td></tr></table></td>"
else
response.write "<td><table width='100%' border='0' cellspacing='0' cellpadding='0' ><tr><td width='79' height='85' rowspan='4' background='images/nj2.jpg'><div align='center'><a href='cp/show.asp?cpname="&rs("cpname")&"' target='_blank'><IMG height=73 alt="&rs("cpname")&" src='soft/"&picarray(0)&"' width=69 align=middle border='0'></a></div></td><td > <font color='#3399FF'>产品类型:"&rs("fenlei")&"</font></td></tr><tr><td> <font color='#CCcccc'>产品名称:"&left(rs("cpname"),8)&"</font></td></tr><tr><td><div align='left'> <a href='cp/show.asp?cpname="&rs("cpname")&"' target='_blank'><IMG height=16 alt=详细信息 src=images/ck.jpg width=54 border='0'></a> <a href='dj/default.asp?cpname="&rs("cpname")&"' target='_blank'><IMG height=16 alt=订购 src=images/d.jpg width=19 border='0' ></a></div></td></tr></table></td>"
end if
i=i+1
rs.movenext
if rs.eof then
exit for
end if
next
response.write "</tr>"
loop
response.write "</table>"
rs.close
conn.close
%>
相关文件:
点这儿打开