高校问答尤果王莹宝石项链视频:ASP+ACCESS有个小问题
来源：百度文库 编辑：高校问答 时间：2024/04/28 13:44:26
<table border=0 cellspacing=0 cellpadding=0 width='100%'>
<%
dim name,types
sql="select top 6 id,c_id,name,types from flea and types=求物where hidden=1 order by id desc"
set rs=joekoe_cms.exec(sql,1)
do while not rs.eof
id=rs("id")
name=rs("name")
types=rs("types")
response.write vbcrlf&" <tr><td height='20'> ["&joekoe_cms.code_html(types,1,0)&"] <a href='flea_view.asp?id="&id&"' target=_blank alt='"&joekoe_cms.code_html(name,1,0)&"'>"&joekoe_cms.code_html(name,1,17)&"</a></td></tr>"
rs.movenext
loop
rs.close
%>
</table>
不知道哪出现错误，高手直接
<%
dim name,types
sql="select top 6 id,c_id,name,types from flea and types=求物where hidden=1 order by id desc"
set rs=joekoe_cms.exec(sql,1)
do while not rs.eof
id=rs("id")
name=rs("name")
types=rs("types")
response.write vbcrlf&" <tr><td height='20'> ["&joekoe_cms.code_html(types,1,0)&"] <a href='flea_view.asp?id="&id&"' target=_blank alt='"&joekoe_cms.code_html(name,1,0)&"'>"&joekoe_cms.code_html(name,1,17)&"</a></td></tr>"
rs.movenext
loop
rs.close
%>
</table>
不知道哪出现错误，高手直接
sql="select top 6 id,c_id,name,types from flea and types=求物where hidden=1 order by id desc"
你写的“from flea and types=求物”这是什么？有你这样的写法么，我想请问一下？sql="select top 6 id,c_id,name,types from flea where hidden=1 and types=‘求物’ order by id desc" 用这个试试
sql语句，where前要有空格