Is there a particular reason why you want to save the image _in_ the database. Why not just save the name of the imagefile, its path, its width and height etc. as text in an M$ Access database? One advantage of that is that you can store a desciption (authorname, and other info) together with the image entry. You could then pull all of this out to create your own <dtml-var variable> <dtml-in "sqlSelectAllImageFromAccess"> <img src="<dtml-var path_field>/<dtml-var imagefile>" width="<dtml-var width_field" etc...> </dtml-in> This can of course be made simpler and tweaked, maybe even through a Python module. Again; if you definitly want to save it as an OLE in Access, discard. -----Original Message----- From: zope-admin@zope.org [mailto:zope-admin@zope.org]On Behalf Of Terry Kerr Sent: 02 June 2000 04:44 To: zope@zope.org Subject: [Zope] images in access database Hi, 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? terry. -- ----------------------------- Terry Kerr (terry@adroit.net) Adroit Internet Solutions http://www.adroit.net/ 03 9563 4461 0414 938 124 _______________________________________________ Zope maillist - Zope@zope.org 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 )