jarv
05-22-2009, 01:56 PM
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Signature - Welcome</title>
<link rel="stylesheet" type="text/css" href="css/style1.css" />
<!--#include file="includes/functionlib.asp"-->
<%
Session.LCID = 2057
logincheck()
opendb()
UserID = session("UserID")
sql = "SELECT reports.*, stores.StoreName, branches.BranchLocation, flags.FlagImage FROM (flags INNER JOIN (branches INNER JOIN reports ON branches.BranchID=reports.BranchID) ON flags.FlagID=reports.FlagID) INNER JOIN stores ON branches.StoreID=stores.StoreID"
SELECT CASE request.QueryString("sortby")
case "date"
sqlsort = " ORDER BY ReportDate"
case "store"
sqlsort = " ORDER BY StoreName"
case "branch"
sqlsort = " ORDER BY BranchLocation"
case "flag"
sqlsort = " ORDER BY reports.FlagID"
case else
sqlsort = " ORDER BY ReportDate"
END SELECT
SELECT CASE request.QueryString("sorting")
case "ASC"
sqlorder = " ASC"
case "DESC"
sqlorder = " DESC"
case else
sqlorder = " ASC"
END SELECT
sql = sql & sqlsort & sqlorder
Set rs1 = objConn.Execute(sql)
recCount = 0
noofrows = 10
%>
</head>
<body>
<div id="wrapper">
<img src="images/sig-logo.gif" alt="" width="486" height="115" align="right" />
<%IF session("rsSec") <= 2 THEN %>
<div id="Nav"><div class="Navbutton"><a href="reports.asp">HOME</a></div><div class="Navbutton"><a href="view-stores.asp">VIEW STORES</a></div><div class="Navbutton"><a href="add-store.asp">ADD STORE</a></div><div class="Navbutton"><a href="add-branch.asp">ADD BRANCH</a></div><div class="Navbutton"><a href="add-report.asp">ADD REPORT</a></div><div class="Navbutton"><a href="logout_script.asp">LOGOUT</a></div></div>
<%ELSE%>
<div id="Nav"><div class="Navbutton"><a href="logout_script.asp">LOGOUT</a></div></div>
<%END IF%>
<div id="contentarea">
<p>
Welcome <% = Session("rsUser")%>,
</p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th><a href="reports.asp?sortby=date&sorting=DESC"><img src="images/down.gif" border="0" alt="decending" /></a><a href="reports.asp?sortby=date&sorting=ASC"><img src="images/up.gif" border="0" alt="acending" /></a>Date</th>
<th><a href="reports.asp?sortby=store&sorting=DESC"><img src="images/down.gif" border="0" alt="decending" /></a><a href="reports.asp?sortby=store&sorting=ASC"><img src="images/up.gif" border="0" alt="acending" /></a>Store</th>
<th><a href="reports.asp?sortby=branch&sorting=DESC"><img src="images/down.gif" border="0" alt="decending" /></a><a href="reports.asp?sortby=branch&sorting=ASC"><img src="images/up.gif" border="0" alt="acending" /></a>Branch</th>
<th><a href="reports.asp?sortby=flag&sorting=DESC"><img src="images/down.gif" border="0" alt="decending" /></a><a href="reports.asp?sortby=flag&sorting=ASC"><img src="images/up.gif" border="0" alt="acending" /></a>Flag</th>
<th>Visited/Report by</th>
<th>View Report</th>
<%IF session("rsSec") <= 2 THEN %>
<th>Edit Report</th>
<%ELSE%>
<th> </th>
<%END IF%>
</tr><%While Not rs1.EOF %>
<tr>
<%IF recCount >= cint(request.QueryString("pageno"))*noofrows AND recCount < (cint(request.QueryString("pageno"))*noofrows)+noofrows THEN%>
<td class="smallcelltext"><%= rs1("ReportDate") %> </td>
<td class="smallcelltext"><%= rs1("StoreName") %> </td>
<td class="smallcelltext"><%= rs1("BranchLocation") %> </td>
<td class="smallcelltext"><img src="<%= rs1("FlagImage") %>" border="0" alt="Flag colour" /> </td>
<td class="smallcelltext"><%= rs1("ReportBy") %> </td>
<td class="smallcelltext"><a href="view-report.asp?ReportID=<%= rs1("ReportID") %>">View Report</a></td>
<%IF session("rsSec") <= 2 THEN %>
<td class="smallcelltext"><a href="edit-report.asp?ReportID=<%= rs1("ReportID") %>">Edit Report</a></td>
<%ELSE%>
<td class="smallcelltext"> </td>
<%END IF%>
<% end if %>
</tr><%rs1.MoveNext
recCount = recCount + 1
Wend %>
<tr>
<td colspan="6">
<%FOR paging = 0 to recCount/noofrows
Response.Write(" <a href=""reports.asp?pageno=" & paging & """ class=""pagelink"">" & paging+1 & "</a> ")
IF paging < recCount/noofrows-1 THEN response.Write("- ")
NEXT
rs1.Close%>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</div>
<div id="footer">
Copyright 2009 © Signature
</div>
</div>
</body>
</html>
ok so in my code I have pagination and sorting but when I sort the table and then select say page 3 it changes the sorting?!
can anyone help me here please?
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
<head>
<title>Signature - Welcome</title>
<link rel="stylesheet" type="text/css" href="css/style1.css" />
<!--#include file="includes/functionlib.asp"-->
<%
Session.LCID = 2057
logincheck()
opendb()
UserID = session("UserID")
sql = "SELECT reports.*, stores.StoreName, branches.BranchLocation, flags.FlagImage FROM (flags INNER JOIN (branches INNER JOIN reports ON branches.BranchID=reports.BranchID) ON flags.FlagID=reports.FlagID) INNER JOIN stores ON branches.StoreID=stores.StoreID"
SELECT CASE request.QueryString("sortby")
case "date"
sqlsort = " ORDER BY ReportDate"
case "store"
sqlsort = " ORDER BY StoreName"
case "branch"
sqlsort = " ORDER BY BranchLocation"
case "flag"
sqlsort = " ORDER BY reports.FlagID"
case else
sqlsort = " ORDER BY ReportDate"
END SELECT
SELECT CASE request.QueryString("sorting")
case "ASC"
sqlorder = " ASC"
case "DESC"
sqlorder = " DESC"
case else
sqlorder = " ASC"
END SELECT
sql = sql & sqlsort & sqlorder
Set rs1 = objConn.Execute(sql)
recCount = 0
noofrows = 10
%>
</head>
<body>
<div id="wrapper">
<img src="images/sig-logo.gif" alt="" width="486" height="115" align="right" />
<%IF session("rsSec") <= 2 THEN %>
<div id="Nav"><div class="Navbutton"><a href="reports.asp">HOME</a></div><div class="Navbutton"><a href="view-stores.asp">VIEW STORES</a></div><div class="Navbutton"><a href="add-store.asp">ADD STORE</a></div><div class="Navbutton"><a href="add-branch.asp">ADD BRANCH</a></div><div class="Navbutton"><a href="add-report.asp">ADD REPORT</a></div><div class="Navbutton"><a href="logout_script.asp">LOGOUT</a></div></div>
<%ELSE%>
<div id="Nav"><div class="Navbutton"><a href="logout_script.asp">LOGOUT</a></div></div>
<%END IF%>
<div id="contentarea">
<p>
Welcome <% = Session("rsUser")%>,
</p>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<th><a href="reports.asp?sortby=date&sorting=DESC"><img src="images/down.gif" border="0" alt="decending" /></a><a href="reports.asp?sortby=date&sorting=ASC"><img src="images/up.gif" border="0" alt="acending" /></a>Date</th>
<th><a href="reports.asp?sortby=store&sorting=DESC"><img src="images/down.gif" border="0" alt="decending" /></a><a href="reports.asp?sortby=store&sorting=ASC"><img src="images/up.gif" border="0" alt="acending" /></a>Store</th>
<th><a href="reports.asp?sortby=branch&sorting=DESC"><img src="images/down.gif" border="0" alt="decending" /></a><a href="reports.asp?sortby=branch&sorting=ASC"><img src="images/up.gif" border="0" alt="acending" /></a>Branch</th>
<th><a href="reports.asp?sortby=flag&sorting=DESC"><img src="images/down.gif" border="0" alt="decending" /></a><a href="reports.asp?sortby=flag&sorting=ASC"><img src="images/up.gif" border="0" alt="acending" /></a>Flag</th>
<th>Visited/Report by</th>
<th>View Report</th>
<%IF session("rsSec") <= 2 THEN %>
<th>Edit Report</th>
<%ELSE%>
<th> </th>
<%END IF%>
</tr><%While Not rs1.EOF %>
<tr>
<%IF recCount >= cint(request.QueryString("pageno"))*noofrows AND recCount < (cint(request.QueryString("pageno"))*noofrows)+noofrows THEN%>
<td class="smallcelltext"><%= rs1("ReportDate") %> </td>
<td class="smallcelltext"><%= rs1("StoreName") %> </td>
<td class="smallcelltext"><%= rs1("BranchLocation") %> </td>
<td class="smallcelltext"><img src="<%= rs1("FlagImage") %>" border="0" alt="Flag colour" /> </td>
<td class="smallcelltext"><%= rs1("ReportBy") %> </td>
<td class="smallcelltext"><a href="view-report.asp?ReportID=<%= rs1("ReportID") %>">View Report</a></td>
<%IF session("rsSec") <= 2 THEN %>
<td class="smallcelltext"><a href="edit-report.asp?ReportID=<%= rs1("ReportID") %>">Edit Report</a></td>
<%ELSE%>
<td class="smallcelltext"> </td>
<%END IF%>
<% end if %>
</tr><%rs1.MoveNext
recCount = recCount + 1
Wend %>
<tr>
<td colspan="6">
<%FOR paging = 0 to recCount/noofrows
Response.Write(" <a href=""reports.asp?pageno=" & paging & """ class=""pagelink"">" & paging+1 & "</a> ")
IF paging < recCount/noofrows-1 THEN response.Write("- ")
NEXT
rs1.Close%>
</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
</div>
<div id="footer">
Copyright 2009 © Signature
</div>
</div>
</body>
</html>
ok so in my code I have pagination and sorting but when I sort the table and then select say page 3 it changes the sorting?!
can anyone help me here please?