View Pictures

[choobakka]

i have embedded some jpg pictures in an MS Access Database. How can i extract these and display them on a web page using ASP/ADO? i have looked at the ASP and ADO tutorials on the site but the coding does not seem to extarct pictures, only text from an Access tabel.thanks in advance

[netcracker]

i have looked at the ASP and ADO tutorials on the site but the coding does not seem to extarct pictures, only text from an Access tabel.

<{POST_SNAPBACK}>

it's all the same...have it something like this:

... bla bla ...'open connection to db that has the fields containing the path of the imageid = request (id)set conn = server.createobject("adodb.connection")conn.Provider="Microsoft.Jet.OLEDB.4.0"conn.Open(Server.mappath("database_name.mdb"))set rs = server.createobject("ADODB.recordset")rs.open "select * from table_name where id = ' id ' "", conn... bla bla ... and finally<img src='<%=rs("field_name")%>' ... ><< rs("field_name") >> is the field with the path

you shuld get the ideea