Database Photos

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using FP 2002 w/ Access 2000. Have successfully got photos linked per
KB318813 and they show just fine. Have the original photos, but they are
cropped and resized in order to fit a particular table layout. Now, is it
possible to link the photos to the originals so a viewer can enlarge them, as
if you had them in thumbnails ?

Thanks,
 
Clarify
You are displaying some sort of reduced size image (say images/small_image.jpg) from your DB, and want it linked to a larger image
(say images/full_image.jpg)?
- in which case both image names would need to be in your DB as 2 different fields (as say FavoriteImage and FullImage)
Or are you displaying a larger image (say images/full_image.jpg) from your DB but w/ height/width set less than full size?
- in which case you only need the 1 image name in your DB as 1 field (as say FavoriteImage)

And where do you want to display the larger image, in the same page or in another page or popup?

If your smaller image FavoriteImage is displayed in the results using say:
<img src="<%=FP_FieldVal(fp_rs,"FavoriteImage")%>">
Your link (to a new "page" w/ just the full size image FullImage) would be something like:
<a href="<%=FP_FieldVal(fp_rs,"FullImage")%>" target="_blank">
<img src="<%=FP_FieldVal(fp_rs,"FavoriteImage")%>">
</a>

--




| Using FP 2002 w/ Access 2000. Have successfully got photos linked per
| KB318813 and they show just fine. Have the original photos, but they are
| cropped and resized in order to fit a particular table layout. Now, is it
| possible to link the photos to the originals so a viewer can enlarge them, as
| if you had them in thumbnails ?
|
| Thanks,
| --
| samG
 
Stefan, thanks for responding. All photos (1 per record in the db) have been
resized via Photo Shop Pro to accommodate the desired table layout. I link
to these photos via the picture properties using
<img border="0" src=<%=FP_FieldLink(fp_rs,"Photo")%>
I would like to be able to link the display photos to the original sized
photos with just a mouse click on the displayed photo (similar to what a
thumbnail photo does) and have it show in a new screen (just like the
thumbnails do now). Is this possible without having to insert a second photo
entry into the db ? If I could create a thumbnail on the fly that would be
great, then I would use the original sized photos, but I don't think this is
possible.
 
You can create a thumbnail image using the large image just by setting the width value, say 125
pixels for the thumbnail to be displayed on your page.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Thanks Stefan and Thomas for your input. Playing around I found another way
to accomplish the task. First, I will use only full size photos, loading
each with the size required for the table layout via using the Picture
Properties. Then, under or on top of the picture have "Click to enlarge"
with the same db link as I have in the
Picture Properties. It works just great. Thanks again.
 
It works
- but it is bad for your users / bandwidth
- your page load time will be for the full size images (not the displayed size) and may take forever to open

IMHO
add the smaller "thumbnail" images back to your site in addition to the full size images

You can also use the same DB field if you really need to,
- rename all of your "thumbnail" size images consistently by a constant prefix as say "sm_fullimagename.jpg", where
"fullimagename.jpg" is the real name for your each of your full size images in the DB field named "Photo"

Your link would then be
<a href="<%=FP_FieldVal(fp_rs,"Photo")%>" target="_blank">
<img src="<%="sm_" & FP_FieldVal(fp_rs,"Photo")%>"></a>
Which would result in an actual link for a Photo named fullimagename.jpg as
<a href="fullimagename.jpg" target="_blank">
<img src="sm_fullimagename.jpg"></a>
--




| Thanks Stefan and Thomas for your input. Playing around I found another way
| to accomplish the task. First, I will use only full size photos, loading
| each with the size required for the table layout via using the Picture
| Properties. Then, under or on top of the picture have "Click to enlarge"
| with the same db link as I have in the
| Picture Properties. It works just great. Thanks again.
| --
| samG
|
|
| "samG" wrote:
|
| > Using FP 2002 w/ Access 2000. Have successfully got photos linked per
| > KB318813 and they show just fine. Have the original photos, but they are
| > cropped and resized in order to fit a particular table layout. Now, is it
| > possible to link the photos to the originals so a viewer can enlarge them, as
| > if you had them in thumbnails ?
| >
| > Thanks,
| > --
| > samG
 
You can also accomplish the same by inserting the same code for Picture Source
<%=FP_FieldLink(fp_rs,"Photo")%> into the Location for Default HyperLink in
the Picture Properties, but you still have to tell the viewer somewhere to
click it since the picture will not give any hint that there is a link. It
works great either way. Thanks Stefan for the hint in your initial response.
 
If the large images are optimized correctly, then there is no reason to have to have a thumbnail
version as well as a large version, just the large version is needed.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Back
Top