[Zope] blob image from MySql
adriano at euma.com
Mon Feb 28 19:04:53 EST 2005
Dear Zope friends,
I can't manage my Zope to correctly serve an image retrieved from a
If the thing has been discussed already, I'm sorry, but I couldn't
find so much help, on line.
I followed indications at http://www.zope.org/Members/murphy/MySQL-BLOBs
I have the following ZSQLMethod, named "trovaImmagine" (in Italian
that means findImage)
select iconmimetype, iconblob from webs where
<dtml-sqltest id op="eq" type="int">
Then, I have a Python script (displayImage2)
# Return a string identifying this script.
record = context.trovaImmagine(id = 1)
data = record.iconblob
contentType = record.iconmimetype
The commented returns are some tests I made.
When I comment the "return data" part and uncomment the "return
contentType" OR "return len(data)", it seems to work correctly
when I try to return "data" I obtain a message error from FireFox, saying:
"The image "http://localhost:8080/sql/displayImage2" cannot be
displayed, because it contains errors."
I tyied with Safari and it downloads a "displayImage2" file , I
rename it to displayImage2.jpg, I try to open it with the Apple
viewer (Anteprima in Italian, I don't remember in English) AND it
says me that the file is not a jpeg file as it seems.
Internet Explorer shows a broken QuickTime icon.
What's going on ?
I'm trying to convince a company to port their little app made of
JSPs to Zope and I am doing some tests.
They have the pictures in some blob fields so this is unavoidable, I think
Thanks so much
" One of the tricks here is to get away from thinking that programs
have to be composed with only a simple text editor "
- Alan Kay -
"Java and C++ make you think that the new ideas are like the old ones.
Java is the most distressing thing to hit computing since MS-DOS".
- Alan Kay -
"The computer revolution hasn't started yet. Don't be misled by
the enormous flow of money into bad defacto standards for
unsophisticated buyers using poor adaptations of incomplete ideas".
-Alan Kay -
More information about the Zope