Ubuntu
openoffice.org package

Open Office Base and MySQL BLOB Fields

Asked by Alan Jenkins

I am currently creating a MySQL database that has an Image field in it which is a type of BLOB field. However I have found no way of inserting an image into the image field using Open Office Base.

I have looked at all the documentation that I could find and I have found no mention of how to input images or any other type of data into a BLOB field. I have tried selecting the image and dragging it into the image into the image field however that does not seem to work and there is no other menu based ways of entering the image into the image field that I could find.

Can someone enlighten me on how to input an image into the database?

Thanks,

Alan Jenkins

Question information

Language:
English Edit question
Status:
Solved
For:
Ubuntu openoffice.org Edit question
Assignee:
No assignee Edit question
Solved by:
Mariano Mara
Solved:
Last query:
Last reply:
Revision history for this message
Launchpad Janitor (janitor) said : 		#1

This question was expired because it remained in the 'Open' state without activity for the last 15 days.

Revision history for this message
Alan Jenkins (alan-james-jenkins) said : 		#2

I have still not found any way of entering BLOB data into the database using openoffice base and have had to use the Mysql query browser to insert images instead. I would really like to use base as an all in one
tool for manipulating databases is there any way of inputting data into a blob field using base?

Revision history for this message
Best Mariano Mara (marplatense) said : 		#3

I've been searching your problem a little bit and checked a few pages in german and french (that google translator can't really do a good job) and it seems everyone says that this is the right way of doing it: http://dba.openoffice.org/servlets/ReadMsg?list=dev&msgNo=1530

In this document, http://www.pitonyak.org/database/AndrewBase.odt , that author teaches how to do it with pure OO macros (page 9): it talks about storing it locally in the OO base but I guess you can modify the code to make it accept a mysql connection.

Revision history for this message
Alan Jenkins (alan-james-jenkins) said : 		#4

Thanks Mariano Mara, that solved my question.

Revision history for this message
Alan Jenkins (alan-james-jenkins) said : 		#5

Thanks for the information on how to insert blob data Mariano. Shame there doesn't yet seem to be an easier way of inserting blob information yet however this is still what I was after. Thanks a lot.