Help with @DBColumn

HCL Domino Domino Forum
1

Help;

Im trying to get the value of a number in a column. There is only one value in the column and the view that contains it is in the same database that i’m working in.

Hence I use the formula;

@Implode(@DbColumn(“Notes”;“NoCache”;“85256DF7:00790AEE”;“CounterTwo”;1));

Yet i get back: Field:‘hold’: File does not exist.

Once I click ok, the next message that pops up is:

The server with this database is no longer responding.

Should Notes swith to another replica on another server?

with yes/no buttons.

I know that the view exists and I know the value is in there…

Please help…what am I missing here?

2

Subject: Help with @DBColumn

As well as a syntax error in the first parameter (that should read “Notes”:“NoCache”), you need to specify a server, or null if it’s the local machine (Server:Database) … see your Designer Help …Specifying the server and database

There are several ways to specify the server : database parameter:

To perform the lookup on the current database (the same database in which the formula is being evaluated), specify “” as the entire argument to the function. “” means the local Domino directory where you are executing.

To perform a lookup on a local database, use “” for the server name and specify the database name explicitly, such as “”:“DATABASE.NSF.”

To perform a lookup (from the workstation) on a Domino database that resides on a server, include the server plus the path and file name as a text list, as in “SERVER”:“DATABASE.NSF.”

3

Subject: Help with @DBColumn

Hi Larry,

Firstly, that should be a colon between the “Notes” and “NoCache” - ie:

@Implode(@DbColumn(“Notes”:“NoCache”;“85256DF7:00790AEE”;“CounterTwo”;1));

Secondly, if it’s the same database, don’t bother with the replica id, just use a null string.

Thirdly, don’t bother with “Notes” - it’s the default, so just use a null string.

Therefore recommended formula is:

@Implode(@DbColumn(“”:“NoCache”;“”;“CounterTwo”;1));

hth

Tony