Joined: 23 Aug 2005
|Posted: Tue Aug 23, 2005 8:43 pm Post subject: MySQL BLOB Datatype in Report
|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
The php pages work.
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