Re: Drop down returns

oldradio99 — Thu, 31 Jan 2008 22:56:01 GMT

How would I set a default? Even if I wanted to do that?

I deleted the data connection and recreated it and updated the ODC connection

Still same issue, even if binding on a different field

I also tried creating a brand new form and added a drop down to the same database and same condition.

I am lost.

Here is the text form the view.xsl that deals with the drop down. Could my filters be causing the issue?

I also opened the template.xsl and when that opened in InfoPath, the drop down behaved normally.

- <select class="xdComboBox xdBehavior_Select" title="" style="WIDTH: 100%; FONT-FAMILY: Arial" size="1" xd:CtrlId="CTRL25" xd:xctname="DropDown" xd:boundProp="value" xd:binding="@ItemName" value="" tabIndex="0">

- <xsl:attribute name="value">

<xsl:value-of select="@ItemName" />

</xsl:attribute>

- <xsl:choose>

- <xsl:when test="function-available('xdXDocument:GetDOM')">

<xsl:variable name="val" select="@ItemName" />

- <xsl:if test="not(xdXDocument:GetDOM("tblMMIBuckItems")/dfs:myFields/dfs:dataFields/d:tblMMIBuckItems[not(@ItemName = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/d:tblMMIBucktemsordered/@ItemName)][@ItemName=$val] or $val='')">

- <option selected="selected">

- <xsl:attribute name="value">

<xsl:value-of select="$val" />

</xsl:attribute>

<xsl:value-of select="$val" />

</option>

</xsl:if>

- <xsl:for-each select="xdXDocument:GetDOM("tblMMIBuckItems")/dfs:myFields/dfs:dataFields/d:tblMMIBuckItems[not(@ItemName = xdXDocument:get-DOM()/dfs:myFields/dfs:dataFields/d:tblMMIBucktemsordered/@ItemName)]">

- <option>

- <xsl:attribute name="value">

<xsl:value-of select="@ItemName" />

</xsl:attribute>

- <xsl:if test="$val=@ItemName">

<xsl:attribute name="selected">selected</xsl:attribute>

</xsl:if>

<xsl:value-of select="@ItemName" />

</option>

</xsl:for-each>

</xsl:when>

- <xsl:otherwise>

- <option>

<xsl:value-of select="@ItemName" />

</option>

</xsl:otherwise>

</xsl:choose>

</select>

</font>

</div>

</td>

Re: Drop down returns

Clay Fox — Thu, 31 Jan 2008 21:50:37 GMT

You sure you do not have a default set or something? They typically will start blank. Then you select from the drop down. The field should be blank initially unless you are setting it from somewhere or have a default. This can get corrupted and if you export your source files you can check the view.xsl. I saw a post recently with the same issue. Try binding to a different field and see if you get the same thing.

Drop down returns

oldradio99 — Thu, 31 Jan 2008 18:45:16 GMT

I have searched this forum high and low. Did you ever know that you used something that works but then you cant remember how you did it? Well that is me right now.

I have a drop down being populated from a data connection to a simple SQL table. What I want is for the drop down to be blank with no selection when the form opens. Right now it shows the first item in the table. Sort of like the "select one" when you manually populate a drop down.

It works on all my other forms but I am stumped how I did it.

Thanks

SQL Database Integration

Re: Drop down returns

Re: Drop down returns

Drop down returns