|
| |
|
|
wlp
Posts: 54
From: None
Status: offline
 |
Drop down Boxes "None" value - 3/28/2002 9:53:56
I am retreiving data and displaying it with a drop down box. Sometimes the data in the drop down box does not exist for submission and I would like to allow the user to continue without entering data in that field. As I have it now all the reocrds are being retrived and there is no allowance for "blank" or "none". The user is forced to select one of the records. Any suggestions?
John Stafford
WaterLine Productions
Where Sound Decsions Are Made
|
|
|
|
arnie
Posts: 209
From: Gobbler Knob, Indiana
Status: offline
|
RE: Drop down Boxes "None" value - 3/28/2002 12:33:00
In normal view, try right-click on field > form field properties > Validate > uncheck "data required".
Arnie Howes
ITP #600 ITP #700 ITP #800 ITP #902
| |
|
|
|
wlp
Posts: 54
From: None
Status: offline
|
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
| |
|
|
|
RRogers123
Posts: 115
From: None
Status: offline
|
RE: Drop down Boxes "None" value - 3/28/2002 15:04:22
It is difficult to see the changes you made. Pehaps you could just show the lines with the changes. Thanks.
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
