Basically, how does one go about doing this? I have a database of cars, 

which consists of their make, model, registration etc. What I want to do is 

have a jpg photograph of the car as part of the record set. Can this be 

done ?

Alternatively how would I produce a page that would show the details from 

the record set and add the image from an images folder, using say the 

registration number as the name of the photo.

Any help is greatly appreciated. Perhaps someone knows of a tutorial or 

piece of code to do this on the web.

I've never tried this, but maybe this might help. Store the relative path

of the file that you want in the database. In your ASP page, retrieve the

path of the file, but put that variable into an image tag.



Something like this:



<IMG SRC=3D"<%Path from Database%>">



Let me know if this works. I was doing something similar retrieveing email

address. I used the mailto tag so not only will the ASP page display the

email address, but it made it clickable.



Hope this helps,



Jeff Ciesla



>>>>>>

Basically, how does one go about doing this? I have a database of cars,

which consists of their make, model, registration etc. What I want to do 

is

have a jpg photograph of the car as part of the record set. Can this be

done ?

Alternatively how would I produce a page that would show the details 

from

the record set and add the image from an images folder, using say the

registration number as the name of the photo.

Any help is greatly appreciated. Perhaps someone knows of a tutorial or

piece of code to do this on the web.



---

You are currently subscribed to asp_databases

Why do you want to do this?



Unless you have a good reason to do this (and I can't think of any of the

top of my head) store a URL in the database and use that to load the picture

into a HTML page.



AFAIK there's no real benefit to storing images in a database - there's

overhead getting the data in and out, and you can't sort the data in any

way, and it bloats your database...



Cheers

Ken



----- Original Message -----

To: ASP Databases <asp_databases@p...>

Sent: Thursday, April 20, 2000 12:00 AM

Subject: [asp_databases] Images in an access database





> Basically, how does one go about doing this? I have a database of cars,

> which consists of their make, model, registration etc. What I want to do

is

> have a jpg photograph of the car as part of the record set. Can this be

> done ?

> Alternatively how would I produce a page that would show the details from

> the record set and add the image from an images folder, using say the

> registration number as the name of the photo.

> Any help is greatly appreciated. Perhaps someone knows of a tutorial or

> piece of code to do this on the web.

>

With the code of the automobile you can create a link to the image that is

located in a directory of images in your place. To achieve this the

following thing it should be made: -the visualized registrations of your

catalog of automobiles should be created with a link where it shows their

specifications and characteristic and to include an image square where scr 

"access route to imagenes\<%=request.querystring (it names of the variable

correspondent as parameter from the catálogo(ej:IDCAR)")%> .jpg"



That is everything.



I wait it serves you



Gabriel Hernández

Santiago, CHILE

----- Original Message -----

From: Ken Schaefer <ken.s@a...>

To: ASP Databases <asp_databases@p...>

Sent: Saturday, April 22, 2000 9:24 AM

Subject: [asp_databases] Re: Images in an access database





> Why do you want to do this?

>

> Unless you have a good reason to do this (and I can't think of any of the

> top of my head) store a URL in the database and use that to load the

picture

> into a HTML page.

>

> AFAIK there's no real benefit to storing images in a database - there's

> overhead getting the data in and out, and you can't sort the data in any

> way, and it bloats your database...

>

> Cheers

> Ken

>

> ----- Original Message -----

> To: ASP Databases <asp_databases@p...>

> Sent: Thursday, April 20, 2000 12:00 AM

> Subject: [asp_databases] Images in an access database

>

>

> > Basically, how does one go about doing this? I have a database of cars,

> > which consists of their make, model, registration etc. What I want to do

> is

> > have a jpg photograph of the car as part of the record set. Can this be

> > done ?

> > Alternatively how would I produce a page that would show the details

from

> > the record set and add the image from an images folder, using say the

> > registration number as the name of the photo.

> > Any help is greatly appreciated. Perhaps someone knows of a tutorial or

> > piece of code to do this on the web.

> >

>

>

>

> ---

> You are currently subscribed to asp_databases


$subst('Email.Unsub')

>