DMX|ZONE
Register Login

Forums

ASP

This topic is locked

Not all records showing


andy bertaut
Posted 10 Oct 2005 13:24:27
1
has voted
Vote
10 Oct 2005 13:24:27 andy bertaut posted:
I have several pages on my site each taking their information from a seperate recordset, I am using a Dynamic Table (coz I need to have more than one column of info to save the page going on and on) but no matter how many records I set the table to show, it only shows the first 16 items. If I Test the record set, all records show just fine.
I am including the code below for the page as it is right now, with only one dynamic table in it, with two dynamic fields, Name, and Expr1. Although there are 66 records in this, only 16 are showing no matter what I do.
<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>
<!--#include file="../Connections/connSlevin.asp" -->
<%
var rsGOLF__MMColParam = "1";
if (String(Request.QueryString("ProductCode") != "undefined" &&
String(Request.QueryString("ProductCode") != "" {
rsGOLF__MMColParam = String(Request.QueryString("ProductCode");
}
%>
<%
var rsGOLF = Server.CreateObject("ADODB.Recordset";
rsGOLF.ActiveConnection = MM_connSlevin_STRING;
rsGOLF.Source = "SELECT Name, Expr1 FROM golf_acc WHERE ProductCode LIKE '%"+ rsGOLF__MMColParam.replace(/'/g, "''" + "%'";
rsGOLF.CursorType = 0;
rsGOLF.CursorLocation = 2;
rsGOLF.LockType = 1;
rsGOLF.Open();
var rsGOLF_numRows = 0;
%>
<%
var Repeat1__numRows = -1;
var Repeat1__index = 0;
rsGOLF_numRows += Repeat1__numRows;
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "www.w3.org/TR/html4/loose.dtd">
<html><!-- InstanceBegin template="/Templates/slevin.dwt" codeOutsideHTMLIsLocked="false" -->
<head>
<title>Slevin OE Group</title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css">
<!--
body {
margin-left: 0px;
margin-top: 0px;
margin-right: 0px;
margin-bottom: 0px;
}
-->
</style>
<link href="../slevin.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function flvFPW1(){//v1.44
// Copyright 2002-2004, Marja Ribbers-de Vroed, FlevOOware (www.flevooware.nl/dreamweaver/)
var v1=arguments,v2=v1[2].split(",",v3=(v1.length>3)?v1[3]:false,v4=(v1.length>4)?parseInt(v1[4]):0,v5=(v1.length>5)?parseInt(v1[5]):0,v6,v7=0,v8,v9,v10,v11,v12,v13,v14,v15,v16;v11=new Array("width,left,"+v4,"height,top,"+v5);for (i=0;i<v11.length;i++){v12=v11[i].split(",";l_iTarget=parseInt(v12[2]);if (l_iTarget>1||v1[2].indexOf("%">-1){v13=eval("screen."+v12[0]);for (v6=0;v6<v2.length;v6++){v10=v2[v6].split("=";if (v10[0]==v12[0]){v14=parseInt(v10[1]);if (v10[1].indexOf("%">-1){v14=(v14/100)*v13;v2[v6]=v12[0]+"="+v14;}}if (v10[0]==v12[1]){v16=parseInt(v10[1]);v15=v6;}}if (l_iTarget==2){v7=(v13-v14)/2;v15=v2.length;}else if (l_iTarget==3){v7=v13-v14-v16;}v2[v15]=v12[1]+"="+v7;}}v8=v2.join(",";v9=window.open(v1[0],v1[1],v8);if (v3){v9.focus();}document.MM_returnValue=false;return v9;}
//-->
</script>
</head>

<body>
<table width="100%" height="750" border="0" cellpadding="0" cellspacing="0">
<tr>
<td background="../images/bg_image.gif"> </td>
<td width="700" valign="top"><table width="700" height="439" border="0" cellpadding="0" cellspacing="0">
<tr id="navbar">
<td width="169" height="97"><a href="../asp/default.asp"><img src="../images/slevin_logo_raised.jpg" alt="Slevin OE Group Home" width="169" height="97" border="0"></a></td>
<td width="77" align="center" valign="middle"><a href="default.asp" id="navbar">Home</a><br/>
<img src="../images/orange_arrow.jpg" alt="Home"></td>
<td width="77" align="center" valign="middle"><a href="aboutus.asp" id="navbar">About Us</a><br/>
<img src="../images/orange_arrow.jpg" alt="About Us"></td>
<td width="77" align="center" valign="middle"><a href="oegroup.opnet-irl.com/Index.asp" target="_blank" id="navbar" onClick="flvFPW1(this.href,'OscarNet','width=770,height=520,toolbar=yes,resizable=yes',1);return document.MM_returnValue">OscarNet</a><br/>
<img src="../images/orange_arrow.jpg" alt="Contact"></td>
<td width="77" align="center" valign="middle"><a href="enquiries.asp" id="navbar">Enquiries</a><br/>
<img src="../images/orange_arrow.jpg" alt="Enquiries"></td>
<td width="77" align="center" valign="middle"><a href="brochure.asp" id="navbar">Brochure</a><br/>
<img src="../images/orange_arrow.jpg" alt="Brochure"></td>
<td width="100" align="center" valign="middle"><a href="specialoffer.asp" id="navbar">Special Offer</a><br/>
<img src="../images/orange_arrow.jpg" alt="Special Offer"></td>
<td width="46" align="center" valign="middle"> </td>
</tr>
<tr id="navbar">
<td height="88" colspan="8"><img src="../images/colour_bnr.jpg" width="700" height="88"></td>
</tr>
<tr>
<td width="169" valign="top"><div id="leftnav">
<ul>
<li><strong id="Headings">Corporate Gifts</strong></li>
<li><a href="exec_gift.asp">Executive Gifts</a></li>
<li><a href="golf_acc.asp">Golf Accessories</a></li>
<li><a href="time_piec.asp">Time Pieces</a></li>
<li><strong id="Headings">Promotional Items</strong></li>
<li> <a href="../prom_items/writ_inst.asp">Writing Instruments</a></li>
<li><a href="../prom_items/glass.asp">Glassware</a></li>
<li><a href="../prom_items/stat_items.asp">Stationery Items</a></li>
<li><a href="../prom_items/elec_items.asp">Electronic Items</a></li>
<li><a href="../prom_items/conf_merc.asp">Conference Merchandise</a></li>
<li><a href="../prom_items/bags_cases.asp">Bags & Cases</a></li>
<li><a href="../prom_items/bugs_bears.asp">Bugs & Bears</a></li>
<li><a href="../prom_items/novelties.asp">Novelties</a></li>
<li><a href="../prom_items/keyrings.asp">Keyrings</a></li>
<li><a href="../prom_items/note_pap.asp">Note Paper</a></li>
<li><a href="../prom_items/comp_acc.asp">Computer Accessories</a></li>
<li><a href="../prom_items/mugs.asp">Mugs</a></li>
<li> </li>
</ul>
</div></td>
<td colspan="7" align="left" valign="top"><!-- InstanceBeginEditable name="EditRegion1" -->
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td colspan="4" id="Headings"><div align="center">Gold Accessories </div></td>
</tr>
<tr>
<td width="43%"> 
<table border="0">
<tr>
<td>Name</td>
<td>Expr1</td>
</tr>
<% while ((Repeat1__numRows-- != 0) && (!rsGOLF.EOF)) { %>
<tr>
<td><%=(rsGOLF.Fields.Item("Name".Value)%></td>
<td><%=(rsGOLF.Fields.Item("Expr1".Value)%></td>
</tr>
<%
Repeat1__index++;
rsGOLF.MoveNext();
}
%>
</table></td>
<td width="49%"> </td>
<td width="4%"> </td>
<td width="4%"> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
</table>
<!-- InstanceEndEditable --></td>
</tr>
</table>
</td>
<td background="../images/bg_image.gif"> </td>
</tr>
</table>
</body>
<!-- InstanceEnd --></html>
<%
rsGOLF.Close();
%>

Replies


andy bertaut
Replied 11 Oct 2005 11:32:42
11 Oct 2005 11:32:42 andy bertaut replied:
I have looked further into it and it's happening no matter what kind of dynamic data i add to the page, a single piece or a full table...If anyone can help....

Michael Behan
Replied 11 Oct 2005 11:55:24
11 Oct 2005 11:55:24 Michael Behan replied:
I know this isn't a great deal of help to you but I can't see anything wrong with your code. Perhaps its someting to do with your default value for product code, are you expecting that if there is no parameters passed in the browser everything should be visible? If so maybe you could try changing the
var rsGOLF__MMColParam = "1"; to
var rsGOLF__MMColParam = "%";

Reply to this topic

Currency:
Company Info
Payment & Pricing
Legal Notices
Guides
Copyright © 2001-2024 Dynamic Zones International B.V., All Rights Reserved.