Display image from Database...

[News]

Hi to all,

I have a database with products and images, all works fine.
However not all products have images so when visitors
click on the article-number that supposed to display
the according image they get to view this 'default' image
with that little red-x on it (image not found).
Is there a way to change this "red-x" image into
some other image i created myself. (e.g. NoImage.jpg or .gif)?
To explain the further,
Database result wizard 'lists' the products with article-number and
smal description. The artcilenumber-field has a link to product-information
page and the there the image will be displayed.
the images have the same name as the article-number.
for example: articlenumber is 12345 then the matching image is 12345.jpg.
This works fine as long as the matching image is available.

I hope anyone can help me with this one, i got about 3000 products to
display
and i do not know which product have or have not got an image.
(I also hope i've explained the problem clear enough.)
Thanks in advance for any help and or idea's.
Arthur.
(sorry crossposting, but i'm not sure what would be the appropriate group
for this)

 

[Kathleen Anderson [MVP - FrontPage]]

If it were me, I would update the database offline to add your own no-image
name to each of the records that don't have their own image. You can sort
the database on that field so that all the records where that field is empty
will float to the top, and then just copy and paste the value into the
field.

You can also make that value the default for the field so that if nothing is
entered, your no-image name will be entered.

 

[News]

Thanks Kathleen,
But the Database itself got no pictures bound to the article number,
the way i "attach" images to the article numbers is the way it is shown
on the microsoft.com website (btw, i got that link from your website i
guess)
In frontpage i just pick a random image on which i will change the
parameters.
eg. http://blablablabaa.nl/img/<%=FP_FieldLink(fp_rs,"Artikelnummer")%>.jpg

So in my .mdb file there is no field called image or something.
My thought is that this "default" red-x image resides somewhere
on the server (not sure)
I was hoping that there would be some lines of script i could add like
a "if then....else".
Anyway thanks again for replying, i also visited your site before for
other DBRW resources, they are a great help.

Arthur

 

[Kathleen Anderson [MVP - FrontPage]]

I don't know how you can test (if .. else) if you don't have a field to
test with. Maybe someone else has an idea.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web: http://www.spiderwebwoman.com/resources/

 

[p c]

That's a good apprach, but it would unessarily bloat the DB file (if you
have a lot of these records)

If you can use script (ASP, PHP etc), you could use a function to run
that peice of reord through. If the item is null, empty or "" (depends
how you implement the field on the database) then then teh uncion should
return the default image stored at you site otherwise reuren the item
(i.e. the image).

...PC