考虑分页的话，就这样写

<table align="center" border="1" cellpadding="0" cellspacing="0" bordercolorlight="#000000">
<tr bgcolor="#3399FF" align="center">
<td>编号</td>
<td>需求部门</td>
<td>需求人员</td>
<td>需求人电话</td>
<td>需求完成时间</td>
<td>故障标题</td>
<td>执行人</td>
<td>分配完成时间</td>
<td>执行状况</td>
<td>分配情况</td>
<td>详情</td>
</tr>
<%
dim rs,sql,nd_depart,years,months,days,times,do_type,nd_data
nd_depart=request("nd_depart")
years=request("years")
months=request("months")
days=request("days")
times=request("times")
do_type=request("do_type")

sql="where 1=1"
if nd_depart<>"" then
    sql=sql&" and nd_depart='"&nd_depart&"'"
end if

if do_type<>"" then
    sql=sql&" and do_type='"&do_type&"'"
end if

if years<>"" and months<>"" and days<>"" and times<>"" then
nd_data=years&"-"&months&"-"&days
select case times
case "制单时间" sql=sql&" and wrt_time='"&nd_data&"'"
case "需求完成时间" sql=sql&" and nd_data='"&nd_data&"'"
end select
end if

set rs=server.CreateObject("adodb.recordset")
rs.open "select * from [nd_msg] "&sql,conn,1,1
do while not rs.eof
rs.pagesize=10
page=cint(request("page"))
if page<=0 then page=1
if page="" then page=1
rs.absolutepage=page

for i=0 to rs.pagesize-1
if rs.eof or rs.bof then exit for
response.write "<tr>"
response.write "<td>"&rs("id")&"</td>"
response.write "<td>"&rs("nd_depart")&"</td>"
response.write "<td>"&left(rs("nd_name"),5)&"</td>"
response.write "<td>"&rs("nd_tel")&"</td>"
response.write "<td>"&rs("nd_data")&"</td>"
response.write "<td>"&left(rs("nd_title"),8)&"</td>"
response.write "<td>"&rs("do_man")&"</td>"
response.write "<td>"&rs("do_time")&"</td>"
if rs("do_type")=1 then
    response.write "<td>已完成</td>"
else
    response.write "<td>未完成</td>"
end if

if rs("agn_type")=1 then
    response.write "<td>已分配</td>"
else
    response.write "<td>未分配</td>"
end if
response.write "<td><a href=""viewresult.asp?id="&rs("id")&""">详情</a></td>"
response.write "</tr>"
rs.movenext
loop
rs.close
response.write "</table>"
conn.close
%>

sql组合我想你应该理解一下.

sql="select * from table where id=1"

sql=sql&" and name=2"

==
以上的sql语句与下边sql相同

sql="select * from table where id=1 and name=2"

执行的时候直接 conn.execute(sql) 就可以了.

分页是肯定要分页的.只是跟条件是没有关系的.

不管条件多少.分页只针对记录集的量进行分页..

只有一个条件的时候如果是100条分为5页

那么如果增加一个条件后为1000条..那么自然分页代码就会将其分为50页.

这很好理解哦.

如果分页有问题的话.想下换个方法写分页代码.

21#思路清晰.可以参考.

感谢，特别感谢大家，特别特别感谢21楼的兄弟，你给予了我巨大的帮助，谢谢……………………非常谢谢………………

特别谢谢你哥们，21楼的哥们，你真是好人啊，特别谢谢，经过你的努力我终于解决了！！！谢谢