I would like to be able to have gifs/jpgs stored in an MS access
database and then pull the out using zope and display them in rendered
documents. I am completely new to access. I have successfully
installed the ODBCDA into zope, and are able to connect to an access
database and pull ordinary text data out of tables.
I have created a table in access with a column of type 'OLE object' and
put a gif image in as data. This is the only way I know how to get an
image into the table. The problem I think with this is that it is a
link to the gif on the HDD, and doesn't actually have the data in the
table? Anyway, when I pull the data out of the table from zope, access
puts a header and footer around the gif binary data, and hence a simple
dtml-var blah wont work to display the image. Has anyone else every
pulled images from an access database. Will I have to write a method to
strip the header and footer from the returned data before displaying the
gif?
Um, in general you'd have to have very strong reasons to put large objects
like images in a database (especially in Access). This has a negative effect
on the performance of your application as it adds to the overhead (putting
another layer between your webserver and your image retrieval). I don't see
what the gains would be.
If you consider putting image descriptions in your database, do so and no
more. Put the images on a filesystem somewhere and make your database
records point to them. This is much easier and much faster.
If the number of images is large you may have to do some thinking about the
directory structure.
hth
Rik
___
Zope maillist - [EMAIL PROTECTED]
http://lists.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://lists.zope.org/mailman/listinfo/zope-announce
http://lists.zope.org/mailman/listinfo/zope-dev )
