|
wlp -> RE: Drop down Boxes "None" value (3/28/2002 13:51:37)
|
Thanks actually What I did was I added a line inthe DRW above the code which is retrieving the data and then entered nothing in the value submittedd box. here is the code.
<td width="30%" align="right" height="19" bgcolor="#CCCCCC" style="border-style: solid; border-width: 1; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1">
<font size="1">(<a target="_self" href="Cinema_Quick_Entry_manager.asp">New</a>)</font><font size="2"><b> Manager:</b></font></td>
<td width="22%" height="19" bgcolor="#CCCCCC" style="border-style: solid; border-width: 1; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1">
<nobr>
<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,First_Name,Last_Name,Company,Job_Title,Street,City,State,Postal_Code,Country,Fax,Phone,Cel,Categories,artist,Email,Email_Display_Name,Links_1,Links_1_Name,Display,Date_entered,Notes,Remote_computer_name,User_name,Browser_type,Timestamp" s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,3,202,202,202,202,202,135,202,202,202,202,135" s-dataconnection="celebrity" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="Last_Name" s-menuvalue="ID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="Managers" s-displaycolumns="ID,Last_Name" s-criteria="[Last_Name] CNT {Last_Name} + [First_Name] CNT {First_Name} +" s-order="[Last_Name] +" s-sql="SELECT * FROM Managers WHERE (Last_Name LIKE '%::Last_Name::%' AND First_Name LIKE '%::First_Name::%') ORDER BY Last_Name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Last_Name=&First_Name=" s-norecordsfound="No records returned." i-maxrecords="0" 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 b-InForm="TRUE" b-WasTableFormat="FALSE" --><!--#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 Managers WHERE (Last_Name LIKE '%::Last_Name::%' AND First_Name LIKE '%::First_Name::%') ORDER BY Last_Name ASC"
fp_sDefault="Last_Name=&First_Name="
fp_sNoRecords="No records returned."
fp_sDataConn="celebrity"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Last_Name"
fp_sMenuValue="ID"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=0
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="40310" --><select NAME="Manager" SIZE="1">
<option selected value="1">---None---</option>
<!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn1.inc" startspan --><!--#include file="../_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52766" -->
<option VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>">
<%=FP_FieldHTML(fp_rs,"Last_Name")%>, <%=FP_FieldHTML(fp_rs,"First_Name")%></option>
<!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn2.inc" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52830" -->
</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>
<td width="9%" height="19" bgcolor="#CCCCCC" style="border-style: solid; border-width: 1; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1"> </td>
<td width="45%" height="19" bgcolor="#CCCCCC" style="border-style: solid; border-width: 1; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1"> </td>
</tr>
<tr>
<td width="30%" align="right" height="22" bgcolor="#CCCCCC" style="border-style: solid; border-width: 1; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1">
<font size="1">(<a target="_self" href="Cinema_Quick_Entry_agent.asp">New</a>)</font><b><font size="2"> Agent:</font></b></td>
<td width="22%" height="22" bgcolor="#CCCCCC" style="border-style: solid; border-width: 1; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1">
<nobr>
<!--webbot bot="DatabaseRegionStart" s-columnnames="ID,First_Name,Last_Name,Company,Job_Title,Street,City,State,Postal_Code,Country,Fax,Phone,Cel,Categories,Email,Email_Display_Name,artist,Links_1,Links_1_Name,Display,Date_entered,Notes,Remote_computer_name,User_name,Browser_type,Timestamp" s-columntypes="3,202,202,202,202,202,202,202,202,202,202,202,202,202,202,202,3,202,202,202,135,202,202,202,202,135" s-dataconnection="celebrity" b-tableformat="FALSE" b-menuformat="TRUE" s-menuchoice="Last_Name" s-menuvalue="ID" b-tableborder="TRUE" b-tableexpand="TRUE" b-tableheader="TRUE" b-listlabels="TRUE" b-listseparator="TRUE" i-listformat="0" b-makeform="FALSE" s-recordsource="Agent" s-displaycolumns="ID,Last_Name" s-criteria="[Last_Name] CNT {Last_Name} + [First_Name] CNT {First_Name} +" s-order="[Last_Name] +" s-sql="SELECT * FROM Agent WHERE (Last_Name LIKE '%::Last_Name::%' AND First_Name LIKE '%::First_Name::%') ORDER BY Last_Name ASC" b-procedure="FALSE" clientside suggestedext="asp" s-defaultfields="Last_Name=&First_Name=" s-norecordsfound="No records returned." i-maxrecords="0" i-groupsize="0" botid="2" 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> " b-InForm="TRUE" b-WasTableFormat="FALSE" 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 Agent WHERE (Last_Name LIKE '%::Last_Name::%' AND First_Name LIKE '%::First_Name::%') ORDER BY Last_Name ASC"
fp_sDefault="Last_Name=&First_Name="
fp_sNoRecords="No records returned."
fp_sDataConn="celebrity"
fp_iMaxRecords=0
fp_iCommandType=1
fp_iPageSize=0
fp_fTableFormat=False
fp_fMenuFormat=True
fp_sMenuChoice="Last_Name"
fp_sMenuValue="ID"
fp_iDisplayCols=2
fp_fCustomQuery=False
BOTID=2
fp_iRegion=BOTID
%>
<!--webbot bot="DatabaseRegionStart" endspan i-checksum="26643" --><select NAME="Agent" SIZE="1">
<option selected value="1">---None---</option>
<!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn1.inc" startspan --><!--#include file="../_fpclass/fpdbrgn1.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52766" -->
<option VALUE="<%=FP_FieldHTML(fp_rs,"ID")%>"><%=FP_FieldHTML(fp_rs,"Last_Name")%>, <%=FP_FieldHTML(fp_rs,"First_Name")%>
</option>
<!--webbot bot="AspInclude" clientside u-incfile="../_fpclass/fpdbrgn2.inc" startspan --><!--#include file="../_fpclass/fpdbrgn2.inc"--><!--webbot bot="AspInclude" endspan i-checksum="52830" -->
</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>
<td width="9%" height="22" bgcolor="#CCCCCC" style="border-style: solid; border-width: 1; padding-left: 4; padding-right: 4; padding-top: 1; padding-bottom: 1"> </td>
John Stafford
WaterLine Productions
Where Sound Decsions Are Made
|
|
|
|
