How to show images from access database

[Krechting]

Hi all,

I'm new in ASP so,
I have an access db with a table called IMAGES.
It has two fields (IID and ImagePathAndFile).
IID has the ID of the main table WEAPON and ImagePathAndFile holds
the path to an images on the HD.

I want a new window to popup with the image when i click on the name
of the corresponding weapon in a list with search results.

Hope someone knows what i mean

Marco
The Netherlands

yea, just make an output into your html, like <img
src="<%=yourRecordset("yourfield")%>"/> if the file has just virtual path.
or if its phisical one, just do the "conversion" to virtual paht before
insering it into @src attrib.

cheers,
--
<spider/>
*For live help you can find me on #wdk within DalNET IRC

"Krechting" <m.krechting@chello.nl> wrote in message
news:a71c776d.0312211502.70af0a7b@posting.google.c om...
: Hi all,
:
: I'm new in ASP so,
: I have an access db with a table called IMAGES.
: It has two fields (IID and ImagePathAndFile).
: IID has the ID of the main table WEAPON and ImagePathAndFile holds
: the path to an images on the HD.
:
: I want a new window to popup with the image when i click on the name
: of the corresponding weapon in a list with search results.
:
: Hope someone knows what i mean
:
: Marco
: The Netherlands

[Krechting]

Tnx Spider,

But I don't think it is that easy.
Lets say I have a grid with some search results.
One of the fields is the path to the image. You see I have two tables
which are linked thru the ID field. So the WEAPON table ID is the same
as the IMAGES tables IID. If they match we have the right images.
So I'm not inserting an images in the code, it's just a hyperlink which
has to open a new form showing the image behind the path.

Regards,

Marco


"<spider/>" <spiderNOSPAM@kipr.net> wrote in message news:<bs5lq4$9j7gb$1@ID-155519.news.uni-berlin.de>...

> yea, just make an output into your html, like <img
> src="<%=yourRecordset("yourfield")%>"/> if the file has just virtual path.
> or if its phisical one, just do the "conversion" to virtual paht before
> insering it into @src attrib.
>
> cheers,
> --
> <spider/>
> *For live help you can find me on #wdk within DalNET IRC
>
> "Krechting" <m.krechting@chello.nl> wrote in message
> news:a71c776d.0312211502.70af0a7b@posting.google.c om...
> : Hi all,
> :
> : I'm new in ASP so,
> : I have an access db with a table called IMAGES.
> : It has two fields (IID and ImagePathAndFile).
> : IID has the ID of the main table WEAPON and ImagePathAndFile holds
> : the path to an images on the HD.
> :
> : I want a new window to popup with the image when i click on the name
> : of the corresponding weapon in a list with search results.
> :
> : Hope someone knows what i mean
> :
> : Marco
> : The Netherlands

[Jeff Cochran]

On 22 Dec 2003 01:10:56 -0800, [email]m.krechting@chello.nl[/email] (Krechting)
wrote:

>But I don't think it is that easy.
>Lets say I have a grid with some search results.
>One of the fields is the path to the image. You see I have two tables
>which are linked thru the ID field. So the WEAPON table ID is the same
>as the IMAGES tables IID. If they match we have the right images.
>So I'm not inserting an images in the code, it's just a hyperlink which
>has to open a new form showing the image behind the path.

That's actually quite simple, but it's client side code, not ASP. If
you already can retrieve the record of the path, check a HTML or
Javascript group for opening a link in a new window (or Google "open
link in new window").

Jeff

>"<spider/>" <spiderNOSPAM@kipr.net> wrote in message news:<bs5lq4$9j7gb$1@ID-155519.news.uni-berlin.de>...

>> yea, just make an output into your html, like <img
>> src="<%=yourRecordset("yourfield")%>"/> if the file has just virtual path.
>> or if its phisical one, just do the "conversion" to virtual paht before
>> insering it into @src attrib.
>>
>> cheers,
>> --
>> <spider/>
>> *For live help you can find me on #wdk within DalNET IRC
>>
>> "Krechting" <m.krechting@chello.nl> wrote in message
>> news:a71c776d.0312211502.70af0a7b@posting.google.c om...
>> : Hi all,
>> :
>> : I'm new in ASP so,
>> : I have an access db with a table called IMAGES.
>> : It has two fields (IID and ImagePathAndFile).
>> : IID has the ID of the main table WEAPON and ImagePathAndFile holds
>> : the path to an images on the HD.
>> :
>> : I want a new window to popup with the image when i click on the name
>> : of the corresponding weapon in a list with search results.
>> :
>> : Hope someone knows what i mean
>> :
>> : Marco
>> : The Netherlands