[Zope] Help! publishing Images from a Database

[Joh Johannsen]

This works with mysql:

1. make mysql table with a LONGBLOB field for holding the image, suppose you
make it a field called "imageData"

2. in your DTML, do this (assume getImage gets the image you want)

<dtml-in getImage>
 <dtml-call "RESPONSE.setHeader('content-type','image/png')">
 <dtml-return imageData>
</dtml-in>

The retrieve, etc. things you mentioned are just sql, displaying it is the
tricky part!

Regards,

JJ

Mohan Baro wrote:

> Can anyone help me to
>
> I want to know how I can publish images stored in a SQL database.
>
> I am trying to create an online photo album that stores images in a
> database.
> The features I want to implement are:
>
> RetrieveImage, UpdateImage, InsertImage
>
> I am running zope on linux mandrake and use ZSever
> The database I am currently using is MySQL on MySQLDA (MySQLdb non-binary
> dist.)
>
> Mo.
>
> _______________________________________________
> 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 )