Home All Groups Group Topic Archive Search About


Author
14 Jul 2006 4:03 PM
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?

Author
14 Jul 2006 4:19 PM
Mike Brind
Ken D. wrote:
> 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

--
Mike Brind
Author
14 Jul 2006 4:32 PM
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


Show quote
"Mike Brind" wrote:

>
> Ken D. wrote:
> > 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
>
> --
> Mike Brind
>
>
Author
14 Jul 2006 6:49 PM
Mike Brind
Blegh!  Frontpage.  Don't ask me...

--
Mike Brind

Ken D. wrote:
Show quote
> 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
>
>
> "Mike Brind" wrote:
>
> >
> > Ken D. wrote:
> > > 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
> >
> > --
> > Mike Brind
> >
> >

AddThis Social Bookmark Button