display a picture

[david]

I found this article by Microsoft:

How to display a picture by using an Access database in FrontPage 2000.
http://support.microsoft.com/kb/216285/en-us

I cannot get the technique described to work with FrontPage 2003, however.

Is there a follow up article on this for FP2003?

David

 

[Stefan B Rusynko]

Only an update for FP 2002
http://support.microsoft.com/kb/318813
and for FP 2003
http://support.microsoft.com/default.aspx?scid=kb;en-us;825515

But they are essentially the same
What's not working?




| I found this article by Microsoft:
|
| How to display a picture by using an Access database in FrontPage 2000.
| http://support.microsoft.com/kb/216285/en-us
|
| I cannot get the technique described to work with FrontPage 2003, however.
|
| Is there a follow up article on this for FP2003?
|
| David
|
|

 

[david]

That was helpful!
The old article does not show how to insert a picture (Insert -> picture ...).
The new one does, and I was able to do all the steps described.

But I still can't get it to work completely. Tthe browser shows a red x in
square box in the browser instead of picture.

Here is the html for the picture field (produced by FrontPage):
<img border="0" src="<%=FP_FieldLink(fp_rs,"ImageName")%>">

I wonder if my paths are correct.
The mdb file and the picture files are all placed directly under the fpdb
folder.
In the database query, the content of the picture field (ImageName) is
simply the file name, like this: picture.jpg.

David

 

[Stefan B Rusynko]

The example uses a path in the DB field:
images/imagename.gif
That means the page (using the DB) is in the root and the images are in the images folder under the root (not in the fpdb folder)
If your pages or images are at a different level or folder you will have to adjust the path in the DB field



| That was helpful!
| The old article does not show how to insert a picture (Insert -> picture ...).
| The new one does, and I was able to do all the steps described.
|
| But I still can't get it to work completely. Tthe browser shows a red x in
| square box in the browser instead of picture.
|
| Here is the html for the picture field (produced by FrontPage):
| <img border="0" src="<%=FP_FieldLink(fp_rs,"ImageName")%>">
|
| I wonder if my paths are correct.
| The mdb file and the picture files are all placed directly under the fpdb
| folder.
| In the database query, the content of the picture field (ImageName) is
| simply the file name, like this: picture.jpg.
|
| David
|
|
|
|
|
|
|
|
| "Stefan B Rusynko" wrote:
|
| > Only an update for FP 2002
| > http://support.microsoft.com/kb/318813
| > and for FP 2003
| > http://support.microsoft.com/default.aspx?scid=kb;en-us;825515
| >
| > But they are essentially the same
| > What's not working?
| >
| > --
| >
| > _____________________________________________
| > SBR @ ENJOY (-: [ Microsoft MVP - FrontPage ]
| > "Warning - Using the F1 Key will not break anything!" (-;
| > To find the best Newsgroup for FrontPage support see:
| > http://www.net-sites.com/sitebuilder/newsgroups.asp
| > _____________________________________________
| >
| >
| > | I found this article by Microsoft:
| > |
| > | How to display a picture by using an Access database in FrontPage 2000.
| > | http://support.microsoft.com/kb/216285/en-us
| > |
| > | I cannot get the technique described to work with FrontPage 2003, however.
| > |
| > | Is there a follow up article on this for FP2003?
| > |
| > | David
| > |
| > |
| >
| >
| >

 

[Ronx]

The path to the image should be relative to the asp page, not the database,
or should be absolute.

Try
<img border="0" src="fpdb/<%=FP_FieldLink(fp_rs,"ImageName")%>">

which assumes the asp page is in the root folder.

This will probably fail as well because normal permissions on the fpdb
folder prevent files being downloaded. Move the images to another folder,
and change the path accordingly.

 

[david]

Thank you both Ron, Stefan,
With your combined inputs, I was able to do what I need - i.e. display image
and other fields.
And yes, I had to put it under a folder other than fpdb.
The comment that path are relative to where the page is located is helpful.
David