[Leaplist] OpenOffice MailMerge Conditional Equations

[Bruce Metcalf]

Fred Moore wrote:

 > inside OO
 > F1
 > index
 > insert this search term
 > conditions;in fields and sections
 >
> make sure you read the portion on 'Conditions and Database Fields"
> ... I think this is what you really want to use.

Yup, it sure is. Unfortunately nothing in that section refers to any 
operators but ==, !=, null, and not-null. I need numeric comparators to 
select the right subscription notices.


 > and as we discussed before.. field names must be valid field names..

Right. Purged all of the spaces and non-alphanumeric characters from 
field names after the last round.


> BTW.. this has been broken off and on during the last several
> releases.. make sure you are using something later than OO 2.2..

Version 2.4.1 at the moment. Latest available from the lenny repository.


 >> The problem is that any equation other than == or <> fails to work.
 >>
 >> None of the OOo guides, manuals, wikis, or homebrew cheat sheets
 >> have a list of recognized operators. I've seen ... suggestions that
 >> OR, AND, and NOT work. Nothing definitive, and nothing at all on
 >> operators like >, <, >=, <=, GT, LT, GE, or LE....

I'll settle for someone telling me that these comparator functions 
definitely don't work in OOo. At least then I can believe that my time 
spent developing workarounds isn't completely wasted.

Thanks again Fred,
Bruce

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.