XPage: @DbColumn Formula to fill ComboBox Control values fails

HCL Domino Domino Forum
1

for demoing purposes I’m currently building my first sets of XPages. One thing I’m trying to do is to build a @DbColumn formula to fill the values of a combobox control with all entries read from the first sorted column of a view (very basic indeed). Unfortunately, this constantly fails. Here’s what my formula looks like:

@DbColumn(@DbName(), “ByCategory”, 1)

(Yes, the view exists in the current database, and its alias name is written exactly like that; it shows documents, and the first column is sorted / categorized).

If I call a preview for my XPage Firefox gives me an Error 500 (“HTTP Web Server: Command Not Handled Exception”).

If on the other hand I remove the formula from the “values” property of the control and fill it with static values instead, the Xpage displays and gives me the right choices.

If I replace the @DbColumn with just a simple “DbName()” the Xpage display as well, giving me the expected choice of “server name” : “database file path”

Anything I somehow forgot to set?

Any help is appreciated!

BEst regards,

-Lothar

2

Subject: try this

It all depends on how you’re using it. Try…

<xp:comboBox id=“comboBox1” value=“#{document1.selectCountry}”>

<xp:selectItem itemValue=' ' itemLabel=' '>

</xp:selectItem>

<xp:selectItems>

	<xp:this.value><![CDATA[#{javascript:@Unique(@DbColumn(@DbName(),"viewList",1))}]]></xp:this.value>

</xp:selectItems>

</xp:comboBox>

3

Subject: doesn’t work either - but solved using a workaround

Sorry, no.

Meanwhile I received a hint that there’s some problem with @DbName() in Beta2; if I replace that part with the hard-coded reference to my db as in

“pathname//database.nsf”

everything works.

Thanks anyway

4

Subject: Yes you’re right, that bug has been fixed.