email to link

[Chas]

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

[Ray at]

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

<td><a href="mailto:pe****@domain.kom">pe****@domain.kom</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" <rf*@thewebdeziners.com> wrote in message
news:40***************@thewebdeziners.com...

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

[Chas]

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:pe****@domain.kom">pe****@domain.kom</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" <rf*@thewebdeziners.com> wrote in message
news:40***************@thewebdeziners.com...

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

[Aaron Bertrand [MVP]]

> <%

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/

[Ray at]

Oh yeah. Good point. :]

Ray at home

"Aaron Bertrand [MVP]" <aa***@TRASHaspfaq.com> wrote in message
news:ex**************@TK2MSFTNGP12.phx.gbl...

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