adam2804
Posts: 34
Joined: 6/6/2006
Status: offline
 |
DRW only showing first three records?! - 7/26/2006 5:12:16
Hello people,
This is a strange one. I've put in a DRW onto a new asp page but when I test it, it only shows the first 3 records maximum (If i try SELECT TOP 2 or SELECT TOP 1 then the results will show first 2 or first 1 record) but if I try just SELECT then it shows only the top 3. In SQL server using exactly the same query it comes back with 8 records (Which is what I want to show).
I've shown the code below, has anyone experienced this before or understand why this is happening?
<table>
<thead>
<tr>
<th ALIGN="LEFT"><b>ContractNum</b></th>
<th ALIGN="LEFT"><b>ContractStart</b></th>
<th ALIGN="LEFT"><b>ContractEnd</b></th>
<th ALIGN="LEFT"><b>ContractValue</b></th>
<th ALIGN="LEFT"><b>ContractNumberOfPayments</b></th>
<th ALIGN="LEFT"><b>TASCode</b></th>
<th ALIGN="LEFT"><b>Payment</b></th>
<th ALIGN="LEFT"><b>Description</b></th>
<th ALIGN="LEFT"><b>InvoicedToTAS</b></th>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" s-columnnames="ContractNum,ContractStart,ContractEnd,ContractValue,ContractNumberOfPayments,TASCode,Payment,Description,InvoicedToTAS" s-columntypes="200,135,135,131,3,200,200,200,11" s-dataconnection="database" b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="ContractNum" s-menuvalue="ContractNum" b-tableborder="FALSE" b-tableexpand="FALSE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource s-displaycolumns="ContractNum,ContractStart,ContractEnd,ContractValue,ContractNumberOfPayments,TASCode,Payment,Description,InvoicedToTAS" s-criteria s-order s-sql="SELECT ContractNum, ContractStart, ContractEnd, ContractValue, ContractNumberOfPayments, TASCode, CAST(PaymentNumber AS VARCHAR(5)) <br> + '/' + CAST(ContractNumberOfPayments AS VARCHAR(5)) AS Payment, Description, InvoicedToTAS AS InvoicedToTAS<br>FROM dbo.FN_InvoiceList(DEFAULT) FN_InvoiceList<br>WHERE (InvoiceDate > CONVERT(DATETIME, '2006-07-01 00:00:00', 102)) AND (InvoiceDate < CONVERT(DATETIME, '2006-07-31 00:00:00', 102))" 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>" b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE" b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" 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 ContractNum, ContractStart, ContractEnd, ContractValue, ContractNumberOfPayments, TASCode, CAST(PaymentNumber AS VARCHAR(5)) + '/' + CAST(ContractNumberOfPayments AS VARCHAR(5)) AS Payment, Description, InvoicedToTAS AS InvoicedToTAS FROM dbo.FN_InvoiceList(DEFAULT) FN_InvoiceList WHERE (InvoiceDate > CONVERT(DATETIME, '2006-07-01 00:00:00', 102)) AND (InvoiceDate < CONVERT(DATETIME, '2006-07-31 00:00:00', 102))"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=9 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="ContractNum"
fp_sMenuValue="ContractNum"
fp_sColTypes="&ContractNum=200&ContractStart=135&ContractEnd=135&ContractValue=131&ContractNumberOfPayments=3&TASCode=200&Payment=200&Description=200&InvoicedToTAS=11&"
fp_iDisplayCols=9
fp_fCustomQuery=True
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="43604" --><tr>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ContractNum,ContractStart,ContractEnd,ContractValue,ContractNumberOfPayments,TASCode,Payment,Description,InvoicedToTAS" s-column="ContractNum" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ContractNum<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ContractNum")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="30104" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ContractNum,ContractStart,ContractEnd,ContractValue,ContractNumberOfPayments,TASCode,Payment,Description,InvoicedToTAS" s-column="ContractStart" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ContractStart<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ContractStart")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="35536" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ContractNum,ContractStart,ContractEnd,ContractValue,ContractNumberOfPayments,TASCode,Payment,Description,InvoicedToTAS" s-column="ContractEnd" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ContractEnd<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ContractEnd")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="28623" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ContractNum,ContractStart,ContractEnd,ContractValue,ContractNumberOfPayments,TASCode,Payment,Description,InvoicedToTAS" s-column="ContractValue" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ContractValue<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ContractValue")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="33253" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ContractNum,ContractStart,ContractEnd,ContractValue,ContractNumberOfPayments,TASCode,Payment,Description,InvoicedToTAS" s-column="ContractNumberOfPayments" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>ContractNumberOfPayments<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"ContractNumberOfPayments")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="1368" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ContractNum,ContractStart,ContractEnd,ContractValue,ContractNumberOfPayments,TASCode,Payment,Description,InvoicedToTAS" s-column="TASCode" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>TASCode<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"TASCode")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="8424" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ContractNum,ContractStart,ContractEnd,ContractValue,ContractNumberOfPayments,TASCode,Payment,Description,InvoicedToTAS" s-column="Payment" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Payment<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Payment")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="12666" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ContractNum,ContractStart,ContractEnd,ContractValue,ContractNumberOfPayments,TASCode,Payment,Description,InvoicedToTAS" s-column="Description" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>Description<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"Description")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="30092" --></td>
<td>
<!--webbot bot="DatabaseResultColumn" s-columnnames="ContractNum,ContractStart,ContractEnd,ContractValue,ContractNumberOfPayments,TASCode,Payment,Description,InvoicedToTAS" s-column="InvoicedToTAS" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat preview="<font size="-1"><<</font>InvoicedToTAS<font size="-1">>></font>" startspan --><%=FP_FieldVal(fp_rs,"InvoicedToTAS")%><!--webbot bot="DatabaseResultColumn" endspan i-checksum="34471" --></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>
Thanks,
Adam
|
Printable Version 
New Messages
No New Messages
Hot Topic w/ New Messages
Hot Topic w/o New Messages
Locked w/ New Messages
Locked w/o New Messages
Post New Thread