Error in showing filtered Data

[AnilNe]

Dear Friends,
I have a problem with displaying the filtered data.
When I type a parameter from a HTML page...it should show the records with that criteria.
Suppose if it shows 50 records (10 records in each page), it shows 10 records on first page ok.
But when I click next, to see next 10 records, it shows some other records...which is not among those 50 records..
And instead of showing 20 to 30 records of 50, it shows something else (like 40 to 50 of 70 records).
Can anyone give Help?

Thanks in advance.
With Regards,
Anil

 

[Cheech]

Would love to help but need more info

What server script you using, asp? php?

Can you post the code so we can see?

Cheech

[Peace][Pipe]

 

[lebisol]

1. your Recordset navigation code is wrong


:--------------------------------------------------------------------------:

ok,ok...I did shoot the deputy but he told me he was the sheriff!
:--------------------------------------------------------------------------:

 

[AnilNe]

I am using ASP for this.
With Regards,
Anil

 

[Cheech]

As Lebisol has said then your recordset navigation code is wrong. Whats wrong with it we cant say without seeing it.

Its the same as writing to a garage and saying my car wont work, it runs on diesel. Whats wrong with it?

post the page code and we will try and help

Cheech

[Peace][Pipe]

 

[AnilNe]

here is the code. This page is supposed to filter recordset with respect to form paramter.

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include file="Connections/Journal_Thesis.asp" -->
<%
var Journal_Search_Title__MMColParam = "1";
if (String(Request.Form("journal_search_title")) != "undefined" &&
String(Request.Form("journal_search_title")) != "") {
Journal_Search_Title__MMColParam = String(Request.Form("journal_search_title"));
}
%>
<%
var Journal_Search_Title = Server.CreateObject("ADODB.Recordset");
Journal_Search_Title.ActiveConnection = MM_Journal_Thesis_STRING;
Journal_Search_Title.Source = "SELECT * FROM JournalTable WHERE vcrJournalTitle LIKE '%"+ Journal_Search_Title__MMColParam.replace(/'/g, "''") + "%' ORDER BY vcrJournalTitle ASC";
Journal_Search_Title.CursorType = 0;
Journal_Search_Title.CursorLocation = 2;
Journal_Search_Title.LockType = 1;
Journal_Search_Title.Open();
var Journal_Search_Title_numRows = 0;
%>
<%
var Repeat1__numRows = 10;
var Repeat1__index = 0;
Journal_Search_Title_numRows += Repeat1__numRows;
%>
<%
// *** Recordset Stats, Move To Record, and Go To Record: declare stats variables

// set the record count
var Journal_Search_Title_total = Journal_Search_Title.RecordCount;

// set the number of rows displayed on this page
if (Journal_Search_Title_numRows < 0) { // if repeat region set to all records
Journal_Search_Title_numRows = Journal_Search_Title_total;
} else if (Journal_Search_Title_numRows == 0) { // if no repeat regions
Journal_Search_Title_numRows = 1;
}

// set the first and last displayed record
var Journal_Search_Title_first = 1;
var Journal_Search_Title_last = Journal_Search_Title_first + Journal_Search_Title_numRows - 1;

// if we have the correct record count, check the other stats
if (Journal_Search_Title_total != -1) {
Journal_Search_Title_numRows = Math.min(Journal_Search_Title_numRows, Journal_Search_Title_total);
Journal_Search_Title_first = Math.min(Journal_Search_Title_first, Journal_Search_Title_total);
Journal_Search_Title_last = Math.min(Journal_Search_Title_last, Journal_Search_Title_total);
}
%>
<%
// *** Recordset Stats: if we don't know the record count, manually count them

if (Journal_Search_Title_total == -1) {

// count the total records by iterating through the recordset
for (Journal_Search_Title_total=0; !Journal_Search_Title.EOF; Journal_Search_Title.MoveNext()) {
Journal_Search_Title_total++;
}

// reset the cursor to the beginning
if (Journal_Search_Title.CursorType > 0) {
if (!Journal_Search_Title.BOF) Journal_Search_Title.MoveFirst();
} else {
Journal_Search_Title.Requery();
}

// set the number of rows displayed on this page
if (Journal_Search_Title_numRows < 0 || Journal_Search_Title_numRows > Journal_Search_Title_total) {
Journal_Search_Title_numRows = Journal_Search_Title_total;
}

// set the first and last displayed record
Journal_Search_Title_last = Math.min(Journal_Search_Title_first + Journal_Search_Title_numRows - 1, Journal_Search_Title_total);
Journal_Search_Title_first = Math.min(Journal_Search_Title_first, Journal_Search_Title_total);
}
%>
<% var MM_paramName = ""; %>

<%
// *** Move To Record and Go To Record: declare variables

var MM_rs = Journal_Search_Title;
var MM_rsCount = Journal_Search_Title_total;
var MM_size = Journal_Search_Title_numRows;
var MM_uniqueCol = "";
MM_paramName = "";
var MM_offset = 0;
var MM_atTotal = false;
var MM_paramIsDefined = (MM_paramName != "" && String(Request(MM_paramName)) != "undefined");
%>
<%
// *** Move To Record: handle 'index' or 'offset' parameter

if (!MM_paramIsDefined && MM_rsCount != 0) {

// use index parameter if defined, otherwise use offset parameter
r = String(Request("index"));
if (r == "undefined") r = String(Request("offset"));
if (r && r != "undefined") MM_offset = parseInt(r);

// if we have a record count, check if we are past the end of the recordset
if (MM_rsCount != -1) {
if (MM_offset >= MM_rsCount || MM_offset == -1) { // past end or move last
if ((MM_rsCount % MM_size) != 0) { // last page not a full repeat region
MM_offset = MM_rsCount - (MM_rsCount % MM_size);
} else {
MM_offset = MM_rsCount - MM_size;
}
}
}

// move the cursor to the selected record
for (var i=0; !MM_rs.EOF && (i < MM_offset || MM_offset == -1); i++) {
MM_rs.MoveNext();
}
if (MM_rs.EOF) MM_offset = i; // set MM_offset to the last possible record
}
%>
<%
// *** Move To Record: if we dont know the record count, check the display range

if (MM_rsCount == -1) {

// walk to the end of the display range for this page
for (var i=MM_offset; !MM_rs.EOF && (MM_size < 0 || i < MM_offset + MM_size); i++) {
MM_rs.MoveNext();
}

// if we walked off the end of the recordset, set MM_rsCount and MM_size
if (MM_rs.EOF) {
MM_rsCount = i;
if (MM_size < 0 || MM_size > MM_rsCount) MM_size = MM_rsCount;
}

// if we walked off the end, set the offset based on page size
if (MM_rs.EOF && !MM_paramIsDefined) {
if ((MM_rsCount % MM_size) != 0) { // last page not a full repeat region
MM_offset = MM_rsCount - (MM_rsCount % MM_size);
} else {
MM_offset = MM_rsCount - MM_size;
}
}

// reset the cursor to the beginning
if (MM_rs.CursorType > 0) {
if (!MM_rs.BOF) MM_rs.MoveFirst();
} else {
MM_rs.Requery();
}

// move the cursor to the selected record
for (var i=0; !MM_rs.EOF && i < MM_offset; i++) {
MM_rs.MoveNext();
}
}
%>
<%
// *** Move To Record: update recordset stats

// set the first and last displayed record
Journal_Search_Title_first = MM_offset + 1;
Journal_Search_Title_last = MM_offset + MM_size;
if (MM_rsCount != -1) {
Journal_Search_Title_first = Math.min(Journal_Search_Title_first, MM_rsCount);
Journal_Search_Title_last = Math.min(Journal_Search_Title_last, MM_rsCount);
}

// set the boolean used by hide region to check if we are on the last record
MM_atTotal = (MM_rsCount != -1 && MM_offset + MM_size >= MM_rsCount);
%>
<%
// *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters

// create the list of parameters which should not be maintained
var MM_removeList = "&index=";
if (MM_paramName != "") MM_removeList += "&" + MM_paramName.toLowerCase() + "=";
var MM_keepURL="",MM_keepForm="",MM_keepBoth="",MM_keepNone="";

// add the URL parameters to the MM_keepURL string
for (var items=new Enumerator(Request.QueryString); !items.atEnd(); items.moveNext()) {
var nextItem = "&" + items.item().toLowerCase() + "=";
if (MM_removeList.indexOf(nextItem) == -1) {
MM_keepURL += "&" + items.item() + "=" + Server.URLencode(Request.QueryString(items.item()));
}
}

// add the Form variables to the MM_keepForm string
for (var items=new Enumerator(Request.Form); !items.atEnd(); items.moveNext()) {
var nextItem = "&" + items.item().toLowerCase() + "=";
if (MM_removeList.indexOf(nextItem) == -1) {
MM_keepForm += "&" + items.item() + "=" + Server.URLencode(Request.Form(items.item()));
}
}

// create the Form + URL string and remove the intial '&' from each of the strings
MM_keepBoth = MM_keepURL + MM_keepForm;
if (MM_keepBoth.length > 0) MM_keepBoth = MM_keepBoth.substring(1);
if (MM_keepURL.length > 0) MM_keepURL = MM_keepURL.substring(1);
if (MM_keepForm.length > 0) MM_keepForm = MM_keepForm.substring(1);
%>
<%
// *** Move To Record: set the strings for the first, last, next, and previous links

var MM_moveFirst="",MM_moveLast="",MM_moveNext="",MM_movePrev="";
var MM_keepMove = MM_keepBoth; // keep both Form and URL parameters for moves
var MM_moveParam = "index";

// if the page has a repeated region, remove 'offset' from the maintained parameters
if (MM_size > 1) {
MM_moveParam = "offset";
if (MM_keepMove.length > 0) {
params = MM_keepMove.split("&");
MM_keepMove = "";
for (var i=0; i < params.length; i++) {
var nextItem = params.substring(0,params.indexOf("="));
if (nextItem.toLowerCase() != MM_moveParam) {
MM_keepMove += "&" + params;
}
}
if (MM_keepMove.length > 0) MM_keepMove = MM_keepMove.substring(1);
}
}

// set the strings for the move to links
if (MM_keepMove.length > 0) MM_keepMove += "&";
var urlStr = Request.ServerVariables("URL") + "?" + MM_keepMove + MM_moveParam + "=";
MM_moveFirst = urlStr + "0";
MM_moveLast = urlStr + "-1";
MM_moveNext = urlStr + (MM_offset + MM_size);
MM_movePrev = urlStr + Math.max(MM_offset - MM_size,0);
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
</head>

<body>
<p align="left"><font size="5"><strong><font size="4">Journal: Search by TITLE</font></strong></font></p>
<p align="left"><font size="5"><font color="#FF0000" size="3"> Title: <%=Request.Form("journal_search_title")%><br>
No of Records Found: <%=(Journal_Search_Title_last)%></font></font></p>

<font color="#0000FF">Records <%=(Journal_Search_Title_first)%> to <%=(Journal_Search_Title_last)%> of <%=(Journal_Search_Title_total)%></font>
<% while ((Repeat1__numRows-- != 0) && (!Journal_Search_Title.EOF)) { %>
<table border="0" width="50%" align="center">
<tr>
<td width="23%" align="center">
<% if (MM_offset != 0) { %>
<a href="<%=MM_moveFirst%>"><img src="First.gif" border=0></a>
<% } // end MM_offset != 0 %>
</td>
<td width="31%" align="center">
<% if (MM_offset != 0) { %>
<a href="<%=MM_movePrev%>"><img src="Previous.gif" border=0></a>
<% } // end MM_offset != 0 %>
</td>
<td width="23%" align="center">
<% if (!MM_atTotal) { %>
<a href="<%=MM_moveNext%>"><img src="Next.gif" border=0></a>
<% } // end !MM_atTotal %>
</td>
<td width="23%" align="center">
<% if (!MM_atTotal) { %>
<a href="<%=MM_moveLast%>"><img src="Last.gif" border=0></a>
<% } // end !MM_atTotal %>
</td>
</tr>
</table>
<table width="75%" border="0">
<tr bordercolor="#FFFFFF" bgcolor="#00CCCC">
<td width="13%"><strong>Title</strong></td>
<td width="87%"><%=(Journal_Search_Title.Fields.Item("vcrJournalTitle").Value)%></td>
</tr>
<tr bordercolor="#FFFFFF">
<td><strong>Location</strong></td>
<td bgcolor="#FFFFFF"><%=(Journal_Search_Title.Fields.Item("vcrLocation").Value)%></td>
</tr>
<tr bordercolor="#FFFFFF">
<td><strong>Vol:</strong></td>
<td><%=(Journal_Search_Title.Fields.Item("txtCollection").Value)%></td>
</tr>
</table>
<%
Repeat1__index++;
Journal_Search_Title.MoveNext();
}
%>
<table border="0" width="50%" align="center">

<tr>
<td width="23%" align="center"> <% if (MM_offset != 0) { %>
<a href="<%=MM_moveFirst%>"><img src="First.gif" border=0></a>
<% } // end MM_offset != 0 %> </td>
<td width="31%" align="center"> <% if (MM_offset != 0) { %>
<a href="<%=MM_movePrev%>"><img src="Previous.gif" border=0></a>
<% } // end MM_offset != 0 %> </td>
<td width="23%" align="center"> <% if (!MM_atTotal) { %>
<a href="<%=MM_moveNext%>"><img src="Next.gif" border=0></a>
<% } // end !MM_atTotal %> </td>
<td width="23%" align="center"> <% if (!MM_atTotal) { %>
<a href="<%=MM_moveLast%>"><img src="Last.gif" border=0></a>
<% } // end !MM_atTotal %> </td>
</tr>
</table>


<font color="#0000FF">Records <%=(Journal_Search_Title_first)%> to <%=(Journal_Search_Title_last)%> of <%=(Journal_Search_Title_total)%> </font>
</body>
</html>
<%
Journal_Search_Title.Close();
%>