Display pictures from a database field

[jeffcullina]

I have a web set up to interract with a database using input forms, edit forms and reports. I would like to extend the capability of these forms to handle pictures. In access, I have set up a field in my table with the OLE object type. Using Access forms, I am able to select pictures to enter into the table, which are subsequently viewable. I would like to implement this feature on ASPs that I am building through Front Page. I have found plenty of help for pictures used as backgrounds or buttons, but I cannot find a field control for bound OLE or picture objects. I would appreciate any help on selecting the appropriate control and implementing the control so that the user is able to browse for, then upload a picture via that control.

 

[artdirectoreric]

<img border=&quot;0&quot; src=&quot;images/<%=FP_FieldLink(fp_rs,&quot;cover&quot;)%>&quot; align=&quot;right&quot;>

is how the code looks in my pages, where cover is the name of the field that contains the image name of a magazine cover.

In FP, in the database display area, you'll delete the column value for your image, pull an image into your display area (which image it is is unimportant), right click on it and go to Picture Properties, then go to Browse... and find the folder that contains the images you want displayed. Then hit Parameters in that same area and in the Path section at the top you'll replace the name of the image listed by hitting Insert Field Value and choosing the field name that contains your images. Ok out of it and you should be set.