Exit
  • Global community
    • Language:
      • Deutsch
      • English
      • Español
      • Français
      • Português
  • 日本語コミュニティ
    Dedicated community for Japanese speakers
  • 한국 커뮤니티
    Dedicated community for Korean speakers
0

Dymanic Form Data

New Here ,
Dec 05, 2007 Dec 05, 2007

Copy link to clipboard

Copied

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.
TOPICS
Server side applications

Views

197
Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines
New Here ,
Dec 05, 2007 Dec 05, 2007

Copy link to clipboard

Copied

LATEST
Buler Buler...

Votes

Translate

Report

Report
Community guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
community guidelines