@dbcolumn specify default server

HCL Domino Domino Forum
1

hello all,I am using the @dbcolumn statement to fill a dialog list box with data from a view of another database (the database just contains states and abbr. for use with other db’s)

How can I specify a “default server” ie the home server listed in the current person doc, or the users default server without hardcodeing “myserver/server”

Because, i have multiple replicas of this one database on different servers and would like the info to come from the users closest server (ie their default, home and mail server).

PS it is also the same server as the current server they opened this database on that contains the dbcolumn dialog box.

Hope that was ok english :wink:

Mu

2

Subject: Use the Replica ID instead of Server : FileName

3

Subject: @dbcolumn specify default server

I have a configuration document in every database where a lookup is required to a different database. An example of my lookup is as follows:

tmp_list := @DbColumn( “” ;@Subset(@DbName;1):Lookup_SitesDb ; “LCompany”; 2);

@If(@IsError(tmp_list) ; “Unable to locate list” ; tmp_list)

The field ‘Lookup_SitesDb’ is a computed field on the form that looks at the Configuration document.

The code ‘Subset(@DbName;1)’ accesses the current server so it gets round the problem of what server to access.

Hope this helps,

Katherine

4

Subject: RE: @dbcolumn specify default server

Thank you this should help!