Solved

size limits in lotus script

Posted on 2008-10-26
4
749 Views
Last Modified: 2013-12-18
I am getting an apparrent size error on the following line of code. CURGROUP is a delimited string of user groups and its users (example: Marketing -  John Smith) but it's unsorted.  All it says is Operation failed. If I remove some of the data from the string it works.

NEWGROUPLIST=Evaluate(|@Sort(@Explode("| + CURGROUP + |";";"))|,doc)

Assuming it is a size issue on the string, what is my best way of doing a sort? Pull it into an array?
0
Comment
Question by:BillTr
  • 3
4 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 22808480
If CURGROUP is a value in a field on the document, you could sort its contents using LotusScript. Here's a QuickSort function:

http://www.11tmr.com/11tmr.nsf/D6Plinks/MWHE-695LAC
0
 

Author Comment

by:BillTr
ID: 22811824
Hi Sjef,
 I build CURGROUP by doing a fieldgettext on 3 fields on the form and then concatenating the 3 text strings. Could I add these to an array and then pass the array to your function?
0
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 500 total points
ID: 22811956
If a field is a multi-value field, you'd get an array immediately if you use NotesDocument.GetItemValue("Field1")

Example:
Dim v As Variant

v= doc.GetItemValue("Field1")
v= ArrayAppend(v, doc.GetItemValue("Field2"))
v= ArrayAppend(v, doc.GetItemValue("Field3"))

Call QuickSort(v, 0, Ubound(v))
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 22872271
Sorted?  ;-)
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question