Mail Merge: When a field is empty... problem

[coume]

Hello,

I created a letter that I fill up thanks to the database features.
but there is a problem.

When I ask to print the letter, if some fields where empty in the DB, it prints me the fields nam I.E
Position: <POSITION>
when I would like to get Position: "Follow by nothing as it was an empty field..."

Any idea how to do so??

Thxs in advance
Ludo

[JohnV]

I presume you don't have View > Fields turned on.

I have never experienced this problem but there was just a thread in the SO forum about it. The final answer, from a Sun employee, was that this will occur if your Data Source name contains a space. Could this be your problem?

[redrgreen]

I think this only happens when your query does not return the field in question, not when the data in the filed is empty, e.g in the case of the field <position>
if your query was SELECT firstname, surname FROM table, and you had a texfield called position in your letter then when it printed you would see <position> in the printed letter. however if your query was SELECT firstname, surname, position FROM table then even is position contains no data you will no longer see <position> but instead its value in this case an empty string, ie nothing.

[coume]

[coume]