Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: displaying image link from database.


Message #1 by "Lori Bannon" <lori@s...> on Fri, 20 Dec 2002 22:33:20
Hi all,

I want to display images from the database but figure that it would 
probably be easier if I just have the user enter the path to where the 
image is on a server and store that in the database instead of the whole 
pic. This all sounds good but I can't figure out how to display the image.

This is how I call the record set (when I run the page it displays the 
URL):
<% = oRs.Fields("fldImagePath") %>

This is how I want to display the image:
<% = oRs.Fields("<img src=fldImagePath>") %>

I've tried it a number of different ways but always get errors. This way I 
dont get an error but it just doesn't work.


looks great on paper!
thanks ahead of time.
Message #2 by "Ian: Future Proof Web Dev" <lists@f...> on Fri, 20 Dec 2002 22:34:44 -0000
Hi,
Do
<%
strImagePath =  oRs.Fields("fldImagePath")
Response.Write("<img src=" & strImagePath & ">"
%>

you may have to play around to make sure the "" are in the right place, but
it should work.

cheers

ian
%>
----- Original Message -----
From: "Lori Bannon" <lori@s...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 20, 2002 10:33 PM
Subject: [access_asp] displaying image link from database.


> Hi all,
>
> I want to display images from the database but figure that it would
> probably be easier if I just have the user enter the path to where the
> image is on a server and store that in the database instead of the whole
> pic. This all sounds good but I can't figure out how to display the image.
>
> This is how I call the record set (when I run the page it displays the
> URL):
> <% = oRs.Fields("fldImagePath") %>
>
> This is how I want to display the image:
> <% = oRs.Fields("<img src=fldImagePath>") %>
>
> I've tried it a number of different ways but always get errors. This way I
> dont get an error but it just doesn't work.
>
>
> looks great on paper!
> thanks ahead of time.
>

Message #3 by "Lori Bannon" <lori@s...> on Sat, 21 Dec 2002 16:54:11
Thanks ian,

I got it working...I love it when a plan comes together.

<% strImagePath =  oRs.Fields("fldImagePath")
Response.Write("<img src=" & strImagePath & ">") %>

also...great site..I would've never been able to get my database template 
working without you guys

Skye
www.skyesweb.com



> Hi,
Do
<%
strImagePath =  oRs.Fields("fldImagePath")
Response.Write("<img src=" & strImagePath & ">"
%>

you may have to play around to make sure the "" are in the right place, but
it should work.

cheers

ian
%>
----- Original Message -----
From: "Lori Bannon" <lori@s...>
To: "Access ASP" <access_asp@p...>
Sent: Friday, December 20, 2002 10:33 PM
Subject: [access_asp] displaying image link from database.


> Hi all,
>
> I want to display images from the database but figure that it would
> probably be easier if I just have the user enter the path to where the
> image is on a server and store that in the database instead of the whole
> pic. This all sounds good but I can't figure out how to display the 
image.
>
> This is how I call the record set (when I run the page it displays the
> URL):
> <% = oRs.Fields("fldImagePath") %>
>
> This is how I want to display the image:
> <% = oRs.Fields("<img src=fldImagePath>") %>
>
> I've tried it a number of different ways but always get errors. This way 
I
> dont get an error but it just doesn't work.
>
>
> looks great on paper!
> thanks ahead of time.
>

Message #4 by "Ian: Future Proof Web Dev" <lists@f...> on Sat, 21 Dec 2002 17:22:26 -0000
M pleasure Lori, glad i could help.

cheers

ian
----- Original Message -----
From: "Lori Bannon" <lori@s...>
To: "Access ASP" <access_asp@p...>
Sent: Saturday, December 21, 2002 4:54 PM
Subject: [access_asp] Re: displaying image link from database.


> Thanks ian,
>
> I got it working...I love it when a plan comes together.
>
> <% strImagePath =  oRs.Fields("fldImagePath")
> Response.Write("<img src=" & strImagePath & ">") %>
>
> also...great site..I would've never been able to get my database template
> working without you guys
>
> Skye
> www.skyesweb.com
>
>
>
> > Hi,
> Do
> <%
> strImagePath =  oRs.Fields("fldImagePath")
> Response.Write("<img src=" & strImagePath & ">"
> %>
>
> you may have to play around to make sure the "" are in the right place,
but
> it should work.
>
> cheers
>
> ian
> %>
> ----- Original Message -----
> From: "Lori Bannon" <lori@s...>
> To: "Access ASP" <access_asp@p...>
> Sent: Friday, December 20, 2002 10:33 PM
> Subject: [access_asp] displaying image link from database.
>
>
> > Hi all,
> >
> > I want to display images from the database but figure that it would
> > probably be easier if I just have the user enter the path to where the
> > image is on a server and store that in the database instead of the whole
> > pic. This all sounds good but I can't figure out how to display the
> image.
> >
> > This is how I call the record set (when I run the page it displays the
> > URL):
> > <% = oRs.Fields("fldImagePath") %>
> >
> > This is how I want to display the image:
> > <% = oRs.Fields("<img src=fldImagePath>") %>
> >
> > I've tried it a number of different ways but always get errors. This way
> I
> > dont get an error but it just doesn't work.
> >
> >
> > looks great on paper!
> > thanks ahead of time.
> >
>
>


  Return to Index