我做了一个登录查询系统,用户登录后保存 session("id")=rs("VENID")
seach.asp
<%
dim g_id
dim x_pluid
x_pluid = Request("s_tiaoma")
g_id=session("id")
%>
主要SQL语句:
<%
sqlt="select DISTINCT RE_STOCK_HEAD.DOCNO,RE_STOCK_HEAD.LITSUM,RE_STOCK_HEAD.AUDIDATE,VE_VENDORINFO.VENNAME,ST_DEPART.DSNAME,SY_SYSTEMUSER.USER_NAME from RE_STOCK_DETAIL inner join RE_STOCK_HEAD on RE_STOCK_DETAIL.DOCNO=RE_STOCK_HEAD.DOCNO left join VE_VENDORINFO on RE_STOCK_HEAD.VENID=VE_VENDORINFO.VENID left join ST_DEPART on RE_STOCK_HEAD.STOREID=ST_DEPART.STOREID left join SY_SYSTEMUSER on RE_STOCK_HEAD.HANDLE=SY_SYSTEMUSER.USER_ID where 1=1"
if session("id")<>"" then
sqlt=sqlt&"and RE_STOCK_HEAD.VENID='"&g_id&"'"
temp="RE_STOCK_HEAD.VENID='"&g_id&"'"
END if
if request("s_tiaoma")<>"" then
sqlt=sqlt&"and RE_STOCK_DETAIL.PLUID like '%"&x_pluid&"%'"
temp="RE_STOCK_DETAIL"="'%"&x_pluid&"%'"
end if
rst.open sqlt,conn,3,2
%>
显示分页:
<%
if page>1 then
response.write"<a href='?page=1&"&temp&"' class=a1>第一页</a>"
response.write"<a href='?page="&page-1&"&"&temp&"' >上一页</a>"
end if
if page<rst.pagecount then
response.write"<a href='?page="&page+1&"&"&temp&"' >下一页</a>"
response.write"<a href='?page="&rst.pagecount&"&"&temp&"' class=a1>最后一页</a>"
end if%>现在可以查询,可是点下页的时候就出错,又返回全部记录了~~~哪里出错了,参数传递不到值是吗??
seach.asp
<%
dim g_id
dim x_pluid
x_pluid = Request("s_tiaoma")
g_id=session("id")
%>
主要SQL语句:
<%
sqlt="select DISTINCT RE_STOCK_HEAD.DOCNO,RE_STOCK_HEAD.LITSUM,RE_STOCK_HEAD.AUDIDATE,VE_VENDORINFO.VENNAME,ST_DEPART.DSNAME,SY_SYSTEMUSER.USER_NAME from RE_STOCK_DETAIL inner join RE_STOCK_HEAD on RE_STOCK_DETAIL.DOCNO=RE_STOCK_HEAD.DOCNO left join VE_VENDORINFO on RE_STOCK_HEAD.VENID=VE_VENDORINFO.VENID left join ST_DEPART on RE_STOCK_HEAD.STOREID=ST_DEPART.STOREID left join SY_SYSTEMUSER on RE_STOCK_HEAD.HANDLE=SY_SYSTEMUSER.USER_ID where 1=1"
if session("id")<>"" then
sqlt=sqlt&"and RE_STOCK_HEAD.VENID='"&g_id&"'"
temp="RE_STOCK_HEAD.VENID='"&g_id&"'"
END if
if request("s_tiaoma")<>"" then
sqlt=sqlt&"and RE_STOCK_DETAIL.PLUID like '%"&x_pluid&"%'"
temp="RE_STOCK_DETAIL"="'%"&x_pluid&"%'"
end if
rst.open sqlt,conn,3,2
%>
显示分页:
<%
if page>1 then
response.write"<a href='?page=1&"&temp&"' class=a1>第一页</a>"
response.write"<a href='?page="&page-1&"&"&temp&"' >上一页</a>"
end if
if page<rst.pagecount then
response.write"<a href='?page="&page+1&"&"&temp&"' >下一页</a>"
response.write"<a href='?page="&rst.pagecount&"&"&temp&"' class=a1>最后一页</a>"
end if%>现在可以查询,可是点下页的时候就出错,又返回全部记录了~~~哪里出错了,参数传递不到值是吗??
谢谢ACMAIN_CHM的关注,
刚才写错了一点:
if session("id")<>"" then
sqlt=sqlt&"and RE_STOCK_HEAD.VENID='"&g_id&"'"
temp1="RE_STOCK_HEAD.VENID='"&g_id&"'"
END if
if request("s_tiaoma")<>"" then
sqlt=sqlt&"and RE_STOCK_DETAIL.PLUID like '%"&x_pluid&"%'"
temp="RE_STOCK_DETAIL"="'%"&x_pluid&"%'"
end if
<%
if page>1 then
response.write"<a href='?page=1&"&temp&"&"&temp1&"' class=a1>第一页</a>"
response.write"<a href='?page="&page-1&"&"&temp&"&"&temp1&"' >上一页</a>"
end if
if page<rst.pagecount then
response.write"<a href='?page="&page+1&"&"&temp&"&"&temp1&"' >下一页</a>"
response.write"<a href='?page="&rst.pagecount&"&"&temp&"&"&temp1&"' class=a1>最后一页</a>"
end if%>
sql语句没错,查询出来的内容也是对的,就是下一页,后一页时出错了,查询条件丢失,一点下一页又出现全部记录,而不是查询的部分记录
其实是:RE_STOCK_DETAIL= ????x_pluid不见了
下一页就是ruku.asp?page=2&RE_STOCK_DETAIL=关键字&RE_STOCK_HEAD.VENID='"&g_id&"'"
但是'"&g_id&"'和关键字会丢失~~
一点击就直接返回全部记录了,而不是查询出来的第二页
<a href='?page=2&RE_STOCK_DETAIL.PLUID=02604&RE_STOCK_HEAD.VENID='0003'' class=a1>最后一页</a>
HTML源代码是这样的,怎么查询不出来呢???
rst.absolutepage=Page
for iPage=1 to rst.PageSize
if (i mod 2)=0 then
bgc="#FFFFFF"
else这儿的FOR循环你想实现什么?