SQL---union在asp分页中的问题，莫名其妙~~~~~~~~~~~ ( 积分: 200 )

corser · 2005-06-11

比如数据库中每个表由10条记录，每页我设置显示5条。问题是现在第一页好好的。第二页竟然是空的了。应该有剩下5条才对啊。为了保持代码完整性，我全部粘贴上来了。大家可以模拟建一个数据库。把代码贴到自己机子上运行看看。用select * form 某个表就好好的，一点问题没有。可是我要搜索的是六个表（每个表结构完全一样，就是数据不同。）中p_type="aa"的记录。就是多表查询，如果是单表，那么分页正常。
多表查询到第二页就没记录了。到底是什么回事？或者大家有更好的多表+asp分页查询显示也可以写上来告诉我。
谢谢大家了，那么热的天。
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<%
Set conn = Server.CreateObject("ADODB.Connection&quot

strcon="provider=microsoft.jet.oledb.4.0;data source="&
_
server.mappath("database/product.mdb&quot

conn.Open strcon
Set rs = Server.CreateObject ("ADODB.Recordset&quot

SQL="select * from 陈设藏品 where p_type='"&request.Form("select&quot

&"' union all select * from 挂件生肖 where p_type='"&request.Form("select&quot

&"' union all select * from 汽车内饰 where p_type='"&request.Form("select&quot

&"' union all select * from 生活保健 where p_type='"&request.Form("select&quot

&"' union all select * from 首饰手镯 where p_type='"&request.Form("select&quot

&"' union all select * from 文房四宝 where p_type='"&request.Form("select&quot

&"'"
rs.Open sql, conn, 1
rs.PageSize = 5 '每页显示记录数
if Not IsEmpty(Request("Page&quot

) then
'如果PAGE已经初始化...
Page = CInt(Request("Page&quot

) '接收PAGE并化为数字型赋给PAGE变量
if Page > rs.PageCount then
'如果接收的页数大于总页数
page=Rs.pageCount
rs.AbsolutePage = rs.PageCount '设置当前显示页等于最后页
else
rs.AbsolutePage = Page '显示当前页等于接收的页数
end if
else

Page = 1 '如果page未被初始化则设为1
End if
rs.AbsolutePage=page
%>
<meta http-equiv="Content-Type"
content="text/html;
charset=gb2312">
<title>青岛玉网主页</title>
<style type="text/css">

</style>
<link href="CSS/text%20link.css"
rel="stylesheet"
type="text/css">
<style type="text/css">

</style>
</head>
<body>

<TABLE WIDTH=780 height="164%"
BORDER=0 align="center"
CELLPADDING=0 CELLSPACING=0>
<TR align="left"
valign="top">
<TD COLSPAN=2><table width="780"
border="0"
cellspacing="0"
cellpadding="0">
<tr bgcolor="#CACDDF">
<td height="4"
align="left"
valign="top"><img src="file:///C|/Documents%20and%20Settings/sj/&#26700;&#38754;/&#27169;&#26495;/&#27431;&#32654;&#21830;&#21153;&#39764;&#26495;/web_057/Html/images/spacer.gif"
width="1"
height="4"></td>
</tr>
<tr>
<td align="left"
valign="top"><table width="779"
height="39"
border="0">
<tr>
<td width="189"
height="35"
valign="middle"><div align="left"><span class="style37">客服热线：0532-88888888</span></div></td>
<td width="0"
height="35"><table width="583"
border="0">
<tr>
<td width="30"><img src="images/happyking_05.jpg"
width="27"
height="27"></td>
<td width="70"
valign="middle"><SPAN style="FONT-SIZE: 9pt"><A
href="http://www.ehaier.com/jsp/cart/CartList.jsp"><FONT
color=#ff0066>我的购物车</FONT></A></SPAN></td>
<td width="30"><img src="images/happyking_09.jpg"
width="27"
height="27"
align="top"></td>
<td width="56"
valign="middle"><FONT color=#ff0066><SPAN
style="FONT-SIZE: 9pt"><A
href="http://www.ehaier.com/sysstatic/flow_demo.jsp"><FONT
color=#ff0066>购物指南</FONT></A></SPAN></FONT></td>
<td width="31"><img src="images/happyking_11.jpg"
width="27"
height="27"
align="top"></td>
<td width="42"
valign="middle"><A
href="guestbook/index.asp"><FONT
color=#ff0066><SPAN
style="FONT-SIZE: 9pt">留言板</SPAN></FONT></A></td>
<td width="287"><form name="form1"
method="post"
action="">
<table width="294"
border="0">
<tr>
<td width="44"><div align="right"><img src="images/search1.gif"
width="20"
height="16"></div></td>
<td width="62"
valign="middle"><span class="style22">商品搜索</span></td>
<td width="102"><select name="select">
<option>玉镯</option>
<option>项链</option>
<option>生肖</option>
<option>手球</option>
<option>玉印</option>
<option>玉枕</option>
<option>玉席玉垫</option>
<option>摆设</option>
</select></td>
<td width="57"><img src="images/go1.gif"
width="19"
height="19"
border="0">
</td>
</tr>
</table>
</form></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
<tr>
<td width="0"
align="left"
valign="top"><table width="100%"
height="94"
border="0">
<tr>
<td><span class="style37"><img src="images/logo%20copy.gif"
width="140"
height="60"></span></td>
<td><img src="images/gridflux800.jpg"
width="633"
height="88"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="0"
align="left"
valign="top"><div align="center">
<table width="777"
border="0"
cellspacing="0"
cellpadding="0">
<tr>
<td width="777"
height="26"
align="left"
valign="top"
bgcolor="#FFFFFF"><table width="776"
height="28"
border="0">
<tr background="images/menu.jpg">
<td width="73"
background="images/menu.jpg"><div align="center"
class="style37 style36"><a href="index.asp"
target="_self"
class="style50">首页</a></div></td>
<td width="73"
background="images/menu.jpg"><div align="center"
class="style36"><a href="search.asp"
target="_self"
class="style50">首饰/手镯</a></div></td>
<td width="73"
background="images/menu.jpg"><div align="center"
class="style36"><a href="guashi.asp"
target="_self"
class="style50">挂件/生肖</a></div></td>
<td width="73"
background="images/menu.jpg"><div align="center"
class="style36"><a href="life.asp"
target="_self"
class="style50">生活/保健</a></div></td>
<td width="73"
background="images/menu.jpg"><div align="center"
class="style36"><a href="wenfang.asp"
target="_self"
class="style50">文房四宝</a></div></td>
<td width="73"
background="images/menu.jpg"><div align="center"
class="style36"><a href="car.asp"
target="_self"
class="style50">汽车内饰</a></div></td>
<td width="73"
background="images/menu.jpg"><div align="center"
class="style36"><a href="layout.asp"
target="_self"
class="style50">陈设藏品</a></div></td>
<td width="73"
background="images/menu.jpg"><div align="center"
class="style36"><a href="html/maintain.htm"
target="_self"
class="style50">玉的保养</a></div></td>
<td width="73"
background="images/menu.jpg"><div align="center"
class="style36"><a href="html/culture.htm"
target="_self"
class="style50">玉的文化</a></div></td>
<td width="77"
background="images/menu.jpg"><div align="center"
class="style36"><a href="html/introduce.htm"
target="_self"
class="style50">玉网简介</a></div></td>
</tr>
</table></td>
</tr>
</table>
<table width="778"
border="0">
<tr>
<td width="487"><div align="left">
<table width="588"
height="21"
border="0">
<tr>
<td width="352"
class="style17">您的位置：首页</td>
<td width="778"
class="style37">祝您在青岛玉网购物愉快！</td>
</tr>
</table>
</div></td>
</tr>
</table>
</div></td>
</tr>
</table>
</TD>
</TR>
<TR>
<TD width="0"
align="left"
valign="top"><div style="padding-left:0px;
padding-bottom:5px">
<table width="98%"
height="30%"
border="0">
<tr>
<td width="233"
height="30"
align="center"
valign="middle"
background="images/kettle_2.gif"><div align="center"
class="style46">会员登录</div></td>
</tr>
</table>
<table width="230"
border="0"
bordercolor="#CCCCCC">
<tr>
<td width="238"
height="29"><TABLE width="100%"
align=left cellPadding=4 cellSpacing=1 bordercolor="#990033"
bgColor=#ffffff>
<TBODY>
<TR>
<TD align=middle colSpan=2 height=5></TD>
</TR>
<FORM action=admin.php method=post>
<TR>
<TD style="FONT-SIZE: 12px;
COLOR: #000000"
align=middle
width="43%"
height=22><div align="center">会员名：</div></TD>
<TD width="57%"
height=22><div align="center">
<INPUT class=input
maxLength=20 size=11 name=muser>
</div></TD>
</TR>
<TR>
<TD style="FONT-SIZE: 12px;
COLOR: #000000"
align=middle
width="43%"
height=22><div align="center">密　码：</div></TD>
<TD width="57%"
height=22><div align="center">
<INPUT class=input
type=password maxLength=20 size=11 name=mpass>
</div></TD>
</TR>
<TR>
<TD align=right height=20><a href="user_registration.asp"><img src="images/zc.jpg"
width="74"
height="32"
border="0"
align="baseline"></a> </TD>
<TD vAlign=top height=20><div align="center"><img src="images/dl2.jpg"
width="74"
height="31"></div></TD>
</FORM>
</TABLE></td>
</tr>
<tr>
<td height="355"
valign="top"><div align="left">
<table width="100%"
height="234"
border="0"
bordercolor="#FFFFFF">
<tr>
<td width="237"
height="30"
background="images/kettle_1.gif"><div align="center"
class="style49">新品推荐</div></td>
</tr>
<tr>
<td height="198"
valign="top">&nbsp;</td>
</tr>
</table>
<table width="238"
border="0">
<tr>
<td width="208"
height="33"
background="images/kettle_4.gif"><div align="center"
class="style46">
<p>客服中心</p>
</div></td>
</tr>
<tr>
<td height="133"
valign="top"
bordercolor="#CCCCCC"><div align="center">
<p align="left"
class="style48">您的任何疑问,我们将全力以赴为您解决！</p>
<p align="left"
class="style48"><span class="style49">客服热线</span><img src="images/1111485546.gif"
width="20"
height="20">:<span class="style49">0532-88888888 13888888888 </span></p>
<p align="left"
class="style48"><span class="style49">在线客服</span><img src="images/1106908031.gif"
width="20"
height="20">:<span class="style49">111111111</span></p>
<p align="left"
class="style48"><span class="style49">客服</span><img src="images/1111485629.gif"
width="16"
height="16">:<span class="style49">xxxx@xxx.com</span></p>
</div></td>
</tr>
</table>
</div></td>
</tr>
</table>
</div></TD>
<TD width="539"
align="left"
valign="top"><table width="539"
border="0"
cellspacing="0"
cellpadding="0">
<tr>
<td height="460"
align="left"
valign="top"><div style="padding-left:14px;
padding-top:15px">
<div align="center"><font size="2"> <strong>
<%
i=0
response.Write(rs.recordcount)
do while not rs.eof
%>
</strong></font> </div>
<table width="600"
border="0"
ALIGN="CENTER">
<tr>
<td WIDTH=106><img src="<%=rs("pic_addr&quot

%>"
alt=""
width="106"
height="100"></td>
<td WIDTH=98 valign="top"
background="images/back_rep_2.gif"><p><%=rs("product_name&quot

%></p>
<p><span class="style5">市场价:<span class="style7">￥</span></span><%=rs("price&quot

%></p>
<p><span class="style5">会员价:<span class="style7">￥</span></span><%=rs("vip_price&quot

%></p></td>
<td WIDTH=382 valign="top"
background="images/back_rep_2.gif"><span class="style5"><br>
<%=rs("introduction&quot

%> </span></td>
</tr>
<tr background="images/back_rep_2.gif">
<td COLSPAN="4"
align="center">&nbsp;</td>
</tr>
</table>
<%
'当显示记录大于maxperpage时结束这页
i=i+1
IF i>=rs.PageSize then
exitdo

rs.movenext
loop
%>
<form method=Post action="search.asp">
<div align="right"><span class="style51"><font color="#000080"
size="2">共有<%=rs.recordcount%>条纪录分为<%=rs.PageCount%>页此为第<%=page%>页
<%if page>1 then
%>
<a href="search.asp?Page=<%=1%>">首页</a>
<a href="search.asp?Page=<%=page-1%>">上一页</a>
<%end if %>
<%if page<>rs.pagecount then
%>
<a href="search.asp?Page=<%=page+1%>">下一页</a>
<a href="search.asp?Page=<% = rs.PageCount%>">尾页</a>
<% end if %>
转到：</font> <font size="2">
<input type="text"
name="page"
size="4"
maxlength="10"
value="<%=page%>">
</font></span> <font size="2">
<input type="submit"
value="
Goto "
name="cndok">
</font></div>
</form>
</div></td>
</tr>
</table></TD>
</TR>
<TR align="left"
valign="top">
<TD height="50"
COLSPAN=2><div style="padding-left:2px;
padding-top:0px">
<TABLE cellSpacing=0 cellPadding=0 width=782 border=0>
<TBODY>
<TR>
<TD width="782"
height=32 vAlign=center><TABLE height="91%"
cellSpacing=0 cellPadding=0 width=779
border=0>
<TBODY>
<TR>
<TD width=537 vAlign=middle background="images/bg_bot.gif"
bgcolor="#FFFFFF"><FONT
style="FONT-WEIGHT: bold;
FONT-SIZE: 12px;
BACKGROUND: #ffffff;
COLOR: #ff0000">|<a href="html/help%20center.htm">&nbsp;</a><A
style="FONT-WEIGHT: bold;
FONT-SIZE: 12px;
BACKGROUND: #ffffff;
COLOR: #ff0000"
href="html/help%20center.htm?nowmenuid=306"
target=_self>购物方式</A>&nbsp;|&nbsp;<A
style="FONT-WEIGHT: bold;
FONT-SIZE: 12px;
BACKGROUND: #ffffff;
COLOR: #ff0000"
href="html/delivery.htm?nowmenuid=306"
target=_self>送货方式</A>&nbsp;|&nbsp;<A
style="FONT-WEIGHT: bold;
FONT-SIZE: 12px;
BACKGROUND: #ffffff;
COLOR: #ff0000"
href="html/payment.htm?nowmenuid=308"
target=_self>付款方式</A>&nbsp;|&nbsp;<A
style="FONT-WEIGHT: bold;
FONT-SIZE: 12px;
BACKGROUND: #ffffff;
COLOR: #ff0000"
href="html/replace.htm?nowmenuid=309"
target=_self>退换原则</A>&nbsp;|&nbsp;<A
style="FONT-WEIGHT: bold;
FONT-SIZE: 12px;
BACKGROUND: #ffffff;
COLOR: #ff0000"
href="html/servic%20guarantee.htm?nowmenuid=310"
target=_self>服务保证</A>&nbsp;| <A
style="FONT-WEIGHT: bold;
FONT-SIZE: 12px;
BACKGROUND: #ffffff;
COLOR: #ff0000"
href="html/afterservice.htm?nowmenuid=310"
target=_self>售后服务</A> | <A
style="FONT-WEIGHT: bold;
FONT-SIZE: 12px;
BACKGROUND: #ffffff;
COLOR: #ff0000"
href="html/gather%20cents.htm?nowmenuid=310"
target=_self>积分奖励</A> |</FONT></TD>
</TR>
</TBODY>
</TABLE></TD>
</TR>
<TR>
<TD valign="top"><P align=center><FONT style="FONT-SIZE: 9pt"
color=#1e578a> 青岛玉网　Copyright 2004-2005 All Rights Reserved. <img src="images/1106908023.gif"
width="27"
height="29"></FONT></P>
</TD>
</TR>
</TBODY>
</TABLE>
</div></TD>
</TR>
</TABLE>

</body>
</html>
<%
conn.close
set conn=nothing
set rs=nothing
%>

corser · 2005-06-11