Get started Bring yourself up to speed with our introductory content.

Top 5 @DBLookup tips

Discover Ajax, JavaScript and LotusScript code equivalents for the Formula language @DBLookup command, and learn a workaround for a common @DBLookup error.

@DBLookup is a Formula language command frequently used for Lotus Notes Domino application development. It's often used several times within a single Notes/Domino application. If you'd like to return a field value from a specific Lotus Notes database, @DBLookup is the command to use. Here, we've compiled our top five @DBLookup tips. Discover @DBLookup code equivalents in Ajax, JavaScript and LotusScript, and learn a workaround for a common @DBLookup error.

#1. @DBLookup and @DBColumn for all browsers using Ajax
This generic code can be used to perform @DBColumn and @DBLookup using Ajax in Internet Explorer, Mozilla and Netscape.

#2. @DBLookup function for the Web using JavaScript
Learn how to simulate the @DBLookup function in a Web browser to return a Lotus Notes Domino array using some JavaScript code.

#3. JavaScript version of @DBLookup and @DBColumn
Learn how to get @DBLookup and @DBColumn functionalities with this JavaScript that will help you to avoid page refreshes while looking up data in a Web browser.

#4. LotusScript equivalent of @DBLookup and @DBColumn member Nithya K. shares a LotusScript code equivalent of @DBLookup and @DBColumn for Lotus Notes that doesn't decrease Domino Server performance.

#5. Workaround for @DBLookup error: 'The specified database lookup generated more than 65,000 bytes of results'
It's common to receive this error message when performing an @DBLookup: "The specified database look-up generated more than 65,000 bytes of results, which is too large for Lotus Notes to handle in this context." member Vinay Betala explains how to use a "prompt method" with a multi-value selection option to work around this problem.

Related resources from

Dig Deeper on Lotus Notes Domino Formula Language

  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/ community. These cheat ...