«

I am using this code

<table border="1">
<%
Do While Not rstSimple.EOF
%>
<tr>
<td><%= rstSimple.Fields("username").Value %></td>
<td><%= rstSimple.Fields("password").Value %></td>
<td><%= rstSimple.Fields("email").Value %></td>
</tr>
<%
rstSimple.MoveNext
Loop
%>
</table>

How can I make the email field a hyper link?

Charlie

How would you do it if you hard"coded" the HTML?

<td><a href="mailto"></a></td>

Right? So, substitute the e-mail address for the variable (or recordset
value) that represents the e-mail address. Let's put the value into a
variable to make it simpler and a bit more efficient though.


<%
sEmail = rstSimple.Fields("email").Value
%>

<table border="1">
<%
Do While Not rstSimple.EOF
%>
<tr>
<td><%= rstSimple.Fields("username").Value %></td>
<td><%= rstSimple.Fields("password").Value %></td>
<td><a href="mailto:<%=sEmail%>"><%=sEmail%></a></td>
</tr>
<%
rstSimple.MoveNext
Loop
%>
</table>


Ray at home


"Chas" <> wrote in message
news:...
> I am using this code
>
> <table border="1">
> <%
> Do While Not rstSimple.EOF
> %>
> <tr>
> <td><%= rstSimple.Fields("username").Value %></td>
> <td><%= rstSimple.Fields("password").Value %></td>
> <td><%= rstSimple.Fields("email").Value %></td>
> </tr>
> <%
> rstSimple.MoveNext
> Loop
> %>
> </table>
>
> How can I make the email field a hyper link?
>
> Charlie
>

Thanks so much this is great!
Charlie

"Ray at <%=sLocation%> [MVP]" wrote:

> How would you do it if you hard"coded" the HTML?
>
> <td><a href="mailto"></a></td>
>
> Right? So, substitute the e-mail address for the variable (or recordset
> value) that represents the e-mail address. Let's put the value into a
> variable to make it simpler and a bit more efficient though.
>
> <%
> sEmail = rstSimple.Fields("email").Value
> %>
>
> <table border="1">
> <%
> Do While Not rstSimple.EOF
> %>
> <tr>
> <td><%= rstSimple.Fields("username").Value %></td>
> <td><%= rstSimple.Fields("password").Value %></td>
> <td><a href="mailto:<%=sEmail%>"><%=sEmail%></a></td>
> </tr>
> <%
> rstSimple.MoveNext
> Loop
> %>
> </table>
>
> Ray at home
>
> "Chas" <> wrote in message
> news:...
> > I am using this code
> >
> > <table border="1">
> > <%
> > Do While Not rstSimple.EOF
> > %>
> > <tr>
> > <td><%= rstSimple.Fields("username").Value %></td>
> > <td><%= rstSimple.Fields("password").Value %></td>
> > <td><%= rstSimple.Fields("email").Value %></td>
> > </tr>
> > <%
> > rstSimple.MoveNext
> > Loop
> > %>
> > </table>
> >
> > How can I make the email field a hyper link?
> >
> > Charlie
> >

> <%
> sEmail = rstSimple.Fields("email").Value
> %>
>
> <table border="1">
> <%
> Do While Not rstSimple.EOF
> %>

Well, you probably want to assign the value inside the loop.

--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/

Oh yeah. Good point. :]

Ray at home

"Aaron Bertrand [MVP]" <> wrote in message
news:ex7l49h$...
> > <%
> > sEmail = rstSimple.Fields("email").Value
> > %>
> >
> > <table border="1">
> > <%
> > Do While Not rstSimple.EOF
> > %>
>
> Well, you probably want to assign the value inside the loop.
>
> --
> Aaron Bertrand
> SQL Server MVP
> http://www.aspfaq.com/
>
>