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

MySQL BLOB Datatype in Report

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


Joined: 23 Aug 2005
Posts: 4

PostPosted: Tue Aug 23, 2005 8:43 pm    Post subject: MySQL BLOB Datatype in Report Reply with quote

For a Church Members address book

The current situation

I have built a mysql database/php pages combo where members are able to search for other members and view a family photo, email address, address details, phone, etc. The photo in the database in a photos table as shown below. Some photos are used across more than one member where spouses or kids are also members etc.

The structure of the database is
tblmembers:
- id(int)
-surname (varchar)
-firstname (varchar)
-offspring (varchar)
-address (varchar)
-more fields...
-photoid(int)

tblphotos
-id(int)
-filename(varchar)
-type(varchar)
-size (int)
-content (mediumBLOB)

The php pages work.

The Problem:
I now want to be able to print a report using Base (or otherwise) showing the family photos alongside the members details.

I have linked base to mysql and am able to view and report using all the fields except for the Blob in tblphotos.

The report wizard says that Binary data cannot be shown in a report. Can anyone suggest a way that I can get around this?
_________________
Some are Wise, Some Otherwise
Back to top
View user's profile Send private message
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