Computed text - exceeding size - workaround needed

HCL Domino Domino Forum
1

Hi

I have a computed text formula thus:

column1values := @DbColumn(“”:“NoCache”;“”;“Varchivenews”;1);

column2values := @DbColumn(“”:“NoCache”;“”;“Varchivenews”;2);

column3values := @DbColumn(“”:“NoCache”;“”;“Varchivenews”;3);

column4values := @DbColumn(“”:“NoCache”;“”;“Varchivenews”;4);

column5values := @DbColumn(“”:“NoCache”;“”;“Varchivenews”;5);

dbFilePath := “/” + @ReplaceSubstring(@Subset(@DbName;-1);“\”;“/”);

tableRows := “”;

rowNumber := 1;

@DoWhile(

tableRows := tableRows +

"

" +

“<li class="greenBullets">” +

“<a href="” + dbFilePath + “/Vlivenewsbyid/” + @Subset(@Subset(column4values;rowNumber);-1) + “?OpenDocument" title="” + @Subset(@Subset(column3values;rowNumber);-1) + “">” +

@Text(@Subset(@Subset(column3values;rowNumber);-1))

  • “<font size=2 class="greenText"> (” + @Text(@Subset(@Subset(column5values;rowNumber);-1)) + ")
";

rowNumber := rowNumber + 1;

rowNumber <= 50);

“

” + tableRows + “
”

This effectively builds a table that I display on the web. I am doing it this way as I find it easier to control all the table settings. The problem is that I can only get about 60 rows of data before it says that it is exceeding the maximum allowed size. I have tried putting the code into a rich text field but it still hits the limit.

I don’t really want to back to square one so i was wondering if there is a way to do this that will circumvent the problem ?

Thanks

Paul

2

Subject: Construct an HTML view to avoid field limitation.

You can construct an HTML view in the same fashion as you are constructing the table rows.something like;

embed your view in the form here with column headers like

Put the columns formula like.

For Column1:

For Column2:

Column1column2
FieldName1(you can use an to display it as link) FieldName2

In IE, it doesn’t wrap text if the column value is long, so you can include the following CSS on your form.

td { white-space: pre-wrap; /* css-3 */ white-space: -moz-pre-wrap; /* Mozilla, since 1999 */ white-space: -pre-wrap; /* Opera 4-6 */ white-space: -o-pre-wrap; /* Opera 7 */ word-wrap: break-word; /* Internet Explorer 5.5+ */ }

Also you can use URL parameters start and count to control the no of records you want to display.

HTH

Vinit

3

Subject: LotusScript with WebQueryOpen Agent

For this type of stuff I would have a RichText field on the form that is computed with “” as the formula. Then I’d have a WebQueryAgent build the collection and write the data to that field when the form is loaded.

Do you get the same error if you use a computed for display field?