ASP调试错误,哪个问题?
斑马智库 2009-08-04 02:02:34 错误类型:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
ODBC 驱动程序不支持所需的属性。
/jidahousecom/房123/cn/111.asp, 第 44 行
代码如下:
<%
mymenu="show"
myurl="show.asp"
myname="新房展示"
classcode=61
keyno=Request.QueryString("keyno")
if keyno="" or not isnumeric(keyno) then keyno=0 end if
tem=Request.QueryString("tem")
if tem="" then tem=1 end if
select case tem
case 1 : keyname="基本信息"
case 2 : keyname="楼盘介绍"
case 3 : keyname="开发商简介"
case 4 : keyname="外景效果图"
case 5 : keyname="户型展示"
case 6 : keyname="物业管理"
end select
myurl2="show_info.asp?keyno="&keyno
sql="select * from subs where id="&keyno&" and pid=11 and usefulness=1"
rs.open sql,cn,1,1
if not rs.eof then
rstitle=rs("title")
rscontent=rs("content")
rscontent3=rs("content3")
rscontent4=rs("content4")
rscity=rs("city")
rswtype=rs("wtype")
rslocal=rs("local")
rscertcode=rs("certcode")
rswdate=rs("wdate")
rswprice=rs("wprice")
rstel=rs("tel")
rsaddress=rs("address")
rspid2=rs("pid2")
rspicflag=rs("picflag")
rspicflag2=rs("picflag2")
end if
rs.close
sql="select id,title,content from subs2 where id="&rspid2
rs.open sql,cn,1,1第44行
if not rs.eof then
rstitle2=rs("title")
rscontent2=rs("content")
end if
rs.close
%>
<td width="101"><table width="98" border="0" cellspacing="0" cellpadding="0">
<tr> <%
rstitle=">> 基本信息"
gif="2"
link="link5"
if tem=1 then
rstitle="<font color=ffffff>"&rstitle&"</font>"
gif="1"
link="link1"
end if%>
<td height="19" align="center" background="images/show/bg_title_<%=gif%>.gif"><a href="<%=myurl2%>&tem=1" class="<%=link%>"><%=rstitle%></a>
</td>
</tr>
</table></td>
<td width="101"><table width="98" border="0" cellspacing="0" cellpadding="0">
<tr> <%
rstitle=">> 楼盘介绍"
gif="2"
link="link5"
if tem=2 then
rstitle="<font color=ffffff>"&rstitle&"</font>"
gif="1"
link="link1"
end if%>
<td height="19" align="center" background="images/show/bg_title_<%=gif%>.gif"><a href="<%=myurl2%>&tem=2" class="<%=link%>"><%=rstitle%></a>
</td>
</tr>
</table></td>
<td width="101"><table width="98" border="0" cellspacing="0" cellpadding="0">
<tr> <%
rstitle=">> 开发商简介"
gif="2"
link="link5"
if tem=3 then
rstitle="<font color=ffffff>"&rstitle&"</font>"
gif="1"
link="link1"
end if%>
<td height="19" align="center" background="images/show/bg_title_<%=gif%>.gif"><a href="<%=myurl2%>&tem=3" class="<%=link%>"><%=rstitle%></a>
</td>
</tr>
</table></td>
<%if rspicflag2=1 then%>
<td width="101"><table width="98" border="0" cellspacing="0" cellpadding="0">
<tr> <%
rstitle=">> 外景效果图"
gif="2"
link="link5"
if tem=4 then
rstitle="<font color=ffffff>"&rstitle&"</font>"
gif="1"
link="link1"
end if%>
<td height="19" align="center" background="images/show/bg_title_<%=gif%>.gif"><a href="myasp_bigpic_display.asp?keyno=<%=keyno%>&code=2&tablename=subs" target=_blank class="<%=link%>"><%=rstitle%></a>
</td>
</tr>
</table></td>
<%end if%>
<td width="101"><table width="98" border="0" cellspacing="0" cellpadding="0">
<tr> <%
rstitle=">> 户型展示"
gif="2"
link="link5"
if tem=5 then
rstitle="<font color=ffffff>"&rstitle&"</font>"
gif="1"
link="link1"
end if%>
<td height="19" align="center" background="images/show/bg_title_<%=gif%>.gif"><a href="<%=myurl2%>&tem=5" class="<%=link%>"><%=rstitle%></a>
</td>
</tr>
</table></td>
<td width="101"><table width="98" border="0" cellspacing="0" cellpadding="0">
<tr> <%
rstitle=">> 物业管理"
gif="2"
link="link5"
if tem=6 then
rstitle="<font color=ffffff>"&rstitle&"</font>"
gif="1"
link="link1"
end if%>
<td height="19" align="center" background="images/show/bg_title_<%=gif%>.gif"><a href="<%=myurl2%>&tem=6" class="<%=link%>"><%=rstitle%></a>
</td>
</tr>
</table></td>
</tr>
</table>
</td>
</tr>
</table>