Results showing limited results

	Home Register Search Help Login

Sponsors

Hosting from $3.99 per month!

Shopping Cart Software
Ecommerce software integrated into Frontpage, Dreamweaver and Golive templates. No monthly fees and available in ASP and PHP versions. dd

Website Templates
We also have a wide selection of Dreamweaver, Expression Web and Frontpage templates as well as webmaster tools and CSS layouts.

Frontpage website templates
Creative Website Templates for FrontPage, Dreamweaver, Flash, SwishMax

Search Forums

Recent Posts

Todays Posts
Most Active posts
Posts since last visit
My Recent Posts
Mark posts read

Results showing limited results

View related threads: (in this forum | in all forums)

Logged in as: Guest

Users viewing this topic: none

Printable Version

All Forums >> Web Development >> ASP and Database >> Results showing limited results

Page: [1]

adam2804

Posts: 34
Joined: 6/6/2006
Status: offline

Results showing limited results - 8/29/2006 9:37:11

Hello all,

I have a results wizard that I seem to be having problems with. I'm only getting a limited number of results showing for a query that I have created (38 where there should be 200+), (6 where there should be 30+), etc. I have tried raw coding the query in the page itself, and I have also tried using a view instead of a query.

Has anyone experienced anything like this before and could recommend anything to fix this problem? It's frustrating the hell out of me!

There is also a small problem of the page itself with a long delay in updating the changes when I try to view them through explorer. Sometimes its instant, but other times it's taking upwards of 30 minutes. Any ideas welcome.

Thanks,

Adam

If you're interested here's the complete code used on the page in question:

<html>

<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Invoice Management</title>
<style>
<!--
 li.MsoNormal
	{mso-style-parent:"";
	margin-bottom:.0001pt;
	font-size:10.0pt;
	font-family:"Times New Roman";
	margin-left:0cm; margin-right:0cm; margin-top:0cm}
-->
</style>


<meta name="Microsoft Theme" content="none, default">
<meta name="Microsoft Border" content="none, default">
</head>

<body>



<p><b><font size="6">Invoice Management</font></b></p>
<form method="POST" action="--WEBBOT-SELF--">
	<!--webbot bot="SaveResults" U-File="../../_private/form_results.csv" S-Format="TEXT/CSV" S-Label-Fields="TRUE" -->
	<p><input type="text" name="date" size="20" value="01/07/2006"><input type="submit" value="Submit" name="B1"><input type="reset" value="Reset" name="B2"></p>
</form>
<table width="100%" border="1">
	<thead>
		<tr>
			<th ALIGN="LEFT"><b>Expr1</b></th>
			<th ALIGN="LEFT"><b>SupportContract_ID</b></th>
			<th ALIGN="LEFT"><b>Customer</b></th>
			<th ALIGN="LEFT"><b>ContractNumber</b></th>
			<th ALIGN="LEFT"><b>EndDate</b></th>
			<th ALIGN="LEFT"><b>ContractValue</b></th>
			<th ALIGN="LEFT"><b>InvoiceDays</b></th>
			<th ALIGN="LEFT"><b>NoOfPayments</b></th>
			<th ALIGN="LEFT"><b>InvoiceValue</b></th>
			<th ALIGN="LEFT"><b>InvoiceDate</b></th>
			<th ALIGN="LEFT"><b>PaymentNumber</b></th>
		</tr>
	</thead>
	<tbody>
		<!--webbot bot="DatabaseRegionStart" s-columnnames="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-columntypes="135,3,200,200,135,131,3,3,131,135,3" s-dataconnection="database" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice s-menuvalue b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="V_Test_DB" s-displaycolumns="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-criteria s-order s-sql="SELECT * FROM V_Test_DB" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields s-norecordsfound="No records returned." i-maxrecords="256" i-groupsize="0" botid="0" u-dblib="../../_fpclass/fpdblib.inc" u-dbrgn1="../../_fpclass/fpdbrgn1.inc" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" startspan --><!--#include file="../../_fpclass/fpdblib.inc"-->
