Images and links

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
RicardoFurtado [ Do, 01 Februar 2007 15:31 ] [ ID #1615524 ]

Re: Images and links

"Ricardo Furtado" <RicardoFurtado [at] discussions.microsoft.com> wrote in
message news:1458A114-EF4F-4ECE-856B-A6493B14BD6F [at] microsoft.com...
> 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?
>

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

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


> My thanks in advanced
>
> Ricardo Furtado
Anthony Jones [ Do, 01 Februar 2007 15:35 ] [ ID #1615525 ]

Re: Images and links

Ricardo wrote on Thu, 1 Feb 2007 06:31:00 -0800:

> 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?

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.

> 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>

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>

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

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

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

or

<td>">.
</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>">.
</td>

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

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

Hopefully the above will help.

Dan
Daniel Crichton [ Do, 01 Februar 2007 15:39 ] [ ID #1615526 ]

Re: Images and links

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

"Daniel Crichton" wrote:

> Ricardo wrote on Thu, 1 Feb 2007 06:31:00 -0800:
>
> > 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?
>
> 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.
>
> > 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>
>
> 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>
>
> > <td><a href=<% "viewarticle.aspx " & DR("IdArticle").ToString()%>>.</a>
> > </td>
>
> Again, no =. You can do it either of these ways:
>
> <td><a href=<%= "viewarticle.aspx " & DR("IdArticle").ToString()%>>.</a>
> </td>
>
> or
>
> <td>">.
> </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>">.
> </td>
>
> where the viewarticle page reads the "id" querystring value to get the
> article id. Replace with the appropriate parameter name.
>
> > which are invalid instructions. How can i define the src and href for the
> > image and the link?
>
> Hopefully the above will help.
>
> Dan
>
>
>
RicardoFurtado [ Do, 01 Februar 2007 16:53 ] [ ID #1615527 ]
Webserver » microsoft.public.inetserver.asp.db » Images and links

Vorheriges Thema: Need help updateing an entire recordset at once
Nächstes Thema: IIS on Vista