DBLookup not working in web

HCL Domino Domino Forum
1

Hi All,

I want to check DBlookup in web in one field but it is not working in web in client it was worked , so can any one help me how to solve this issue on web

My Code->

TargetServer :=@Subset(@DbName;1);

var :=@DbLookup(“”:“NoCache”;TargetServer:MastrDB;“Department (Budget)”;@Trim(Department);2);

sn:=@Replace(Var;@GetField(“KPISubDepartment2”) : @GetField(“KPISubDepartment3”) : @GetField(“KPISubDepartment4”) : @GetField(“KPISubDepartment5”) : @GetField(“KPISubDepartment6”) ;“”);

@If(@IsError(var) | var = “” ; “No KPI Sub department exists for the selected KPI Department”; sn)

2

Subject: DBLookup not working in web

Output the error in your lookup, so you know what the actual error is…

@If(@IsError(var) | var = @text(var) ; “No KPI Sub department exists for the selected KPI Department”; sn)

3

Subject: RE: DBLookup not working in web

I have write another code and thid also given problem i replace tragetserver code to @servername and it was ok but i think problem is “Department” field i have not get Department field value

Deaprtament field is Dialog List and in and in this field use formula for choice i have map anither field DeptAll in this field i have write DBColumn and pick all department value and show in Department field and this field i used in my lookup and this Department field value not show in my lookup this was problem for this i create another field and check Department value come or not and found it is not come so i want to get Department field value and i use @GetField(Department) this is also not helpfull not get any value.

CLASS := “”;

NOCACHE := “”;

SERVER := @ServerName;

DATABASE := MastrDB;

VIEW := “Department (Budget)”;

KEY :=Department;

COLUMN := 2;

LookUp := @DbLookup(CLASS : NOCACHE; SERVER : DATABASE; VIEW; KEY; COLUMN);

LookUp1 :=@DbLookup(“Notes”: “ReCache”; @ServerName: MastrDB; “Department (Budget)”; Department; “SubDept”);

@If(@IsError(LookUp); “Error”; LookUp1)

4

Subject: DBLookup not working in web

Is the TargetServer different from the server that is hosting the application?