<% if 0 then %>
<SCRIPT Language="JavaScript">
document.write("<div style='background: yellow; color: black;'>The Database Results component on this page is unable to display database content. The page must have a filename ending in '.asp', and the web must be hosted on a server that supports Active Server Pages.</div>");
</SCRIPT>
<% end if %>
<%
fp_sQry="SELECT * FROM V_Test_DB"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=11 align=""LEFT"" width=""100%"">No records returned.</td></tr>"
fp_sDataConn="database"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice=""
fp_sMenuValue=""
fp_sColTypes="&Expr1=135&SupportContract_ID=3&Customer=200&ContractNumber=200&EndDate=135&ContractValue=131&InvoiceDays=3&NoOfPayments=3&InvoiceValue=131&InvoiceDate=135&PaymentNumber=3&"
fp_iDisplayCols=11
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="42325" --><tr>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-column="Expr1" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Expr1<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Expr1")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="9533" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-column="SupportContract_ID" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>SupportContract_ID<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"SupportContract_ID")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="50861" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-column="Customer" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Customer<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"Customer")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="16917" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-column="ContractNumber" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ContractNumber<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"ContractNumber")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="42256" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-column="EndDate" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>EndDate<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"EndDate")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="13315" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-column="ContractValue" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>ContractValue<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"ContractValue")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="33253" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-column="InvoiceDays" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>InvoiceDays<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"InvoiceDays")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="30568" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-column="NoOfPayments" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>NoOfPayments<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"NoOfPayments")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="33074" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-column="InvoiceValue" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>InvoiceValue<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"InvoiceValue")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="31204" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-column="InvoiceDate" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>InvoiceDate<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"InvoiceDate")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="29914" --></td>
			<td>
			<!--webbot bot="DatabaseResultColumn" s-columnnames="Expr1,SupportContract_ID,Customer,ContractNumber,EndDate,ContractValue,InvoiceDays,NoOfPayments,InvoiceValue,InvoiceDate,PaymentNumber" s-column="PaymentNumber" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>PaymentNumber<font size="-1">&gt;&gt;</font>" startspan --><%=FP_FieldVal(fp_rs,"PaymentNumber")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="34928" --></td>
		</tr>
		<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE" b-menuformat="FALSE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="0" clientside tag="TBODY" preview="<tr><td colspan=64 bgcolor="#FFFF00" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" startspan --><!--#include file="../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="65064" --></tbody>
</table>
</body>

</html>


BeTheBall Posts: 6385 Joined: 6/21/2002 From: West Point Utah USA Status: offline	RE: Results showing limited results - 8/29/2006 9:57:24 I have seen it. Usually, there is something wrong with the next record. Meaning, when you see 38 out of 200+, something is wrong with what should be record 39 (or record 7 out of 30+). Check for characters that may cause a problem, i.e., single quote, double quote or ampersand. _____________________________ Duane Some people are like Slinkies . . . Not really good for anything . . . . . But they still bring a smile to your face when you push them down a flight of stairs. (in reply to adam2804)


adam2804 Posts: 34 Joined: 6/6/2006 Status: offline	RE: Results showing limited results - 8/29/2006 10:34:02 Yeah, I thought that initially, so I checked out the results with a fine tooth comb, but can't seem to see anything glaringly obvious. So I tested it by choosing a record where it had only shown partial results (the record in question should have 4 items, but in the main list it stopped showing after 2) so I queried the specific contract number and re-ran the webpage, and all 4 are shown, which would suggest nothing is wrong with the record itself. Is there any other reason that the results might not be showing in their entirety? Thanks, Adam (in reply to BeTheBall)


Spooky Posts: 26617 Joined: 11/11/1998 From: Middle Earth Status: offline	RE: Results showing limited results - 8/30/2006 2:10:41 A few things to try #1 Spooky diet #2 OLEDB connection #3 I wouldnt use a view to start with, but test a query with the table You are using SQL server? _____________________________ If you arent part of the solution, then there is good money to be made prolonging the problem ��k� Database / DRW help Check out the Tutorials for Frontpage Databases Forum FAQ' s Developers Edition Spooky Login User Registration and Management tool Personalized Frontpage Hosting (in reply to adam2804)


adam2804 Posts: 34 Joined: 6/6/2006 Status: offline	RE: Results showing limited results - 8/30/2006 4:29:19 I've tried a query with the spooky diet which gave me more results than using a wizard (but still not the amount that there should be!). When you say the OLEDB connection, what imparticular should I be looking for? Thanks Adam (in reply to Spooky)