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

This was first published in October 2007

Dig Deeper on Lotus Notes Domino Formula Language



Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:




  • iSeries tutorials's tutorials provide in-depth information on the iSeries. Our iSeries tutorials address areas you need to know about...

  • V6R1 upgrade planning checklist

    When upgrading to V6R1, make sure your software will be supported, your programs will function and the correct PTFs have been ...

  • Connecting multiple iSeries systems through DDM

    Working with databases over multiple iSeries systems can be simple when remotely connecting logical partitions with distributed ...