Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Display image pointed to in database 1
- Thread starter tomhughes
- Start date
-
1
- #2
Hi Tom,
Yea, you sure can, I do it on a few different websites.
Lets say you have a table called tblInfo and in that table you have a field named Picture. In the field you may have for one record lets say 12345.jpg
Now on your asp page, your recordset should show the picture field as an option. Your link would look like this
<img src="
With that you can see it will pull the picture from an images directory.
Yea, you sure can, I do it on a few different websites.
Lets say you have a table called tblInfo and in that table you have a field named Picture. In the field you may have for one record lets say 12345.jpg
Now on your asp page, your recordset should show the picture field as an option. Your link would look like this
<img src="
With that you can see it will pull the picture from an images directory.
- Thread starter
- #3
ok do not do hyperlink
You also do not need to set up a link
Tell me the following,
recordset name
Table Name (where the other info is along with the picture field)
Name of the picture field within the table.
Make sure that in the field for pictures you have the image names, like 12345.jpg
You also do not need to set up a link
Tell me the following,
recordset name
Table Name (where the other info is along with the picture field)
Name of the picture field within the table.
Make sure that in the field for pictures you have the image names, like 12345.jpg
- Thread starter
- #5
ok, make sure the table cell is empty where you want the picture field to display - click in it, and in the code part you should see the curser between TD codes.
Cut and paste this.
<img src="images/<%=(Recordset1.Fields.Item("Frame2"
.Value)%>">
Change images/ to the directory name where the images are stored.
In the field Frame2 you want the picture name.
for example say you have a .jpg picture called 122345
you would put in that field
122345.jpg
Cut and paste this.
<img src="images/<%=(Recordset1.Fields.Item("Frame2"
.Value)%>">Change images/ to the directory name where the images are stored.
In the field Frame2 you want the picture name.
for example say you have a .jpg picture called 122345
you would put in that field
122345.jpg
- Thread starter
- #7
schase - Lets start over-
1) I am trying to display a picture in a web page
2) The web page is linked to a recordset
3) The recordset points to a Microsoft Data Base
3) In the field in the Microsoft Access data base is some kind of a link to the picture. Since you can't put a picture in a Microsoft Access data base, you have to put some kind of a link to that picture.
The part that is not working is the link to the picture from the Microsoft Data Base. If I just put the name of the picture in the Field in the data base, then all I have is text. How do I link the field in the Microsoft Data Base to the Picture???
1) I am trying to display a picture in a web page
2) The web page is linked to a recordset
3) The recordset points to a Microsoft Data Base
3) In the field in the Microsoft Access data base is some kind of a link to the picture. Since you can't put a picture in a Microsoft Access data base, you have to put some kind of a link to that picture.
The part that is not working is the link to the picture from the Microsoft Data Base. If I just put the name of the picture in the Field in the data base, then all I have is text. How do I link the field in the Microsoft Data Base to the Picture???
putting just text in the database is perfect
that is the easiest method to do what you want.
The above code I gave you takes that text (for example 12345.jpg) and makes the link to the picture for you
This
<img src="images/<%=(Recordset1.Fields.Item("Frame2".Value)%>">
Turns into this for the browser.
<img src="images/12345.jpg">
It takes the text - in our case the pictures name, and inserts it in the source code for the image. And will do it for each and every record.
See how you have <%=(Recordset1.Fields.Item("Frame2".Value)%> stuck inbetween the img src code?
That recordset will pull from the database, the name of your image, and complete the image link.
Just straight text in the database field.
that is the easiest method to do what you want.
The above code I gave you takes that text (for example 12345.jpg) and makes the link to the picture for you
This
<img src="images/<%=(Recordset1.Fields.Item("Frame2"
.Value)%>">Turns into this for the browser.
<img src="images/12345.jpg">
It takes the text - in our case the pictures name, and inserts it in the source code for the image. And will do it for each and every record.
See how you have <%=(Recordset1.Fields.Item("Frame2"
.Value)%> stuck inbetween the img src code?That recordset will pull from the database, the name of your image, and complete the image link.
Just straight text in the database field.
- Thread starter
- #9
Maybe I have the code in the wrong place - Dreamweaver does not give me any errors, and I get a grey box in the upper left of the page, but no picture.
I put this code in the body of the page, Is that correct??
<img src="
I put this code in the body of the page, Is that correct??
<img src="
missing one thing, afer you have Value)%> make sure it is Value)%>">
It does go inbetween the <TD> and </TD> code in the table where you want the picture placed.
make sure the code does not have any ;
Make sure the field in the database is called "Frame2", check caps also.
Make sure the image is in the images directory you are pointing too.
If all is correct,
Give me a picture name so I can test the url to the picture
It does go inbetween the <TD> and </TD> code in the table where you want the picture placed.
make sure the code does not have any ;
Make sure the field in the database is called "Frame2", check caps also.
Make sure the image is in the images directory you are pointing too.
If all is correct,
Give me a picture name so I can test the url to the picture
- Thread starter
- #11
schase - Thanks for being patient with me.
I see now how all the links work.
When I put the extra "> in the code at the end of the string it shows up on the page as text. Also you said not to put any semicolons in the text - This is how ny code looks, and if i try to get rid of the semicolon, it gives me a markup errror.
<img src="Images/<;%=(Recordset1.Fields.Item("Frame2".Value)% >">
I see now how all the links work.
When I put the extra "> in the code at the end of the string it shows up on the page as text. Also you said not to put any semicolons in the text - This is how ny code looks, and if i try to get rid of the semicolon, it gives me a markup errror.
<img src="Images/<;%=(Recordset1.Fields.Item("Frame2"
.Value)% >">- Thread starter
- #12
Hi Tom,
You bet, and my apologies for not responding earlier - had a customer come in.
As an afternote,
That little link part works great for other items too. You can even do the alt tags for pictures by just having another field in your database.
Regular URL Links - same thing.
You bet, and my apologies for not responding earlier - had a customer come in.
As an afternote,
That little link part works great for other items too. You can even do the alt tags for pictures by just having another field in your database.
Regular URL Links - same thing.
- Thread starter
- #14
schase - Do you know how to make a link to text files? "img src" doesn't work for text?
Also what did you mean by this statement?
You can even do the alt tags for pictures by just having another field in your database.
Again, I want to thank you for helping me out.
Also what did you mean by this statement?
You can even do the alt tags for pictures by just having another field in your database.
Again, I want to thank you for helping me out.
Hi Tom,
Sure, 2nd part first.
As long as you make a field for alt tags, like where you have your picture field named Frame2, you can also make a field say "alttext" - note there are some titles you need to stay away from, that is why I get into the habit of naming it slightly different - my tables all start with tbl
ok, so we have Frame2, with a the name of a picture 12345.jpg in it, and next to frame2 you have a field called "alttext", in that you put the text "Picture of me in front of my house" (or whatever alt you want)
Then like you did with the img src - except adding another field
<img src="Images/<;%=(Recordset1.Fields.Item("Frame2".Value)%>" alt="<;%=(Recordset1.Fields.Item("alttext".Value)%>">
Then when you look at the web page, you will see the picture - run your mouse over it and the text box will show.
Pretty nifty thing.
Ok part 1
Instead of img src alter it to <a href="<%=(Recordset1.Fields.Item("FIELDNAME".Value)%>">Any link text you want</a>
Sure, 2nd part first.
As long as you make a field for alt tags, like where you have your picture field named Frame2, you can also make a field say "alttext" - note there are some titles you need to stay away from, that is why I get into the habit of naming it slightly different - my tables all start with tbl
ok, so we have Frame2, with a the name of a picture 12345.jpg in it, and next to frame2 you have a field called "alttext", in that you put the text "Picture of me in front of my house" (or whatever alt you want)
Then like you did with the img src - except adding another field
<img src="Images/<;%=(Recordset1.Fields.Item("Frame2"
.Value)%>" alt="<;%=(Recordset1.Fields.Item("alttext".Value)%>">Then when you look at the web page, you will see the picture - run your mouse over it and the text box will show.
Pretty nifty thing.
Ok part 1
Instead of img src alter it to <a href="<%=(Recordset1.Fields.Item("FIELDNAME"
.Value)%>">Any link text you want</a>- Thread starter
- #16
Awsome - But can I simply put the name of a text file in the Field, and without any interaction from the user (like passing a mouse over the picture) just show up the text. I am using two tables, the one on the left has text, the one on the right has a picture. Maybe I have to just put the text in the Field, instead of the name of the text.
sure, but don't do the alt then - that only works with mouse over. - unless you want both.
you can put a description for one cell in the table
and do a field in the database for it then
Just drag the field name into the cell from your recordset.
you can put a description for one cell in the table
and do a field in the database for it then
Just drag the field name into the cell from your recordset.
- Thread starter
- #19
- Status
Similar threads
