@DBLookup on XPage - Help

HCL Domino Domino Forum
1

Me again!

Apologies for bothering you yet again, but i am having trouble doing something really simple on my XPage…

I have a combobox field : “ProbType” which you can select a Type of System, say “Lotus Notes”, I have a DBlookup on another field “System Name” here is the ‘Values’ {Computed} code :

@DbLookup(“”, “(SysByType)”, FLSCall.getValue(“ProbType”), 2);

I have tried different variations of this and narrowed it down to the “FLSCall.GetValue” bit. i have tried “FLSCall.ProbType” and all sorts! If i replace this section with “lotus Notes” it works fine.

I also set the default value of the ProbType field to “Lotus Notes” so the page would load that value first, this still didn’t work.

Can anyone point me in the right direction?

Thank You.

Jamie

P.S> I have also tried :

var ctry = FLSCall.getValue(“ProbType”);

var lst1 = @DbLookup(@DbName(),“(SysByType)”,ctry,2);

@Explode(lst1,“,”)

2

Subject: Try getItemValueString

You’re missing that step where you get the value of a certain control.

I have a comboBoc bound to the document data source ‘document1.selectCountry’. I’ve a second combobox which uses the value on the first combobox as a key for the DBLookup. And for this key I used document1.getItemValueString(“selectCountry”)

var ctry = document1.getItemValueString(“selectCountry”);

var lst1 = @DbLookup(@DbName(),“viewList”,ctry,2);

@Explode(lst1,“,”)

Now I could have used another way to get the value of a field in the current document like ‘.getComponent(“comboBox1”)’ - I haven’t tried it but that should work as well