Re: [Plone-Users] fetching image from Mysql to Page Template

SourceForge Headquarters 225 Broadway Suite 1600 San Diego, CA 92101 +1 (858) 454-5900

hi,
Since, it's still in testing phase, I'm *uploading images* into database 
, using Mysql Insert query, something like :

*     field4 = self.getField('image').get(self)

*    *cursor.execute("INSERT INTO blog_storage (blog_title, blog_descp, 
blog_bodytext, blog_content, blog_rating, blog_imagecaption, 
blog_creationdate) VALUES (%s,%s,%s,%s,%s,%s,%s)", (field1, field2, 
field3, field4, field6, field5, cur_date))*

*For fetching:

*    - i've created ZSql method which will fetch results according to 
query written.
    - then, i've created a page template where i'm trying to call this 
above method/its result, like:

          *<body tal:define="results  here/lanco_method1;
                                            batch 
python:modules['ZTUtils'].Batch(results,

                                                       size=20,

                                                          start=start); ">
                <tal:x repeat="result batch" >

*

        *        <tr>*
        *          <td><span tal:replace="result/blog_descp">blog_descp
        goes  here</span></td>*
        *          <td><span tal:replace="result/blog_title">blog_title
        goes here</span></td>*
        *          <td><span
        tal:replace="result/blog_bodytext">blog_bodytext goes
        here</span></td>*
        *          <td><span
        tal:replace="result/blog_content">blog_content goes
        here</span></td>*
        *          <td><span
        tal:replace="result/blog_rating">blog_rating goes here</span></td>*
        *          <td><span
        tal:replace="result/blog_creationdate">blog_creationdate goes
        here</span></td>*
        *        </tr>*

*              </tal:x>
          </body>

*Here, *lanco_method1* is ZSql method name & *blog_content *is a BLOB 
field in Mysql DB, which i'm tyring to fetch.
But, with this code , it's only fetching source Code & returning this :

*    array('c', '<img src="http://<site-name>/blogs/blog-6/image" 
alt="blog 6" title="blog 6" height="18" width="18" />')*

However, when im testing Method *(ZSql Methd)* , its returning & 
displaying Image, as it is.

Thanks for any suggestions/pointers.

Mikko Ohtamaa wrote:
>
> monks wrote:
>   
>> *However, my requirement is to obviously display this image in Thumbnail 
>> view, on my Page Template.
>> How can i convert this into image ??
>>
>>
>>     
>
> Hi,
>
> Example code how you upload the image and you how you fetch the array would
> probably help to understand your problem.
>
> -----
> Mikko Ohtamaa
> mFabrik - Freedom Delivered.
>
> Web site - http://mfabrik.com
> Mobile site - http://mfabrik.mobi
> Blog - http://blog.mfabrik.com
>   