Simple, but still need help (@DBlookup)

HCL Domino Domino Forum
1

I am making a phone book. i have a part where i want it to look for the name and bring forth the info like address and phone number.

i am currently using :

@DbLookup(“”:“”;“”;“PhoneBook”:“CoName”;“emFAST”)

but its not working for me, i know i’m probably missing some peace of coding in there.

Any input would be greatly apreciated…

2

Subject: Simple, but still need help (@DBlookup)

Your coding is wayyy off. read the help file for syntax.

3

Subject: Simple, but still need help (@DBlookup)

@DbLookup(“”:“”; “”:“PhoneBook.nsf”; “CoName”; “emFAST”; “PhoneNumber”)

where “CoName” is the name of a view in the database “PhoneBook.nsf” and “emFAST” is the key to look up in that view (ensure the view has a column that is sorted). “PhoneNumber” is the name of the field to return from the matched document.

Don’t forget to test for an error by using @IsError or @IfError.

B

4

Subject: RE: Simple, but still need help (@DBlookup)

Dont forget to use “Nocache” to always get updated info.

ST

5

Subject: Simple, but still need help (@DBlookup)

OK, yeah, this is what i got so far…But it stills isn’t working

Keeps saying “file does not exist”

inputName := @Prompt([OkCancelEdit]; “User name”; “Enter user name as FIRST LAST”; “”);

phoneNumber := @DbLookup(“Notes” : “NoCache”; “” : “PhoneBook.nsf”; “Name”; inputName; “Phone2”);

@Prompt([Ok]; “Office phone number”; inputName + "'s office phone is " + phoneNumber)

6

Subject: The database is on your server right? If so…

@DbLookup(“Notes” : “NoCache”; @Subset(@DbName; 1) : “PhoneBook.nsf”; “Name”; inputName; “Phone2”);

7

Subject: RE: The database is on your server right? If so…

Stupid question but can u explain the “@Subset(@DbName; 1)”

cuz now its giving me “Server Error: File does not exist”

if anyone has the patience or the time, plz add me to msn (tganyuk@hotmail.com) and i can send u the databse i’m working on. maybe then it would be easier to troubleshoot. thnx

8

Subject: Where are you doing the lookup from?

Be specific. Check File, Database Properties and verify. Where is the Phonebook.nsf? Again check the Database properties.Check the Designer help for @DbName and @Subset. @DbName essentially returns a 2 element array, with the first value being the Server Name and the second being the File Path (relative to the Servers Data directory). The error you are getting is specific. It can not find Phonebook.nsf on the server in the root of the data directory.

9

Subject: RE: The database is on your server right? If so…

another thing you may want to check is - the dblookup searches the first sorted column in your view. if you don’t have your view sorted it won’t return anything.

i’ve had that before and took me way too long to figure out.