@DBLookup function for Web

An alternative to simulate @DBLookup in the Web browser and to transfer the processing of the data to the Web browser. The return of the data is a Lotus Notes Domino array.

Note: This is only available for Internet Explorer.

MEMBER FEEDBACK TO THIS TIP

The @DBLookup function for Web in the code at this line : vurl = trim(server)+trim(path)+view+"?readviewentries&count=10000"; we cannot have 10000 documents returned if in the server's document the maximum number of documents returned is for example 300. I Personnaly use this url it returns the maximum number of documents authortised by the server. vurl = trim(server)+trim(path)+view+"?readviewentries&count=-1"; (replace 10000 by -1).
—Zoubir A.

The problem with this approach is that the developer is creating an XML object for the entire view and then navigating through it. Not only is this inefficient but it could suck up a huge chunk of memory from the browser depending on the view size. What you should do is load a subset of view entries into the XML object instead of loading the entire view. This can be done by using the StartKey and UntilKey arguments of the ReadViewEntr

Digg This!     StumbleUpon     Del.icio.us

RELATED CONTENT JavaScript JavaScript workaround fixes Lotus Notes 8.x PostOpen event issue Write HTML and JavaScript in Notes view rows and columns on the Web JavaScript detects Web browser type and version in Notes/Domino 8.0.2 JavaScript creates a jump box on a Lotus Notes Web form How to create dynamic JavaScript in Notes Domino without formulas Trap an attachment path via the Domino file upload control field Converting Lotus Notes views to XML documents using JavaScript Prevent errors on iFramed pages with JavaScript How to add keyboard functionality for Lotus Notes documents Validate Lotus Notes Domino fields using JavaScript

RELATED RESOURCES 2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems Search Bitpipe.com for the latest white papers and business webcasts Whatis.com, the online computer dictionary

ies call. I've included the help text from Domino explaining these arguments. StartKey = string Where: string is a key to a document in sorted view. The view displays at that document. In cases where there is no match for the StartKey, the next document is returned. So, for example, if the StartKey is "A" and there are no documents that begin with "A", StartKey returns the first document that begins with "B." UntilKey = string UntilKey is only valid when used with StartKey. It allows you to display the range of view entries beginning with the document specified by StartKey until the document specified by UntilKey. For example, &StartKey=A&UntilKey=B would give you all the entries that start with A. Use the &Count keyword to further limit the number of entries returned within any given range.
—Jerry B.

Do you have comments on this tip? Let us know.

This tip was submitted to the SearchDomino.com tip library by member Wesley Guisso. Please let others know how useful it is via the rating scale below. Do you have a useful Lotus Notes, Domino, Workplace or WebSphere tip or code snippet to share? Submit it to our monthly tip contest and you could win a prize.

Rate this Tip To rate tips, you must be a member of SearchDomino.com. Register now to start rating these tips. Log in if you are already a member. Submit a Tip DISCLAIMER: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.