Email question

K

Ken D.

I have an asp page that returns a record from my SQL database based on a
custom query. One field in the database is email address. I would like the
field displayed as a link (is working) and when the user clicks on it, their
email client opens. Here is the code:

<%="<a href=""" & FP_FieldLink(fp_rs,"Email") & """>" &
FP_Field(fp_rs,"Email") & "</a>"%>

I tried inserting mailto: in the a href statement but it does not work. Any
ideas?
 
M

Mike Brind

Ken said:
I have an asp page that returns a record from my SQL database based on a
custom query. One field in the database is email address. I would like the
field displayed as a link (is working) and when the user clicks on it, their
email client opens. Here is the code:

<%="<a href=""" & FP_FieldLink(fp_rs,"Email") & """>" &
FP_Field(fp_rs,"Email") & "</a>"%>

I tried inserting mailto: in the a href statement but it does not work. Any
ideas?

<%
Response.Write "<a href=""mailto:" & FP_FieldLink(fp_rs,"Email") &
""">"
Response.Write FP_Field(fp_rs,"Email") & "</a>"
%>

You forgot the colon after mailto
 
K

Ken D.

Mike,

I receive a message that the contents will overwrite but it keeps reverting
back to the code below:

<!--webbot bot="DatabaseResultColumn"
s-columnnames="Department,Address,Suite,CSZ,Phone,Fax,Email" s-column="Email"
b-tableformat="FALSE" b-hashtml="TRUE" b-makelink="TRUE" clientside
b-MenuFormat preview="<font size="-1">&lt;&lt;</font><a
href=".">Email</a><font size="-1">&gt;&gt;</font>" startspan -->

<%="<a href=""" & FP_FieldLink(fp_rs,"Email") & """>" &
FP_Field(fp_rs,"Email") & "</a>"%>

<!--webbot bot="DatabaseResultColumn" endspan i-CheckSum="48711" --></td>

It seems so simple...

Ken
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

Forum statistics

Threads
473,755
Messages
2,569,536
Members
45,019
Latest member
RoxannaSta

Latest Threads

Top