<span style='font-family:Verdana'><span style='font-size:12px'><span style="font-family:verdana;"><span style="font-size:12px;">I have an image stored in MSQL.(Don't tell me its not proper do that,I know already).Anyways I need to display it in DTML.</span></span><br />
<td align="left" nowrap="1" valign="top">
        <br />
        StockChartManagePreview (DTML)<br />
        <br />
        <dtml-var standard_html_header><br />
        <img src="StockChartManagePreview_Handler"><br />
        <dtml-var standard_html_footer><br />
        <br />
        StockChartManagePreview_Handler (python script)<br />
        <br />
        request = container.REQUEST<br />
        response = request.RESPONSE<br />
        photo = context.StockChartManage_getImage(ID = 6666)<br />
        context.REQUEST.RESPONSE.setHeader('content-type','image/jpeg')<br />
        return photo[0].image.read()<br />
        #I already tried - return photo[0].image<br />
        #it gives an error image cannot be displayed because it contains errors<br />
        <br />
        <br />
        StockChartManage_getImage (Z SQL Method)<br />
        <br />
        SELECT image<br />
        FROM `imagebase`<br />
        WHERE imageID =<dtml-sqlvar ID type="string"><br />
        <br />
        <br />
        Now my problem is that Zope asks for a login every time I view the DTML (StockChartManagePreview )<br />
        <br />
        Please Help.<br />
        <br />
        ref : <a href="https://mail.zope.org/pipermail/zope-db/2004-July/003336.html" target="_blank">https://mail.zope.org/pipermail/zope-db/2004-July/003336.html</a><br />
         <a href="http://www.zope.org/Members/murphy/MySQL-BLOBs" target="_blank">http://www.zope.org/Members/murphy/MySQL-BLOBs<br />
        http://www.gossamer-threads.com/lists/zope/db/168437</a><br />
        <br />
        Ā </td>
<td align="left" valign="top">
        Ā </td>
</span></span>