I created a field (called “Test”, Computed for display – Numeric) to capture the number of documents that respond to the value of another hidden field (Current_Letter). The “Current_Letter” field has the following code":@Right(Query_String ; 1)
,which is one letter of the alphabet.
The “Test” field has the following formula:
TheViewName := @If(lang = “F” ; “byLastName_f” ; “byLastName_e”);
letterToLookFor := @UpperCase(Current_Letter);
dbcolumnvalue := @Trim(@DbColumn(“”;“”;TheViewName;1));
allCount := @Elements(dbcolumnvalue);
first := @UpperCase(@Left(dbcolumnvalue;1));
strippedFirst := @Trim(@Replace(first ; letterToLookFor;“”));
“( " + (first - strippedFirst) + " found)”.
The system keeps giving me the following error message:
“HTTP Web Server: Lotus Notes Exception - Incorrect data type for operator or @Function”
What am I missing here?
Dan