Thank you very much Chris that what a lot of help. As i heve told you i am a niewbie to the whole concept of web and python. "write this data to the RESPONSE object" was a very very big "here is the problem" for me! Some more reading now and i hope i am there for the evil BLOBS. 8-)
Thank you very much! Thomas "Chris Withers" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Thomas G. Apostolou wrote: > > i have made an external method to connect and get data from an sql > > server 2000, and then show them in a table. All works fine but one of > > the columns i retrieve is a BLOB image witch makes my external method > > to crash. So i used z SQL Method (witch is not prefared because there > > is a lot of customization and that's why i used External Method with > > Python from the begining) and it goes fine with retrieving and showing > > the data. But still i cannot show the BLOB image as image. It shows as > > a very very long string. > > You will need to do at least one query for the data and one request for > each of the images. > > eg, you "main method" returns html like: > > <table> > <tr> > <th> > Name > </th> > <th> > Picture > </th> > </tr> > <tr> > <td> > Test User > </td> > <td> > <img src="http://localhost:8080/myproject/getImage?id=1231"/> > </td> > </tr> > </table> > > You then need to implement getImage to: > - do the SQL select to get the image data based on the id > - write this data to the RESPONSE object > (see lib/python/OFS/Image.py's index_html method for an example) > - set a content-disposition header so that the browser does the right > thing > > Hopefully soon you'll realise the fundamental issue with http that > you're bumping into: you don't return a fully rendered page, you return > a page with references in it to css/javascript/image files that are used > to render the final page, and that storing binary data in relational > databases is evil ;-) > > Chris > > -- > Simplistix - Content Management, Zope & Python Consulting > - http://www.simplistix.co.uk > _______________________________________________ > Zope maillist - Zope@zope.org > http://mail.zope.org/mailman/listinfo/zope > ** No cross posts or HTML encoding! ** > (Related lists - > http://mail.zope.org/mailman/listinfo/zope-announce > http://mail.zope.org/mailman/listinfo/zope-dev ) > _______________________________________________ Zope maillist - Zope@zope.org http://mail.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://mail.zope.org/mailman/listinfo/zope-announce http://mail.zope.org/mailman/listinfo/zope-dev )