extracting from Access

Results 1 to 2 of 2

Thread: extracting from Access

  1. #1
    Join Date
    Dec 1969

    Default extracting from Access

    I have read the tutorial on extracting pictures from database to the web on this site. I followed them correctly and still nothing happens, no picture.... here is my code....maybe there is something i dont see, but any ideas on extracting a picture enbedded in the database to display on the web would be appreciated....<BR><BR>&#060;%<BR>Response.Buffer = true<BR>Set con = Server.CreateObject("ADODB.Connection")<BR>Set rst = Server.CreateObject("ADODB.Recordset")<BR>con.open "eq_DB"<BR>rst.Open "SELECT * FROM STK36",con,adOpenKeyset,adLockOptimistic<BR>rst.Mo veFirst<BR>DO Until rst.EOF<BR><BR>Response.ContentType = "imagejpg"<BR>Response.BinaryWrite rst("name")<BR><BR>rst.MoveNext<BR>Loop<BR>rst.Clo se<BR>Set rst = Nothing<BR>con.Close<BR>Set con = Nothing<BR>%&#062;

  2. #2
    Join Date
    Dec 1969

    Default RE: extracting from Access

    It&#039s been my experience that storing pictures in a database causes more trouble than it&#039s worth. I&#039ve found that the best and quickest way to do it is to store the images in a folder on the web server and then just store the links to those images in the database. That&#039ll make your life a whole lot easier.<BR><BR>Peter

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts