Problem in displaying dropdown values

HCL Domino Domino Forum
1

Hi We have a dropdown in one of the web form, the values for this drop down are fetched by an agent in web query open, for the first time when the form is displayed the values are displayed and if we select any value from dropdown the screen is refreshed and only a single default value is displayed in the dropdown list. This problem I am facing after I upgraded from lotus 6.5 to 7.0.3 . Previously it used to work fine with lotus 6.5.”Refresh fields on key word change” option is checked for my dropdown field.

Has anyone seen this before? If so, is there a fix or a known problem reported for this type of behavior?

Thanks in advance.

Raj

2

Subject: problem in displaying dropdown values

Can you please post your code ?

3

Subject: RE: problem in displaying dropdown values

hi rishi,

i have a field “txtfps” (text with multiple values)whose value is set by agent.The values are stored in “101|name1”,“102|name2” format

For the dropdown “txtNewFps” in formula choices i have given @ProperCase( txtfps) and checked "refresh fields on keyword change " option in Field Properties box - Control tab

I hope this information is enough.i cant post the code due to some company policies

thanks

4

Subject: RE: problem in displaying dropdown values

How are you setting the field value , using getdocumentbykey or dblookup/dbcolumn in script. you don’t need to paste exact code instead your core logic. I have been working since R5 , it’s impossible lookup was working in R6 , but failed in R7. It can’t happen, I assume you have done some logical mistake. make sure you are using correct syntax.

Rishi

5

Subject: RE: problem in displaying dropdown values

Thanks for your response rishi.

The values of “txtfps” are fetched from oracle database and the document is taken from current session.

Private s As NotesSession

Private db As NotesDatabase

Private wdoc As NotesDocument

Set wdoc = s.DocumentContext

’ …set value of doc…

Set item = wdoc.GetFirstItem( “txtfps” )

This is the code which a have in an agent. The functionality in the form is if I change in the dropdown it need to update other two fields one is the value of the dropdown selected and the other is the text of the dropdown selected.

Fields in my form:

  1. txtfps – value set in agent (text with allow multiple values)

  2. Dropdown “txtNewFps” – In formula choices i have given @ProperCase( txtfps) and checked option "refresh fields on keyword change "

  3. Computed text NameNewFP –It should contain the text of selected txtNewFps, Formula → @Name([CN];@NameLookup( [NoSearching] ; txtNewFps; “FullName”))”

  4. Computed for display text – It should contain value of selected txtNewFps, Formula → txtNewFps

In R6x it used to work fine i.e. if I change the dropdown value all the fields used to reflect in correct way. Now in R7x the screen is refreshed on dropdown value change and only single value is displayed in the dropdown. Can you please tell me what happens is we select “refresh fields on keyword change” for a dropdown.

URL to access form looks like → https:// /dlgReRC?OpenForm&ParentUNID=

6

Subject: RE: problem in displaying dropdown values

Hi my issue got resolved i have checked the option “Allow multiple values” to my text box.