@DBLookup not working on the web

HCL Domino Domino Forum
1

I have a DialogList field called Division which gets the list of divisions listed in the first column of a specified view with a @DBColumn which works fine. The Division field is also set to refresh on content change. However, I also have another DialogList field called “ProjectManager” with the following formula which does not work:server:=@Subset(@DbName;1);

db:=“NAMES.NSF”;

view:=“vLookupTechLeadByDept”;

key:=Division;

col:=2;

place:=“-Select a Project Manager-”:“-Not Applicable-”;

result:=@DbLookup(“” : “NoCache” ; server : db ; view ; key ; col);

@If(result=“” | @IsError(result) ; “ERROR” ; place : result)

Can someone tell me what I am doing wrong here? This doesn’t work in either the web or the Notes client environment.

Thsnks,

Dan

2

Subject: @DBLookup not working on the web

First things to check would be, if the view does exist (it does not in the original Domino Directory template), if it contains a sorted column, if the field Division contains anything and if so, if its data type matches that of the values in the first sorted column of the view.There doesn’t seem to be anything particular wrong with the formula itself.