语法错误 (操作符丢失) 在查询表达式 'id=' 中。/cpxxxx.asp, 第 10 行
<!--#include file="conn.asp" --><!--#include file="yzadmin/ips.asp"--> 导入的页面
<%
set rstts=server.createobject("adodb.recordset")
rstts.open "select * from product where id="&request.form("id"),conn,3,1 这就是第十行
%>
<title><%=rstts("sitetitle")%></title>
<meta name="keywords" content="<%=rstts("sitekeywords")%>" />
<meta name="description" content="<%=rstts("sitedes")%>" />
<link href="div.css" rel="stylesheet" type="text/css" />
<link href="css.css" rel="stylesheet" type="text/css" />
<table width="1000" border="0" cellspacing="0" cellpadding="0">
<tr>
<td valign="top"><div class="lefttop"><div class="leftfont"><a href="<%=ips%>zxdt.asp">最新动态</a></div>
</div><div class="leftmiddle"><div class="zxdtdiv">
<%
set rst=server.createobject("adodb.recordset")
sql="select top 10 * from dongtai where tuijian='是' order by id desc"
rst.open sql,conn,3,1
do while not rst.eof
response.write "<li><a href='"&ips&"zxdtarticle.asp?id="&rst("id")&"'>"&left(rst("title"),16)&"</a> </li>"
rst.movenext
if rst.eof then exit do
loop
rst.close
set rst=nothing
%>
</div></div><div class="leftbottom"></div>
<div class="lefttop">
<div class="leftfont"><a href="<%=ips%>cpdq.asp">产品大全</a></div>
</div>
<div class="leftmiddle"><div class="cpxxdiv">
<%
set rst=server.createobject("adodb.recordset")
sql="select top 15 * from cpdq where tuijian='是' order by id desc"
rst.open sql,conn,3,1
do while not rst.eof
response.write "<li><a href='"&ips&"cpdqarticle.asp?id="&rst("id")&"'>"&left(rst("title"),18)&"</a> </li>"
rst.movenext
if rst.eof then exit do
loop
rst.close
set rst=nothing
%> </div></div><div class="leftbottom"></div>
<div class="lefttop"><div class="leftfont"><a href="<%=ips%>tlzs.asp">涂料知识</a></div>
</div><div class="leftmiddle"><div class="tlzsdiv">
<%
set rst=server.createobject("adodb.recordset")
sql="select top 15 * from tlzs where tuijian='是' order by id desc"
rst.open sql,conn,3,1
do while not rst.eof
response.write "<li><a href='"&ips&"tlzsarticle.asp?id="&rst("id")&"'>"&left(rst("title"),18)&"</a> </li>"
rst.movenext
if rst.eof then exit do
loop
rst.close
set rst=nothing
%>
</div></div><div class="leftbottom"></div></td>
<td valign="top"><div style="padding:9px;">位置：<a href="<%=ips%>index.asp">公司首页</a> >> <a href="<%=ips%>cpxx.asp">产品信息</a> >> <%=rstts("name")%></div>
<div class="cp1"><div class="middletopfont1"><a href="<%=ips%>cpxx.asp">防腐涂料展示</a></div></div><div
class="cp2"> <h1><%=rstts("name")%></h1>
<%=rstts("content")%>
<%
rstts.close
set rstts=nothing
set rst=server.CreateObject("adodb.recordset")
rst.open "select top 1 * from product where id > "&request("id")&" order by id asc",conn,3,1
if rst.eof and rst.bof then
cp1="暂无上一产品"
else
cp1="上一产品： <a href='"&ips&"cpxxxx.asp?id="&rst("id")&"'>"&left(rst("name"),20)&"…</a>"
end if
rst.close
set rst=nothing
set rst=server.CreateObject("adodb.recordset")
sql="select top 1 * from product where id < "&request("id")&" order by id desc"
rst.open sql,conn,3,1
if rst.eof and rst.bof then
cp2="暂无下一产品"
else
cp2="下一产品： <a href='"&ips&"cpxxxx.asp?id="&rst("id")&"'>"&left(rst("name"),20)&"…</a>"
end if
rst.close
set rst=nothing
%> <table width="100%" border="0" cellpadding="5" cellspacing="1">
<tr>
<td width="50%" ><%=cp1%></td>
<td width="50%" ><%=cp2%></td>
</tr>
</table>
</div><div class="cp3"></div></td>
</tr>
</table>
</td>
</tr>
