Problem solve Get help with specific problems with your technologies, process and projects.

Replace @dblookup to work on the Web

Is there any way to replace the @Dblookup in order to work on the Web?

The function in @DBLookup is basically the same as what you would get with either a NotesView.GetDocumentByKey or a NotesDatabase.Search. The GetDocumentByKey method implies that you have a handle to a NotesView. If you have a view that you know contains the document you are seeking, and you have a key (a must) to that document, and the first sorted column contains that key, then you can get a NotesDocument object in LotusScript via the GetDocumentByKey method. If the document doesn't exist in a view that you can get a handle to or you do not know the key to it (i.e. the first sorted column), you could use a NotesDatabase.Search method. It uses a common @Formula Selection formula to find a NotesDocumentCollection. For example, you could get a collection like this:

Set MyCollection = MyDb.Search( StartDate, "Select status = ?archive'")

Either of those functions would perform much like @DBLookup. NotesDatabase.Search is far more flexible, but FAR more server intensive. If you can use NotesView.GetDocumentByKey then definitely use that that method.

Dig Deeper on Domino Resources - Part 2

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.




  • iSeries tutorials

    Search400.com'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 ...