View member feedback to this tip.
DbColumn is very useful and is frequently used in Domino applications.
But what if the limit exceeds 64k? Here is a solution for that limitation.
Code
Step 1: Make a view with one column.In the column write this formula:
"<option>"+lookupfield+"</option>"
(lookupfield is the fieldname, you want to lookup)
Enable view property "Treat view content as HTML"
Step2: Open the form where u want to make a lookup.
Put these lines
[<SELECT name="lookuplist">]
embed the view here you created above.
[</SELECT>]
(lookuplist is the field on your form, which will capture the value
you select from the list)
Open the embedded view properties.
In the first tab ..select Display using HTML
In the second tab select.
Customize the size of window according to your requirement
And Select "Show Content only"
MEMBER FEEDBACK TO THIS TIP
This tip works, but the maximum number of entries it can display is 1000.
-- SearchDomino.com member
********************************************
This tips works fine for getting round the 64K limit -- until you hit another limit, that is. The limit on how many lines can be displayed in the view is what seems to be capped at 1000 (R 5.12) I have more than 1000 options to display and would be grateful if the author of the tips can give me some feedback.
-- Aymen M.
******************************************
I have a way to get around the problem mentioned about the 1000 line limit. There is a server document setting that allows you to specify the maximum number of lines to return on a view listing. It's called "Maximum lines per view page." The default value is 1000. This can be changed to 0 for no limit or any other number. This setting does affect every database on the server, but it is only specifying a maximum, not the default. That is a separate field in the server document.
—Michael H.
Do you have comments of your own? Let us know.
