CODEWITHSUNDEEP
xpages
Robert
Robert

Reputation: 123

DbColumn Lookup Code

I'm having trouble getting my @DbColumn to populate. I'm trying to use a drop down menu to display a list of departments, which is in a view called "DepartmentLookup" in an application that is called HCHPhoneBk.nsf.

I'm not getting an error message or anything, so that's not really helping me.

Here is the code I am using. The nsf file that I am working in, and the HCHPhoneBk nsf file are both on the same server, called DomTest01.

@DbColumn("aApplications\HCHPhoneBk.nsf", "DepartmentLookup", 2);

Upvotes: 1

Views: 133

Answers (1)

Tode
Tode

Reputation: 12060

In the formula language (that is where this javascript code will be translated internally) the backslash is a special character. You need to mask it.

The first argument must be an array with the first element the server and the second the database. If it's the same database then you can use @DbName or blank array strings. A single value is only valid if it is blank.

Example:

var dbName = ["", "aApplications\\HCHPhoneBk.nsf"];
@DbColumn( dbName , "DepartmentLookup", 2);`

Alternatively try:

var dbName = ["", "aApplications/HCHPhoneBk.nsf"];
@DbColumn( dbName , "DepartmentLookup", 2);`

See this link for a similar thread

Upvotes: 3

Related Questions