Get Image from Access database

[mazdaman]

I have the following code but as Im a new to this im getting a bit mixed up. Will the following code get the image from my database, the image is held in a table field name of "picname" Any ideas ...

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="32%" valign="top"><%Response.Write(<img src=../data mem_detail.Fields.Item("picname").value)%> </td>
<td width="64%" valign="top" class="blueheaderlge"><%=(mem_detail.Fields.Item("firstname").Value)%>&nbsp; <%=(mem_detail.Fields.Item("surname").Value)%>
<table width="100%" border="0" cellpadding="0" cellspacing="0" class="blacklage">
<tr>
<td><%=(mem_detail.Fields.Item("dob").Value)%> - <%=(mem_detail.Fields.Item("dod").Value)%></td>
</tr>
</table></td>
</tr>
</table>

 

[FesterSXS]

nearly - try this...

<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
  <td width="32%" valign="top"><img src="../data/<%=mem_detail("picname")%>"></td>
  <td width="64%" valign="top" class="blueheaderlge"><%=mem_detail("firstname") & "&nbsp;" & mem_detail("surname")%>
  <table width="100%" border="0" cellpadding="0" cellspacing="0" class="blacklage">
  <tr>
    <td><%=mem_detail("dob") & " - " & mem_detail("dod")%></td>
  </tr>
  </table>
  </td>
</tr>
</table>

Tony

http://www.SpiraxSarco.com