XPages: @DbColumn results in error if not returning a list

HCL Domino Domino Forum
1

Situation:Values property of a combobox control contains formula code that retrieves data from a view:

@DbColumn(“dbpath//dbname.nsf”,“By Category”,1)

Problem:

If the view referenced contains less than 2 entries (i.e.: not a proper list of entries) this results in the following error displayed by the browser:

Unexpected runtime error

Error source: …

Exception:

Conversion Error setting value “{0}” for “{1}”

Solution / workaround:

Make sure the result IS a list, e.g. by enclosing the code in an @Explode() function

@Explode(@DbColumn(“path//filename.nsf”, “viewname”, col#))

(Many thanks to John Mackey for the hint…)

Hope this is not a wanted behaviour…

2

Subject: Thanks Lothar | Bug logged and fixed for the release xp:eom/

3

Subject: Conversion Error setting value

A combobox with itemValue choices (not a computed list of choices) was on an CC in an XPage.The combobox value saves on the backend, ok.

When reloading a dialog that used the backend document as the datastore, throws this error:

Conversion Error setting value ‘[FieldName’ for ‘null Converter’

What the combobox on in the dialog form needed was a “value” attribute to compute the saved value from the backend document.

No value Throws an error:

<xp:comboBox id=“fieldName1”>

With a value No Error and the saved value is the appearing value in the combobox:

<xp:comboBox id=“fieldName1” value=“#{Doc.fieldName}”>

(El Syntax is used for the Value calculation, javascript #{javascript:Doc.getItemValueString(“fieldName”)} didn’t work either)