Fast Guide

Top 5 @DBLookup tips

@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
Related resources from SearchDomino.com:
Do you have a specific @DBLookup question? Ask our expert, Andre Guirard!

Check out our @DBLookup Fast Guide for more tips and expert advice.

You can also visit our Formula Language Reference Center for more resources.

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
SearchDomino.com 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." SearchDomino.com member Vinay Betala explains how to use a "prompt method" with a multi-value selection option to work around this problem.

This was first published in October 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

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: