---------- Forwarded message ---------- From: dimitri pater <[EMAIL PROTECTED]> Date: Sep 5, 2007 9:13 PM Subject: Re: StringIO MySQL data blob Image problem To: Tim Golden <[EMAIL PROTECTED]>
> Well, I'm mystified. Not by your results: that exactly what I > expected to get, but because you're doing everything *except* > manipulating an image and putting it into a PDF via ReportLab. > Dear Tim, you are right of course, I have been trying to put the StringIO in a temp file: cfoto=StringIO cfoto.write(result[0][1].tostring()) dfoto=cfoto.getvalue() fileFoto=open('temp.jpg','wb') fileFoto.write(dfoto) and indeed, the blob from MySQL is saved as an image! however, foto= Image('temp.jpg') and inserting foto into a table results in: x = struct.unpack('B', image.read(1)) error: unpack str size does not match format oh, well... still needs some work BTW: I used 'local' images before (I mean they did not originate from a DB), that worked well in Reportlab's tables. Thanks, I am getting there (I think) -- --- You can't have everything. Where would you put it? -- Steven Wright --- please visit www.serpia.org -- http://mail.python.org/mailman/listinfo/python-list