J
John Cello
Working with code supplied by Jon Spivey, which has been extremely helpful. I
need to let the end user select the week start date, then populate text boxes
from that choice. I've tried several permutations of setting variables and
referring to the dropdown, with no luck. Any help would be appreciated. I'm
trying to use the value of a DRW dropdown (D1) to set the value of "Sunday"
(replacing sunday = cdate("03/06/2005") )in the following:
<html>
<head>
</head>
<body text="#000080">
<form name="F1">
<nobr>
<!--webbot bot="DatabaseRegionStart" s-columnnames="StartingSunday"
s-columntypes="135" s-dataconnection="X1" b-tableformat="FALSE"
b-menuformat="TRUE" s-menuchoice="StartingSunday"
s-menuvalue="StartingSunday" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource="qselWeekStart"
s-displaycolumns="StartingSunday" s-criteria s-order s-sql="SELECT * FROM
qselWeekStart" 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"
preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> " 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 qselWeekStart"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="X1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="StartingSunday"
fp_sMenuValue="StartingSunday"
fp_sColTypes="&StartingSunday=135&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="37529" --><select
NAME="D1" SIZE="1" style="font-family: Tahoma; font-size: 10pt; color:
#000080; font-weight: bold">
<!--webbot bot="AspInclude" clientside
u-incfile="../../_fpclass/fpdbrgn1.inc" startspan --><!--#include
file="../../_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan
i-checksum="64934" -->
<option><%=FP_FieldHTML(fp_rs,"StartingSunday")%></option>
<!--webbot bot="AspInclude" clientside
u-incfile="../../_fpclass/fpdbrgn2.inc" startspan --><!--#include
file="../../_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan
i-checksum="64936" -->
</select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="TRUE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> " startspan --><!--webbot
bot="DatabaseRegionEnd" endspan --></nobr></form>
<div align="left">
<table border="0" width="288" id="table1">
<tr>
<td width="98"><font color="#000080" face="Tahoma">
SUNDAY</font></td>
<td><font color="#000080" face="Tahoma">
<input name="T1" size="10" value="<%
sunday = cdate("03/06/2005")
for i = 1 to 1
response.write sunday
next
%>
" style="font-weight: 700"></font></td>
</tr>
<tr>
<td width="98"><font color="#000080" face="Tahoma">
MONDAY</font></td>
<td><font color="#000080" face="Tahoma">
<input name="T2" size="20" value="<%
sunday = cdate("03/06/2005")
for i = 1 to 1
response.write sunday + i
next
%>
" style="font-weight: 700"></font></td>
</tr>
</table>
</div>
</body>
</html>
need to let the end user select the week start date, then populate text boxes
from that choice. I've tried several permutations of setting variables and
referring to the dropdown, with no luck. Any help would be appreciated. I'm
trying to use the value of a DRW dropdown (D1) to set the value of "Sunday"
(replacing sunday = cdate("03/06/2005") )in the following:
<html>
<head>
</head>
<body text="#000080">
<form name="F1">
<nobr>
<!--webbot bot="DatabaseRegionStart" s-columnnames="StartingSunday"
s-columntypes="135" s-dataconnection="X1" b-tableformat="FALSE"
b-menuformat="TRUE" s-menuchoice="StartingSunday"
s-menuvalue="StartingSunday" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource="qselWeekStart"
s-displaycolumns="StartingSunday" s-criteria s-order s-sql="SELECT * FROM
qselWeekStart" 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"
preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Database</span> " 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 qselWeekStart"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="X1"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="StartingSunday"
fp_sMenuValue="StartingSunday"
fp_sColTypes="&StartingSunday=135&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="37529" --><select
NAME="D1" SIZE="1" style="font-family: Tahoma; font-size: 10pt; color:
#000080; font-weight: bold">
<!--webbot bot="AspInclude" clientside
u-incfile="../../_fpclass/fpdbrgn1.inc" startspan --><!--#include
file="../../_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan
i-checksum="64934" -->
<option><%=FP_FieldHTML(fp_rs,"StartingSunday")%></option>
<!--webbot bot="AspInclude" clientside
u-incfile="../../_fpclass/fpdbrgn2.inc" startspan --><!--#include
file="../../_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan
i-checksum="64936" -->
</select><!--webbot bot="DatabaseRegionEnd" b-tableformat="FALSE"
b-menuformat="TRUE" u-dbrgn2="../../_fpclass/fpdbrgn2.inc" i-groupsize="0"
clientside preview=" <span style="color: rgb(0,0,0); background-color:
rgb(255,255,0)">Results</span> " startspan --><!--webbot
bot="DatabaseRegionEnd" endspan --></nobr></form>
<div align="left">
<table border="0" width="288" id="table1">
<tr>
<td width="98"><font color="#000080" face="Tahoma">
SUNDAY</font></td>
<td><font color="#000080" face="Tahoma">
<input name="T1" size="10" value="<%
sunday = cdate("03/06/2005")
for i = 1 to 1
response.write sunday
next
%>
" style="font-weight: 700"></font></td>
</tr>
<tr>
<td width="98"><font color="#000080" face="Tahoma">
MONDAY</font></td>
<td><font color="#000080" face="Tahoma">
<input name="T2" size="20" value="<%
sunday = cdate("03/06/2005")
for i = 1 to 1
response.write sunday + i
next
%>
" style="font-weight: 700"></font></td>
</tr>
</table>
</div>
</body>
</html>