@dblookup

HCL Domino Domino Forum
1

hi all

im having a problem with a @dblookup

ive tried the following code

@DbLookup( “”:“NoCache” ;“mail1/is/nbs”:“itchangerequest.nsf”;“systems”; “Lotus Notes” ; 2))

and i get the following error

“ERROR: Entry not found in index or views index not built”

i also tried

@DbLookup( “”:“NoCache” ;“”:“”;“systems”; “Lotus Notes” ; 2))

and got the same error

anyone see what I am doing wrong,

thanks

gav

2

Subject: @dblookup

check ur view, the first column must be sorted.

3

Subject: @dblookup

thanks guys… sorted the view and it worked fine…

4

Subject: @dblookup

Hard to say without seeing your database.

Can you confirm that the phrase “Lotus Notes” appears in the first sorted column of the “systems” view in the database you reference?

Cheers

K