This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal



Sep 5, 2012, 1:55 PM
23 Posts
topic has been resolvedResolved

@dblookup

  • Category: Other
  • Platform: Other
  • Release: 8.5.3
  • Role: Developer
  • Tags:
  • Replies: 4
Can you let me know the code for the @dblookup from another server and the database is located in folder like development\test\db.nsf
 
 
 
Thanks in advance
Sep 5, 2012, 9:23 PM
366 Posts
Re: @dblookup
 for the server parameter use
 
"servername","folder\\subfolder\\db.nsf"
 
 
the servers have to have a trust relationship established via the server documents for this to work. 
 
 
Sep 5, 2012, 9:39 PM
10 Posts
Re: @dblookup
 
var dbName="APPSERVER01/MARKETING!!/development/test/db.nsf";
var key ="John Smith";
var x=@DbLookup(dbName,"By Employee Name",key,3,"[FailSilent]");
return(x)
 
 
 
(XPages/Javascript w/@Formula)
Sep 6, 2012, 3:50 AM
366 Posts
Re: @dblookup
 I'm pretty sure the first variable to the db @ Functions will only take an array.
 
So the server and database reference have to be separate strings. 

This forum is closed to new posts and responses. Individual names altered for privacy purposes. The information contained in this website is provided for informational purposes only and should not be construed as a forum for customer support requests. Any customer support requests should be directed to the official HCL customer support channels below:

HCL Software Customer Support Portal for U.S. Federal Government clients
HCL Software Customer Support Portal