Question
Dymanic Form Data
Is there a way to easily test for Null Values in Dynamic
Forms?
Case example:
I have a Form that gets data from a SQL Database, one of the form items is a list/menu box. The case may be true that there may not be a value. How do I test this here is code:
<select name="DomainName2" id="DomainName">
<option value="0" <%=((0 == (DomainName.Fields.Item("workgroupDomainName").Value))?"selected=\"selected\"":"")%>>Workgroup/Domain</option>
<%
while (!DomainName.EOF) {
%><option value="<%=(DomainName.Fields.Item("workgroupDomainName").Value)%>" <%=((DomainName.Fields.Item("workgroupDomainName").Value == (DomainName.Fields.Item("workgroupDomainName").Value))?"selected=\"selected\"":"")%> ><%=(DomainName.Fields.Item("workgroupDomainName").Value)%></option>
<%
DomainName.MoveNext();
}
if (DomainName.CursorType > 0) {
if (!DomainName.BOF) DomainName.MoveFirst();
} else {
DomainName.Requery();
}
%>
</select>
I am hoping that there is an option I am not selecting somewhere that tests before execution.
It almost seems there is room for a feature request here. While in the Dynamic List/Menu properties box you have the options to select from Recordset, values, labels and select value equal to options. It seems that there should be an option to say if Null then ignore.
Case example:
I have a Form that gets data from a SQL Database, one of the form items is a list/menu box. The case may be true that there may not be a value. How do I test this here is code:
<select name="DomainName2" id="DomainName">
<option value="0" <%=((0 == (DomainName.Fields.Item("workgroupDomainName").Value))?"selected=\"selected\"":"")%>>Workgroup/Domain</option>
<%
while (!DomainName.EOF) {
%><option value="<%=(DomainName.Fields.Item("workgroupDomainName").Value)%>" <%=((DomainName.Fields.Item("workgroupDomainName").Value == (DomainName.Fields.Item("workgroupDomainName").Value))?"selected=\"selected\"":"")%> ><%=(DomainName.Fields.Item("workgroupDomainName").Value)%></option>
<%
DomainName.MoveNext();
}
if (DomainName.CursorType > 0) {
if (!DomainName.BOF) DomainName.MoveFirst();
} else {
DomainName.Requery();
}
%>
</select>
I am hoping that there is an option I am not selecting somewhere that tests before execution.
It almost seems there is room for a feature request here. While in the Dynamic List/Menu properties box you have the options to select from Recordset, values, labels and select value equal to options. It seems that there should be an option to say if Null then ignore.
