asp调用控制符问题

来源:百度知道 编辑:UC知道 时间:2024/05/30 18:06:39
<%
set rs=server.createobject("ADODB.Recordset")
sql="select * from P_info where p_other = 0 "
classType = request("classType")
smallclass = request("smallclass")
key = request("key")
if classType <> "" then
sql = sql & " and p_type = '"&classType&"'"
end if
if smallclass <> "" then
sql = sql & " and p_small_type = '"&smallclass&"'"
end if
if key <> "" then
sql = sql & " and p_name like '%"&key&"%'"
end if

sql = sql & " order by p_id desc"
rs.open sql,conn,1,1

if not isempty(request("page")) then
pagecount=cint(request("page"))
else
pagecount=1
end if

%>
<%
rs.close
s

不知道你要的是什么。
这些也许对你有用
<!--#include file="inc/top.asp"-->
<% dim about
about=saferequest("about",1)
%>
<table width="1003" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="100" valign="top" bgcolor="#000000"></td>
<td width="179" valign="top" class="table-z"><table width="179" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="40" colspan="2"></td>
</tr>
<tr>
<td height="40" colspan="2" align="center">关于我们</td>
</tr>
<tr>
<td colspan="2" height="3"><hr color="#000000&quo