471,832 Members | 1,415 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,832 software developers and data experts.

Hyperlinking in a returned recordset



I have a customers table in my database (SQL 2k) with a column called
[E-mail]. What I would like to set up (if possible) is to have the ASP
page, as it returns the requested recordset, if it has an email address
to display the email address as a hyperlink (i.e. mailto:
so*****@somedomain.com) while showing the email address so the end users
can just click on the email address field and have it pull up a new mail
message with the To: address filled in.

Thoughts?

Thanks in advance.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 19 '05 #1
1 1194
If it were just static HTML, what would you do? <a
href="mailto:pe****@domain.om">pe****@domain.om</a>, right? Well, part of
the function of ASP is to return HTML, so just have it return HTML like that
by just substituting the hard-coded e-mail address for a variable that
represents it. For example:

<%
sEmail = yourRecordset.Fields.Item(0).Value
%>
<a href="mailto:<%=sEmail%>"><%=sEmail%></a>

Ray at work

"Micromanaged" <no*****@nospam.org> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...


I have a customers table in my database (SQL 2k) with a column called
[E-mail]. What I would like to set up (if possible) is to have the ASP
page, as it returns the requested recordset, if it has an email address
to display the email address as a hyperlink (i.e. mailto:
so*****@somedomain.com) while showing the email address so the end users
can just click on the email address field and have it pull up a new mail
message with the To: address filled in.

Thoughts?

Thanks in advance.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

NeoPa
reply views Thread by NeoPa | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.