Orbeon Forms community mailing list

Population of Dynamic Data DropDown using Database service

Classic

List

Threaded

4 messages Options

Bolatik

Population of Dynamic Data DropDown using Database service

We are trying to populate Dynamic Data DropDown control with data from MS SQL database.

We did:
1) Created database service, action
2) Created 2 controls (1. InputField, 2. Dynamic Data DropDown control with control name "pok"

But there is nothing in output.
there is no error in orbeon.log file.
db service

As you see, it only populate InputField. How can I fix it?

Alessandro Vernet

Re: Population of Dynamic Data DropDown using Database service

Administrator

Hi Bolat,

We also exchanged a few messages about this one on Twitter. Did you
get to solve this issue? As I was mentioning there, I would first try
to create an action that just populates the dropdown, rather than
populating the dropdown and a control value with the same action.
Also, some of the expressions in the action dialog are most likely
incorrect (see attached).

Alex

On Wed, Dec 5, 2012 at 3:29 AM, Bolatik <[hidden email]> wrote:

> We are trying to populate Dynamic Data DropDown control with data from MS SQL
> database.
>
> We did:
> 1) Created database service, action
> 2) Created 2 controls (1. InputField, 2. Dynamic Data DropDown control with
> control name "pok"
>
> But there is nothing in output.
> there is no error in orbeon.log file.
> <http://orbeon-forms-ops-users.24843.n4.nabble.com/file/n4656074/populate.jpg>
> <http://orbeon-forms-ops-users.24843.n4.nabble.com/file/n4656074/action.jpg>
> <http://orbeon-forms-ops-users.24843.n4.nabble.com/file/n4656074/dropdown.jpg>
> <http://orbeon-forms-ops-users.24843.n4.nabble.com/file/n4656074/test.jpg>
> As you see, it only populate InputField. How can I fix it?
>
>
>
>
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/Population-of-Dynamic-Data-DropDown-using-Database-service-tp4656074.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

--
You receive this message as a subscriber of the [hidden email] mailing list.
To unsubscribe: mailto:[hidden email]
For general help: mailto:[hidden email]?subject=help
OW2 mailing lists service home page: http://www.ow2.org/wws

action.png (131K) Download Attachment

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet

Bolatik

Re: Population of Dynamic Data DropDown using Database service

Hi, Alex

Unfortunetely I didn't solve this issue. I have tried to populate only drop down but it doesn't work. Regarding the expressions in the action dialog, I tried all variants (namer instead of //namer) but it doesn't work.

It can populate inputfield though. So database connect is OK.

Is there any ideas how to solve this issue?

Alessandro Vernet

Re: Re: Population of Dynamic Data DropDown using Database service

Administrator

Hi Bolat,

So we can reproduce this here, would you be able to:

1. Change your SQL query so it runs on one of the demo MySQL tables,
say "employees".
2. Create a form as simple as possible that reproduces this.
3. Attach the form to a response here.
4. List the steps I should follow when using the form to reproduce the issue.

Alex

On Mon, Dec 10, 2012 at 10:58 AM, Bolatik <[hidden email]> wrote:

> Hi, Alex
>
> Unfortunetely I didn't solve this issue. I have tried to populate only drop
> down but it doesn't work. Regarding the expressions in the action dialog, I
> tried all variants (namer instead of //namer) but it doesn't work.
>
> It can populate inputfield though. So database connect is OK.
>
> Is there any ideas how to solve this issue?
>
>
>
> --
> View this message in context: http://orbeon-forms-ops-users.24843.n4.nabble.com/Population-of-Dynamic-Data-DropDown-using-Database-service-tp4656074p4656101.html
> Sent from the Orbeon Forms (ops-users) mailing list archive at Nabble.com.
>
>
> --
> You receive this message as a subscriber of the [hidden email] mailing list.
> To unsubscribe: mailto:[hidden email]
> For general help: mailto:[hidden email]?subject=help
> OW2 mailing lists service home page: http://www.ow2.org/wws
>

--
Follow Orbeon on Twitter: @orbeon
Follow me on Twitter: @avernet