<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 /> 
        &lt;dtml-var standard_html_header&gt;<br /> 
        &lt;img src="StockChartManagePreview_Handler"&gt;<br /> 
        &lt;dtml-var standard_html_footer&gt;<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 =&lt;dtml-sqlvar ID type="string"&gt;<br /> 
        <br /> 
        <br /> 
        Now my problem is that Zope asks for a login every time I view the DTML&nbsp;(StockChartManagePreview &nbsp;)<br /> 
        <br /> 
        Please Help.<br /> 
        <br /> 
        ref :&nbsp;<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 /> 
        &nbsp; &nbsp; &nbsp; &nbsp;<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>