Lotus Notes Exception,lookup generated more than 65,534 results

HCL Domino Domino Forum
1

Hi all what can i do.

HTTP Web Server: Lotus Notes Exception - The specified database lookup generated more than 65,534 results, which is too large for Notes to handle.

And this are the Code, how i writes.

server := @Subset(@DbName; 1);

database := @WebDbName;

view := “LU_View”;

Namen := @DbColumn(“Notes” : “NoCache”;“11111111:22222222”; view;2);

Namen

Manolo

2

Subject: RE: Lotus Notes Exception,lookup generated more than 65,534 results

The message seems fairly clear. To make it work, do a lookup that returns fewer values. What are you trying to do here?

3

Subject: RE: Lotus Notes Exception,lookup generated more than 65,534 results

I want to make a Popup, and the a list of document to select, an write back to the Form.

You have any idee

Manolo

4

Subject: RE: Lotus Notes Exception,lookup generated more than 65,534 results

I’m not sure what you mean by a “popup”, but I’ll tell you that I’m not happy with comboboxes that list tens of thousands of choices, if that’s your plan. It takes a long time to load such a form every time it’s used – think about how much data must be sent to the browser – and in most cases, the user already knows what value they want there.

You might instead use JavaScript to open a “dialog” window that displays the view and lets the user select from it – what in the Notes client we woiuld call a picklist. Check out how the web mail application gets addresses, for example.