Question to Data Base Results Wizard Ouput

G

Guest

I am using the wizard to return records sets with a number of records that
can't be reasonably be viewed on a single page so I select the apolit records
into groups option on the last page of the wizard it works perfectly on:

http://www.inglemoorvikings.org/test/brian/seasonschedule.asp

I use the exact same process on several other pages and it says "No Records
"returned when you select arrow to go to the next page (example and I have
several):

http://www.inglemoorvikings.org/test/brian/SchedSystemSeason2.asp

Code generated by FP below:

Following works

<!--webbot bot="DatabaseRegionStart"
s-columnnames="Date,Away,Home,Level,Field,Time"
s-columntypes="202,202,202,202,202,135" s-dataconnection="Database5"
b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="Date"
s-menuvalue="Date" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource="SchedSeason"
s-displaycolumns="Date,Away,Home,Level,Field,Time" s-criteria s-order
s-sql="SELECT * FROM SchedSeason" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields s-norecordsfound="No records returned."
i-maxrecords="256" i-groupsize="15" 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
b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" --><!--#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 SchedSeason"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database5"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=15
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="Date"
fp_sMenuValue="Date"
fp_sColTypes="&Date=202&Away=202&Home=202&Level=202&Field=202&Time=135&"
fp_iDisplayCols=6
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="23601" --><tr>
<td bgcolor="#FFFFFF"><b>
<font size="2">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Away,Home,Level,Field,Time" s-column="Date"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="&lt;font size="-1">&lt;&lt;</font>Date<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Date")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="3267" --></font></b></td>
<td bgcolor="#FFFFFF"><b>
<font size="2">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Away,Home,Level,Field,Time" s-column="Away"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Away<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Away")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="5912" --></font></b></td>
<td bgcolor="#FFFFFF"><b>
<font size="2">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Away,Home,Level,Field,Time" s-column="Home"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Home<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Home")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="5308" --></font></b></td>
<td bgcolor="#FFFFFF"><b>
<font size="2">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Away,Home,Level,Field,Time" s-column="Level"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Level<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Level")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7765" --></font></b></td>
<td bgcolor="#FFFFFF"><b>
<font size="2">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Away,Home,Level,Field,Time" s-column="Field"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Field<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Field")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7858" --></font></b></td>
<td bgcolor="#FFFFFF"><b>
<font size="2">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="Date,Away,Home,Level,Field,Time" s-column="Time"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Time<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Time")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="5308" --></font></b></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="15"
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><TR><TD VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT
TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT
TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| ">
[1/15]</NOBR><BR></td></tr>" startspan --><!--#include
file="../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="65064" --></tbody>
</table>

Following Doesn't work

body>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time"
s-columntypes="202,2,202,202,202,202,202,202,135"
s-dataconnection="Database5" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice="System" s-menuvalue="System" b-tableborder="TRUE"
b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE"
s-recordsource="SchedSys"
s-displaycolumns="System,Date,Away,Home,Level,Field,Time" s-criteria s-order
s-sql="SELECT * FROM SchedSys" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields s-norecordsfound="No records returned."
i-maxrecords="256" i-groupsize="15" 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
b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" --><!--#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 SchedSys"
fp_sDefault=""
fp_sNoRecords="<tr><td colspan=7 align=""LEFT"" width=""100%"">No records
returned.</td></tr>"
fp_sDataConn="Database5"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=15
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="System"
fp_sMenuValue="System"
fp_sColTypes="&System=202&ID=2&Date=202&Away=202&Home=202&Level=202&lvl=202&Field=202&Time=135&"
fp_iDisplayCols=7
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--#include file="../../_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="7857" --><tr>
<td bgcolor="#FFFFFF"><b>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time"
s-column="System" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="&lt;font
size="-1">&lt;&lt;</font>System<font size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"System")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="17724" --></b></td>
<td bgcolor="#FFFFFF"><b>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time" s-column="Date"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Date<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Date")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="3267" --></b></td>
<td bgcolor="#FFFFFF"><b>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time" s-column="Away"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Away<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Away")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="5912" --></b></td>
<td bgcolor="#FFFFFF"><b>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time" s-column="Home"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Home<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Home")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="5308" --></b></td>
<td bgcolor="#FFFFFF"><b>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time"
s-column="Level" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Level<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Level")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7765" --></b></td>
<td bgcolor="#FFFFFF"><b>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time"
s-column="Field" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Field<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Field")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="7858" --></b></td>
<td bgcolor="#FFFFFF"><b>
<!--webbot bot="DatabaseResultColumn"
s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time" s-column="Time"
b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Time<font
size="-1">&gt;&gt;</font>" startspan
--><%=FP_FieldVal(fp_rs,"Time")%><!--webbot bot="DatabaseResultColumn"
endspan i-checksum="5308" --></b></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="15"
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><TR><TD VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT
TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT
TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| ">
[1/15]</NOBR><BR></td></tr>" startspan --><!--#include
file="../../_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" endspan i-checksum="65064" --></tbody>
</table>


