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



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 ...