|
Server : Apache/2.4.62 System : FreeBSD fbsdweb2.web.rcn.net 14.1-RELEASE FreeBSD 14.1-RELEASE releng/14.1-n267679-10e31f0946d8 GENERIC amd64 User : www ( 80) PHP Version : 8.3.8 Disable Function : NONE Directory : /domains/antiqueweb1/david/ |
Upload File : |
<html>
<head>
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>My Sales</title>
</head>
<body bgcolor="#FFFFFF"><table border="0" width="100%" bgcolor="#008000" height="13">
<tr>
<td width="100%" height="106">
<p align="center"><font color="#FFFFFF"><b><font size="7">My Sales</font></b></font>
<p align="center"><font color="#FFFFFF">October 1st 2020 - October 15th 2020</font></td>
</tr>
</table>
<table border="1" width="100%" bgcolor="#FFFFCC" cellspacing="1" height="64">
<tr>
<td width="16%" bgcolor="#FFFFCC" height="58">
<p align="center"><b><a href="index.htm"><font size="4" face="Arial" color="#008000">Home</font></a></b></p>
</td>
<td width="6%" bgcolor="#FFFFCC" height="58">
<p align="center"> </p>
</td>
<td width="5%" bgcolor="#FFFFCC" height="58">
<p align="center"> </p>
</td>
<td width="61%" bgcolor="#FFFFCC" height="58">
<p align="center"> </p>
</td>
<td width="12%" bgcolor="#FFFFCC" height="58">
<p align="center"><b><font size="4" face="Arial"><a href="dealersales.htm"><font color="#008000">Dealers'
Sale</font></a></font></b></p>
</td>
</tr>
</table>
<form BOTID="0" METHOD="POST" ACTION="current.asp">
<p> </p>
<p> </p>
<table BORDER="0">
<tr>
<td><b><span style="background-color: #FFFFFF">BOOTH</span></b></td>
<td>
<p><span style="background-color: #FFFFFF"><input NAME="BOOTH" VALUE="<%=Request()%>" size="29"></span></p>
</td>
</tr>
<tr>
<td><b>PASSWORD</b></td>
<td><input TYPE="password" NAME="PASSWORD" VALUE="<%=Request()%>" size="20"> </td>
</tr>
</table>
<p>
<br>
<input TYPE="Submit"><input TYPE="Reset"> <!--webbot bot="SaveAsASP" CLIENTSIDE
SuggestedExt="asp" PREVIEW=" " -->
</p>
<p> </p>
</form>
<table width="687" border="1" height="129">
<thead>
<tr>
<td height="19" width="650"><b>MY SALES THROUGH</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="ID,BOOTH,PASSWORD,MY SALES THROUGH"
s-columntypes="3,3,202,135" s-dataconnection="october15connection"
b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="MY SALES THROUGH" s-menuvalue="MY SALES THROUGH"
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
b-makeform="TRUE" s-recordsource="datetable"
s-displaycolumns="MY SALES THROUGH"
s-criteria="{BOOTH} EQ {BOOTH} + [PASSWORD] EQ {PASSWORD} +" s-order
s-sql="SELECT * FROM datetable WHERE (BOOTH = ::BOOTH:: AND PASSWORD = '::PASSWORD::')"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="BOOTH=999&PASSWORD=999"
s-NoRecordsFound="No records returned." i-MaxRecords="256" i-GroupSize="0"
BOTID="3" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server with a web browser. The following table row will repeat once for every record returned by the query.</font></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-WasTableFormat="TRUE" --><!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM datetable WHERE (BOOTH = ::BOOTH:: AND PASSWORD = '::PASSWORD::')"
fp_sDefault="BOOTH=999&PASSWORD=999"
fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="october15connection"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="MY SALES THROUGH"
fp_sMenuValue="MY SALES THROUGH"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=3
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" i-CheckSum="23174" endspan -->
<tr>
<td height="19" width="650"><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="ID,BOOTH,PASSWORD,MY SALES THROUGH"
s-column="MY SALES THROUGH" b-tableformat="TRUE" b-hasHTML="FALSE"
clientside
local_preview="<font size="-1">&lt;&lt;</font>MY SALES THROUGH<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>MY SALES THROUGH<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"MY SALES THROUGH")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="29344" endspan -->
</td>
</tr>
<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" i-CheckSum="62730" endspan -->
</tbody>
</table><table width="687" border="1" height="123">
<thead>
<tr>
<td width="650" height="19"><b>TOTAL SALES</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="PASSWORD,BOOTH,TOTAL SALES" s-columntypes="202,3,5"
s-dataconnection="october15connection" b-tableformat="TRUE" b-menuformat="FALSE"
s-menuchoice="TOTAL SALES" s-menuvalue="TOTAL SALES" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-ListFormat="0" b-makeform="TRUE" s-recordsource="sum"
s-displaycolumns="TOTAL SALES"
s-criteria="{BOOTH} EQ {BOOTH} + [PASSWORD] EQ {PASSWORD} +" s-order
s-sql="SELECT * FROM totals WHERE (BOOTH = ::BOOTH:: AND PASSWORD = '::PASSWORD::')"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="BOOTH=999&PASSWORD=999"
s-NoRecordsFound="No records returned." i-MaxRecords="256" i-GroupSize="0"
BOTID="1" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server with a web browser. The following table row will repeat once for every record returned by the query.</font></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-WasTableFormat="TRUE" --><!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM totals WHERE (BOOTH = ::BOOTH:: AND PASSWORD = '::PASSWORD::')"
fp_sDefault="BOOTH=999&PASSWORD=999"
fp_sNoRecords="<tr><td colspan=1 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="october15connection"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="TOTAL SALES"
fp_sMenuValue="TOTAL SALES"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" i-CheckSum="12334" endspan -->
<tr>
<td width="650" height="19"> <%=FormatCurrency(FP_FieldVal(fp_rs,"TOTAL SALES"))%></td>
</tr>
<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" i-CheckSum="62730" endspan -->
</tbody>
</table>
<form BOTID="2" METHOD="POST" ACTION="current.asp">
<table BORDER="0">
<tr>
<td></td>
<td></td>
</tr>
<tr>
<td></td>
<td></td>
</tr>
</table>
</form>
<table width="686" border="1" height="125">
<thead>
<tr>
<td height="19" width="82"><b>DSOLD</b></td>
<td height="19" width="110"><b>STKNUM</b></td>
<td height="19" width="202"><b>ITEMDESC</b></td>
<td height="19" width="178"><b>PRICE</b></td>
<td height="19" width="80"><b>SWhere</b></td>
</tr>
</thead>
<tbody>
<!--webbot bot="DatabaseRegionStart" startspan
s-columnnames="DSOLD,STKNUM,ITEMDESC,SWhere,PRICE,PASSWORD,BOOTH"
s-columntypes="135,202,202,202,5,202,3" s-dataconnection="october15connection"
b-tableformat="TRUE" b-menuformat="FALSE" s-menuchoice="DSOLD" s-menuvalue="DSOLD"
b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE"
b-listlabels="TRUE" b-listseparator="TRUE" i-ListFormat="0"
b-makeform="TRUE" s-recordsource="list"
s-displaycolumns="DSOLD,STKNUM,ITEMDESC,PRICE,SWhere"
s-criteria="{BOOTH} EQ {BOOTH} + [PASSWORD] EQ {PASSWORD} +"
s-order="[DSOLD] +"
s-sql="SELECT * FROM list WHERE (BOOTH = ::BOOTH:: AND PASSWORD = '::PASSWORD::') ORDER BY DSOLD ASC"
b-procedure="FALSE" clientside SuggestedExt="asp"
s-DefaultFields="BOOTH=999&PASSWORD=999"
s-NoRecordsFound="No records returned." i-MaxRecords="256" i-GroupSize="0"
BOTID="2" u-dblib="_fpclass/fpdblib.inc" u-dbrgn1="_fpclass/fpdbrgn1.inc"
u-dbrgn2="_fpclass/fpdbrgn2.inc" tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">Database Results regions will not preview unless this page is fetched from a Web server with a web browser. The following table row will repeat once for every record returned by the query.</font></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the start of a Database Results region.</font></td></tr>" b-WasTableFormat="TRUE" --><!--#include file="_fpclass/fpdblib.inc"-->
<%
fp_sQry="SELECT * FROM list WHERE (BOOTH = ::BOOTH:: AND PASSWORD = '::PASSWORD::') ORDER BY DSOLD ASC"
fp_sDefault="BOOTH=999&PASSWORD=999"
fp_sNoRecords="<tr><td colspan=5 align=left width=""100%"">No records returned.</td></tr>"
fp_sDataConn="october15connection"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=True
fp_fMenuFormat=False
fp_sMenuChoice="DSOLD"
fp_sMenuValue="DSOLD"
fp_iDisplayCols=5
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<!--#include file="_fpclass/fpdbrgn1.inc"-->
<!--webbot bot="DatabaseRegionStart" i-CheckSum="33002" endspan -->
<tr>
<td height="19" width="82"><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="DSOLD,STKNUM,ITEMDESC,SWhere,PRICE,PASSWORD,BOOTH"
s-column="DSOLD" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>DSOLD<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>DSOLD<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"DSOLD")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="4700" endspan -->
</td>
<td height="19" width="110"><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="DSOLD,STKNUM,ITEMDESC,SWhere,PRICE,PASSWORD,BOOTH"
s-column="STKNUM" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>STKNUM<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>STKNUM<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"STKNUM")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="12552" endspan -->
</td>
<td height="19" width="202"><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="DSOLD,STKNUM,ITEMDESC,SWhere,PRICE,PASSWORD,BOOTH"
s-column="ITEMDESC" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>ITEMDESC<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>ITEMDESC<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"ITEMDESC")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="10669" endspan -->
</td>
<td height="19" width="178"> <%=FormatCurrency(FP_FieldVal(fp_rs,"PRICE"))%>
</td>
<td height="19" width="80"><!--webbot bot="DatabaseResultColumn" startspan
s-columnnames="DSOLD,STKNUM,ITEMDESC,SWhere,PRICE,PASSWORD,BOOTH"
s-column="SWhere" b-tableformat="TRUE" b-hasHTML="FALSE" clientside
local_preview="<font size="-1">&lt;&lt;</font>SWhere<font size="-1">&gt;&gt;</font>"
preview="<font size="-1">&lt;&lt;</font>SWhere<font size="-1">&gt;&gt;</font>" --><%=FP_FieldVal(fp_rs,"SWhere")%><!--webbot
bot="DatabaseResultColumn" i-CheckSum="13319" endspan -->
</td>
</tr>
<!--webbot bot="DatabaseRegionEnd" startspan b-tableformat="TRUE"
b-menuformat="FALSE" u-dbrgn2="_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside tag="TBODY"
local_preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>"
preview="<tr><td colspan=64 bgcolor="#FFFF00" align="left" width="100%"><font color="#000000">This is the end of a Database Results region.</font></td></tr>" --><!--#include file="_fpclass/fpdbrgn2.inc"-->
<!--webbot bot="DatabaseRegionEnd" i-CheckSum="62730" endspan -->
</tbody>
</table>
</body>
</html>