Thank you in advance for your assistance

Bill (Bline)
 
S

Stefan B Rusynko

Seem to be working fine now on both pages

--




|I am using the wizard to return records sets with a number of records that
| can't be reasonably be viewed on a single page so I select the apolit records
| into groups option on the last page of the wizard it works perfectly on:
|
| http://www.inglemoorvikings.org/test/brian/seasonschedule.asp
|
| I use the exact same process on several other pages and it says "No Records
| "returned when you select arrow to go to the next page (example and I have
| several):
|
| http://www.inglemoorvikings.org/test/brian/SchedSystemSeason2.asp
|
| Code generated by FP below:
|
| Following works
|
| <!--webbot bot="DatabaseRegionStart"
| s-columnnames="Date,Away,Home,Level,Field,Time"
| s-columntypes="202,202,202,202,202,135" s-dataconnection="Database5"
| b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="Date"
| s-menuvalue="Date" b-tableborder="TRUE" b-tableexpand="TRUE"
| b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
| i-listformat="0" b-makeform="FALSE" s-recordsource="SchedSeason"
| s-displaycolumns="Date,Away,Home,Level,Field,Time" s-criteria s-order
| s-sql="SELECT * FROM SchedSeason" b-procedure="FALSE" clientside
| suggestedext="asp" s-defaultfields s-norecordsfound="No records returned."
| i-maxrecords="256" i-groupsize="15" 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
| b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
| b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" --><!--#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 SchedSeason"
| fp_sDefault=""
| fp_sNoRecords="<tr><td colspan=6 align=""LEFT"" width=""100%"">No records
| returned.</td></tr>"
| fp_sDataConn="Database5"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=15
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice="Date"
| fp_sMenuValue="Date"
| fp_sColTypes="&Date=202&Away=202&Home=202&Level=202&Field=202&Time=135&"
| fp_iDisplayCols=6
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
| %>
| <!--#include file="../../_fpclass/fpdbrgn1.inc"-->
| <!--webbot bot="DatabaseRegionStart" endspan i-checksum="23601" --><tr>
| <td bgcolor="#FFFFFF"><b>
| <font size="2">
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Date,Away,Home,Level,Field,Time" s-column="Date"
| b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| b-MenuFormat preview="&lt;font size="-1">&lt;&lt;</font>Date<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Date")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="3267" --></font></b></td>
| <td bgcolor="#FFFFFF"><b>
| <font size="2">
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Date,Away,Home,Level,Field,Time" s-column="Away"
| b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Away<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Away")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="5912" --></font></b></td>
| <td bgcolor="#FFFFFF"><b>
| <font size="2">
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Date,Away,Home,Level,Field,Time" s-column="Home"
| b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Home<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Home")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="5308" --></font></b></td>
| <td bgcolor="#FFFFFF"><b>
| <font size="2">
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Date,Away,Home,Level,Field,Time" s-column="Level"
| b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Level<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Level")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="7765" --></font></b></td>
| <td bgcolor="#FFFFFF"><b>
| <font size="2">
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Date,Away,Home,Level,Field,Time" s-column="Field"
| b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Field<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Field")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="7858" --></font></b></td>
| <td bgcolor="#FFFFFF"><b>
| <font size="2">
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="Date,Away,Home,Level,Field,Time" s-column="Time"
| b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Time<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Time")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="5308" --></font></b></td>
| </tr>
| <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
| b-menuformat="FALSE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="15"
| 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><TR><TD VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT
| TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT
| TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| ">
| [1/15]</NOBR><BR></td></tr>" startspan --><!--#include
| file="../../_fpclass/fpdbrgn2.inc"-->
| <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="65064" --></tbody>
| </table>
|
| Following Doesn't work
|
| body>
| <!--webbot bot="DatabaseRegionStart"
| s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time"
| s-columntypes="202,2,202,202,202,202,202,202,135"
| s-dataconnection="Database5" b-tableformat="TRUE" b-menuformat="FALSE"
| s-menuchoice="System" s-menuvalue="System" b-tableborder="TRUE"
| b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE"
| b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE"
| s-recordsource="SchedSys"
| s-displaycolumns="System,Date,Away,Home,Level,Field,Time" s-criteria s-order
| s-sql="SELECT * FROM SchedSys" b-procedure="FALSE" clientside
| suggestedext="asp" s-defaultfields s-norecordsfound="No records returned."
| i-maxrecords="256" i-groupsize="15" 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
| b-UseDotNET="FALSE" CurrentExt sa-InputTypes b-DataGridFormat="FALSE"
| b-DGridAlternate="TRUE" sa-CritTypes b-WasTableFormat="TRUE" --><!--#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 SchedSys"
| fp_sDefault=""
| fp_sNoRecords="<tr><td colspan=7 align=""LEFT"" width=""100%"">No records
| returned.</td></tr>"
| fp_sDataConn="Database5"
| fp_iMaxRecords=256
| fp_iCommandType=1
| fp_iPageSize=15
| fp_fTableFormat=True
| fp_fMenuFormat=False
| fp_sMenuChoice="System"
| fp_sMenuValue="System"
| fp_sColTypes="&System=202&ID=2&Date=202&Away=202&Home=202&Level=202&lvl=202&Field=202&Time=135&"
| fp_iDisplayCols=7
| fp_fCustomQuery=False
| BOTID=0
| fp_iRegion=BOTID
| %>
| <!--#include file="../../_fpclass/fpdbrgn1.inc"-->
| <!--webbot bot="DatabaseRegionStart" endspan i-checksum="7857" --><tr>
| <td bgcolor="#FFFFFF"><b>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time"
| s-column="System" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| clientside b-MenuFormat preview="&lt;font
| size="-1">&lt;&lt;</font>System<font size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"System")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="17724" --></b></td>
| <td bgcolor="#FFFFFF"><b>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time" s-column="Date"
| b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Date<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Date")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="3267" --></b></td>
| <td bgcolor="#FFFFFF"><b>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time" s-column="Away"
| b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Away<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Away")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="5912" --></b></td>
| <td bgcolor="#FFFFFF"><b>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time" s-column="Home"
| b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Home<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Home")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="5308" --></b></td>
| <td bgcolor="#FFFFFF"><b>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time"
| s-column="Level" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Level<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Level")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="7765" --></b></td>
| <td bgcolor="#FFFFFF"><b>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time"
| s-column="Field" b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE"
| clientside b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Field<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Field")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="7858" --></b></td>
| <td bgcolor="#FFFFFF"><b>
| <!--webbot bot="DatabaseResultColumn"
| s-columnnames="System,ID,Date,Away,Home,Level,lvl,Field,Time" s-column="Time"
| b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
| b-MenuFormat preview="<font size="-1">&lt;&lt;</font>Time<font
| size="-1">&gt;&gt;</font>" startspan
| --><%=FP_FieldVal(fp_rs,"Time")%><!--webbot bot="DatabaseResultColumn"
| endspan i-checksum="5308" --></b></td>
| </tr>
| <!--webbot bot="DatabaseRegionEnd" b-tableformat="TRUE"
| b-menuformat="FALSE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="15"
| 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><TR><TD VALIGN=MIDDLE COLSPAN=64><NOBR><INPUT
| TYPE=Button VALUE=" |< "><INPUT TYPE=Button VALUE=" < "><INPUT
| TYPE=Button VALUE=" > "><INPUT TYPE=Button VALUE=" >| ">
| [1/15]</NOBR><BR></td></tr>" startspan --><!--#include
| file="../../_fpclass/fpdbrgn2.inc"-->
| <!--webbot bot="DatabaseRegionEnd" endspan i-checksum="65064" --></tbody>
| </table>
|
|
| Thank you in advance for your assistance
|
| Bill (Bline)
|
|
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I am trying to understand this code... 3
Please help, FP generated code produces a "Too few parameters. Expected1" error! 7
Help with this calculation!!! 17
any ideas why I can update one table in my database but not the other? 2
DRW manual code 4
Database Results Error 1
DataBase results Error continued 1
@ my wits end 1

Top