RE: [Zope] MySQLDA and images beeing corrupted

2001-01-12 Thread Max Møller Rasmussen

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

>Any ideas?
>I feel like I am *so* close to making this work!

It sounds like you have some sort of escape problem, with special characters
being handled as text.

Don't you have to treat the image as text when inserting them into mySQL and
then escape special characters? I betcha there is a special function for
that. Try it.

regards Max M

___
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 )




Re: [Zope] MySQLDA and images beeing corrupted

2001-01-12 Thread Phil Harris

Change your dtml to:


  
  
  


hth

Phil



- Original Message -
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, January 12, 2001 12:18 PM
Subject: [Zope] MySQLDA and images beeing corrupted


>
> I am using Zope 2.3a2, and MySQLDA 1.1.3, with one patch installed (it was
> supposed to fix problems with autoincrement fields)
>
> Everything is installed, with no apparent problems.
>
> I would like to store images as BLOBs in a MySQL database (version 3.22)
>
> I am able to store the images in the database, but somehow, along the way,
> they become corrupted, and show up in the browser as a corrupted image.
> I can, howover, recognize some of the features of the original image. The
> top part is mostly intact, and the colours seem right.
>
> The image is retreived from the database like this: method named "image",
> with everything *on one line*.
>
> 
> 
> 
> 
> 
>
> With "hent-bilde" as follows:
>
> select * from bilder
> where
> 
>
> The URL used is: "/image?id=10"
>
>
> The image is stored in the database as follows:
>
>
> insert into bilder
> (bildefil, kilde, kommentar, bildetype)
>
> values (
>
> ,
>
> ,
>,
> 
>);
>
>
>
> Any ideas?
>
> I feel like I am *so* close to making this work!
>
>
> Åsmund Hjulstad
>
>
>
> ___
> 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 )


___
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 )