Response.Write ("<a target=""blank"" href=""")
Response.Write rs("link")
Response.Write ("""><img border=""0"" src=""")
Response.Write rs("image")
Response.Write ("""></a>")

*this is drawing information from a database

link = a link to a website
image = the url of an image

I just can seem to get this to work. This is what it looks like if i do that:

<a target="blank" href="#http://www.pixeljoint.com/default.asp#"><img border="0" src="#http://pixeljoint.com/pixels/images/pixeljoint6.gif#"></a>

What's with the pound signs?!

Stored in an Access database? It uses funny denote marks, like # around dates, and, apparently, hyperlinks. Either store the URLs in plain text format, or add some code to strip the # marks out. Like:

Response.Write ("href=" + Chr(34) + Replace(link, "#", "") + Chr(34))

The target attribute is _blank, not blank; that might become an issue later.

And Chr(34) returns a quote mark.

Originally Posted by ForrestCroce

Stored in an Access database? It uses funny denote marks, like # around dates, and, apparently, hyperlinks. Either store the URLs in plain text format, or add some code to strip the # marks out. Like:

Response.Write ("href=" + Chr(34) + Replace(link, "#", "") + Chr(34))

The target attribute is _blank, not blank; that might become an issue later.

And Chr(34) returns a quote mark.

yessssss thank you thank you thank you thank you thank you!

I just had to change a setting in the database.

Skeddles, if you haven't figured it out (and I suspect you have), this happens when you make a field a hyperlink within Access.

Never use hyperlink for a field, unless the database is exclusively offline. You'll never get it to function the way you want it to.

Originally Posted by ADAM Web Design

You'll never get it to function the way you want it to.

Plus the whole point to using a database instead of a Excel file is once you've got your data stored, you can query it in new ways to learn things. If you store the URI as text instead of as a hyperlink which is a special field that Access uses to track different bits of data, you'll be able to do more with your data later.

Originally Posted by Learning Newbie

Plus the whole point to using a database instead of a Excel file is once you've got your data stored, you can query it in new ways to learn things. If you store the URI as text instead of as a hyperlink which is a special field that Access uses to track different bits of data, you'll be able to do more with your data later.

The is very true. If the data comes with #, use the replace command to remove the unwanted character.

In the long term Hyperlink Field could help you.

use ' to replace " in the ""