Groups | Blog | Home
all groups > inetserver asp db > february 2007 >

inetserver asp db : Images and links


Ricardo Furtado
2/1/2007 6:31:00 AM
i'm developing a web site in asp .net but i came up with a rookie problem.
How can i insert an image or a link from a database record?
I'm using a table and inside the table i have the following code:

<td><img alt="" src=<%DR("Image").ToString()%> width="78px" height="78px">
</td>

<td><a href=<% "viewarticle.aspx " & DR("IdArticle").ToString()%>>.</a>
</td>

which are invalid instructions. How can i define the src and href for the
image and the link?

My thanks in advanced

Ricardo Furtado
2/1/2007 7:53:04 AM
Yes, its working now.
the ' and = were missing in <%DR("Image").ToString()%>
the following instruction is the correct one
'<%=DR("Image").ToString()%>'

thank you very much

Ricardo Furtado

[quoted text, click to view]
Anthony Jones
2/1/2007 2:35:17 PM

"Ricardo Furtado" <RicardoFurtado@discussions.microsoft.com> wrote in
message news:1458A114-EF4F-4ECE-856B-A6493B14BD6F@microsoft.com...
[quoted text, click to view]

Try <%="viewarticle.aspx " & DR("IdArticle").ToString()%>

For future refrence this Group is for Asp classic not ASP.NET


[quoted text, click to view]

Daniel Crichton
2/1/2007 2:39:35 PM
Ricardo wrote on Thu, 1 Feb 2007 06:31:00 -0800:

[quoted text, click to view]

This isn't an ASP.Net newsgroup, it's for classic ASP. You need to post into
one of the groups with dotnet in the name. I'll see if I can help though.

[quoted text, click to view]

You're missing the =, which is the shortcut for Response.Write in ASP (I
guess it's the same in ASP.Net). And you're missing the quotes around the
image link (although most browsers will handle that). Try this.

<td><img alt="" src="<%=DR("Image").ToString()%>" width="78px"
height="78px"> </td>

[quoted text, click to view]

Again, no =. You can do it either of these ways:

<td><a href=<%= "viewarticle.aspx " & DR("IdArticle").ToString()%>>.</a>
</td>

or

<td><a href="viewarticle.aspx <%=DR("IdArticle").ToString()%>">.</a>
</td>


However, these are both going to give invalid URLs as you've just put a
space between the aspx URL and the id. Maybe you wanted this:

<td><a href="viewarticle.aspx?id=<%=DR("IdArticle").ToString()%>">.</a>
</td>

where the viewarticle page reads the "id" querystring value to get the
article id. Replace with the appropriate parameter name.

[quoted text, click to view]

Hopefully the above will help.

Dan

AddThis Social Bookmark Button