我的那塔莎电视剧全剧:ASP程序求助

来源:百度文库 编辑:杭州交通信息网 时间:2024/04/29 03:30:05
<TABLE class=mb4 cellSpacing=1 cellPadding=0 width=770 align=center border=0>
<TBODY>
<TR>

<FORM name="search" action="search.asp" method="post">
<TD height=20 align="center" valign=middle>
请选择分类:
<select name="trade">
<%set sql=nothing
sql="select trade from trade"
call opensql(conn,rs,sql,1,1)
set i=nothing
for i= 1 to Rs.recordcount
response.write "<option>"&rs("trade")&"</option>"
rs.movenext
next
call closers(rs)
%>
</select>
请输入要查询的关键字:
<INPUT
name=content class=logininput id="content" size=20>
<INPUT style="HEIGHT: 20px" type=submit value=搜索 name=loginsubmit>
 <A class=gray
href="register.asp"></A></TD>
</FORM>
</TR>
</TBODY>
</TABLE>
-------------------------------
<!--#include file="conn.asp"-->
<!--#include file="fuction.asp"-->
<%
b_title=trim(request("content"))
'response.write b_title
b_trade=trim(request("trade"))
'response.write b_trade
sql="SELECT [news].[b_title], [news].[b_content], [news].[b_picture], [news].[b_site], [news].[b_date], [trade].[trade] FROM trade INNER JOIN news ON [trade].[ID]=[news].[b_trade] WHERE [news].[b_content] like '*"&b_title&"*' or [news].[b_title] like '*"&b_title&"*' and [trade].[trade]='"&b_trade&"'"
response.write sql'测试sql
call opensql(conn,rs,sql,1,1)
if rs.eof then
response.write "<font color=red>没有找到相关信息</font>"
else
dim i
set i=nothing
for i=0 to rs.recordcount-1
response.write rs("b_title")
response.write "<br>"
rs.movenext
next
call closers(rs)
end if%>

为什么查不出来记录,我把测试出来的sql在access中可以查出来

like 不能用 * 号 改用 % 号试试
比如 [news].[b_content] like '%"&b_title&"%'....