@DbLookup question

Posted on 2005-04-07
Last Modified: 2013-12-18
I would like to do a @dblookup on our names and address book (names.nsf) and get a list of names that appear in the first column of the People view.
Help gives the following format but I am having a problem with the key value.  What should I use; it is a standard NAB and it is not indexed.
@DbLookup( class : "NoCache" ; server : database ; view ; key ; fieldName ) or
@DbLookup( class : "NoCache" ; server : database ; view ; key ; columnNumber )

Question by:Chris_m
    1 Comment
    LVL 13

    Accepted Solution

    If you want the entire column, you need @DbColumn.
    Do watch the 64K limit!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Suggested Solutions

    Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
    Article by: Rob
    Notes 8.5 Archiving Steps and Tips This article covers setting up a Notes archive, and helps understand some of the menu choices making setting up and maintaining a Notes archive file easier.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now