Manage Learn to apply best practices and optimize your operations.

Solution for DbColumn 64k limit on the Web

DbColumn is very useful and is frequently used in Domino applications. But what if the limit exceeds 64 KB?

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.

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.

Dig Deeper on Lotus Notes Domino Administration Tools

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchWindowsServer

Search400

  • 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 ...

SearchDataCenter

SearchContentManagement

Close