Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2003
    Location
    new zealand
    Posts
    17

    Unanswered: image appear via msaccess db on .asp pages....???

    hi there world,

    I have an msaccess database with a field/column for product images. I want these images to appear on my webpages. I have successfully got all other fields to appear (i'm using dreamweaver mx .asp pages) but the image field appears as a square with red x in it !.

    in the .asp file, the img srce = <%=(Recordset1.Fields.Item("Image").Value)%>

    ...via a recordset pointing to the databse.

    you can view it at www.relief.co.nz/product.asp


    i have tried the msaccess image field/column to be text and also tried it as a hyperlink ..

    i have had this working before, but forgot to write it down !!!

    thanks, any help appreciated.
    angie.

  2. #2
    Join Date
    Feb 2002
    Location
    North Wales, UK
    Posts
    114
    Try using:
    response.binarywrite RecordSetName("image")
    J^ - web | email
    newsASP Developer

  3. #3
    Join Date
    Feb 2003
    Location
    new zealand
    Posts
    17
    okay I'll try that.

    do i have the msaccess image field set to text or hyperlink ?? and if it is set to text, do i just put the name of the image file e.g. col30.jpg ?

    angie.

  4. #4
    Join Date
    Feb 2002
    Location
    North Wales, UK
    Posts
    114
    Sorry I thought you had physically stored the image in a field.

    Looking at your page source code the field appears to be blank in the table??

    <img name="colimage" src="" alt=""> </font></td>
    The file should be text and should store the path the file file (ie. if the image (product1.jpg) was stored in the img/ folder the value of the field would be img/product1.jpg.

    Ignore my previous post.
    J^ - web | email
    newsASP Developer

  5. #5
    Join Date
    Feb 2003
    Location
    new zealand
    Posts
    17
    thanks for that....all is now working great.
    blondini.

Posting Permissions

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