C
Chris van den Heever
"<td>
<b>Province</b></td><td>
<input TYPE="TEXT" NAME="Province"
VALUE="<%=Server.HtmlEncode(Request("Province"))%>"></td><td>
<nobr>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ID,Province,Remote_computer_name,User_name,Browser_type,Times
tamp" s-columntypes="3,202,202,202,202,135" s-dataconnection="areaselection"
b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="Province"
s-menuvalue="Province" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource="Province"
s-displaycolumns="Province" s-criteria s-order="[Province] +" s-sql="SELECT
* FROM Province ORDER BY Province ASC" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields 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" 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 Province ORDER BY Province ASC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="areaselection"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Province"
fp_sMenuValue="Province"
fp_sColTypes="&ID=3&Province=202&Remote_computer_name=202&User_name=202&Brow
ser_type=202&Timestamp=135&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="8449" --><select
NAME="Province" SIZE="1"><!--webbot bot="AspInclude" clientside
u-incfile="_fpclass/fpdbrgn1.inc" startspan --><!--#include
file="_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan
i-checksum="62210" -->
<option><%=FP_FieldHTML(fp_rs,"Province")%></option>
<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn2.inc"
startspan --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot
bot="AspInclude" endspan i-checksum="62218" --></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></td></tr></table><br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
clientside suggestedext="asp" preview=" " --><p>"
I wonder if anybody can help me I would like to set the selected info in the
dropdown box and the parameter for the database search
<b>Province</b></td><td>
<input TYPE="TEXT" NAME="Province"
VALUE="<%=Server.HtmlEncode(Request("Province"))%>"></td><td>
<nobr>
<!--webbot bot="DatabaseRegionStart"
s-columnnames="ID,Province,Remote_computer_name,User_name,Browser_type,Times
tamp" s-columntypes="3,202,202,202,202,135" s-dataconnection="areaselection"
b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="Province"
s-menuvalue="Province" b-tableborder="TRUE" b-tableexpand="TRUE"
b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE"
i-listformat="0" b-makeform="FALSE" s-recordsource="Province"
s-displaycolumns="Province" s-criteria s-order="[Province] +" s-sql="SELECT
* FROM Province ORDER BY Province ASC" b-procedure="FALSE" clientside
suggestedext="asp" s-defaultfields 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" 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 Province ORDER BY Province ASC"
fp_sDefault=""
fp_sNoRecords="No records returned."
fp_sDataConn="areaselection"
fp_iMaxRecords=256
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Province"
fp_sMenuValue="Province"
fp_sColTypes="&ID=3&Province=202&Remote_computer_name=202&User_name=202&Brow
ser_type=202&Timestamp=135&"
fp_iDisplayCols=1
fp_fCustomQuery=False
BOTID=1
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="8449" --><select
NAME="Province" SIZE="1"><!--webbot bot="AspInclude" clientside
u-incfile="_fpclass/fpdbrgn1.inc" startspan --><!--#include
file="_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan
i-checksum="62210" -->
<option><%=FP_FieldHTML(fp_rs,"Province")%></option>
<!--webbot bot="AspInclude" clientside u-incfile="_fpclass/fpdbrgn2.inc"
startspan --><!--#include file="_fpclass/fpdbrgn2.inc"--><!--webbot
bot="AspInclude" endspan i-checksum="62218" --></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></td></tr></table><br>
<input TYPE="Submit"><input TYPE="Reset"><!--webbot bot="SaveAsASP"
clientside suggestedext="asp" preview=" " --><p>"
I wonder if anybody can help me I would like to set the selected info in the
dropdown box and the parameter for the database search