OpenOffice.org Forum at OOoForum.orgThe OpenOffice.org Forum
 
 [Home]   [FAQ]   [Search]   [Memberlist]   [Usergroups]   [Register
 [Profile]   [Log in to check your private messages]   [Log in

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

 
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base
View previous topic :: View next topic  
Author Message
coume
General User
General User


Joined: 27 May 2003
Posts: 36

PostPosted: Wed May 12, 2004 12:47 am    Post subject: Mail Merge: When a field is empty... problem Reply with quote

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
Back to top
View user's profile Send private message Visit poster's website
JohnV
Administrator
Administrator


Joined: 07 Mar 2003
Posts: 9183
Location: Lexinton, Kentucky, USA

PostPosted: Wed May 12, 2004 10:50 am    Post subject: Reply with quote

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?
Back to top
View user's profile Send private message
redrgreen
General User
General User


Joined: 01 May 2004
Posts: 41

PostPosted: Wed May 12, 2004 1:56 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
coume
General User
General User


Joined: 27 May 2003
Posts: 36

PostPosted: Thu May 13, 2004 3:52 am    Post subject: Reply with quote

JohnV wrote:
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?


Yep my data source name contains spaces... I have to try to modify everything to see if it will solve the thing! argh Sad

I'll keep you updated

Ludo
_________________
http://www.mythTVtalk.com - Where the World comes to speak about MythTV!
Hundreds of MythTV users already joined the community! What are you waiting to be the next one?
Back to top
View user's profile Send private message Visit poster's website
coume
General User
General User


Joined: 27 May 2003
Posts: 36

PostPosted: Thu May 13, 2004 3:53 am    Post subject: Reply with quote

redrgreen wrote:
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.


To add the field, I just make them slide from the data source to my letter, I don't know how to modify the query then...

Ludo
_________________
http://www.mythTVtalk.com - Where the World comes to speak about MythTV!
Hundreds of MythTV users already joined the community! What are you waiting to be the next one?
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OOoForum.org Forum Index -> OpenOffice.org Base All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group