[Leaplist] OpenOffice MailMerge Conditional Equations

[Fred Moore]

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

things like.

database.table.field EQ "123"   
or
database.table.field == "123"

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


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


.. Fred




Bruce Metcalf wrote:
> Gang,
>
> I know I posted about this before, but either the wisdom didn't sink
> in or the software has changed (again). Sorry if this is a repeat:
>
> I'm trying to print a form letter using OpenOffice Writer, pulling
> data from OpenOffice Base. This is a renewal form for several
> different organizations, and has to be tailored depending on which
> groups someone is a member of and if they have paid their dues yet.
>
> So far, I've been able to use the "Hidden Paragraph" feature to hide
> irrelevant lines. I can also set the condition to be
> (Fieldname=="constant") to select lines appropriate only for some
> classes of member. These are working fine.
>
> The problem is that any equation other than == or <> fails to work.
> The big issue is with the magazine. I want to print one line if
> (Subscription<"118"), another if (Subscription>"121"), and a third if
> ((Subscription>"117)and(Subscription<"122")). Yeah, I know it's
> reverse logic in OOo, but that's not the source of the trouble.
>
> None of the OOo guides, manuals, wikis, or homebrew cheat sheets have
> a list of recognized operators. I've seen examples of ==, <>, and EQ,
> and suggestions that OR, AND, and NOT work. Nothing definitive, and
> nothing at all on operators like >, <, >=, <=, GT, LT, GE, or LE,
> which would be really helpful here.
>
> Any and all answers, ideas, suggestions, and links will be appreciated.
>
> Bruce
>


-- 
Lots of soaring generalities, without a single hard fact in sight. Saves 
the trouble of having to do research.
Fred/WD8KNI