Email question

Discussion in 'ASP General' started by Ken D., Jul 14, 2006.

  1. Ken D.

    Ken D. Guest

    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?
     
    Ken D., Jul 14, 2006
    #1
    1. Advertising

  2. Ken D.

    Mike Brind Guest

    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
     
    Mike Brind, Jul 14, 2006
    #2
    1. Advertising

  3. Ken D.

    Ken D. Guest

    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
    >
    >
     
    Ken D., Jul 14, 2006
    #3
  4. Ken D.

    Mike Brind Guest

    Blegh! Frontpage. Don't ask me...

    --
    Mike Brind

    Ken D. wrote:
    > 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
    > >
    > >
     
    Mike Brind, Jul 14, 2006
    #4
    1. Advertising

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Peter
    Replies:
    0
    Views:
    3,428
    Peter
    Jul 1, 2003
  2. John Silver
    Replies:
    0
    Views:
    634
    John Silver
    Feb 4, 2005
  3. Tee

    Email ErrorPage to email

    Tee, Jun 23, 2004, in forum: ASP .Net
    Replies:
    0
    Views:
    397
  4. Replies:
    3
    Views:
    569
    AdamM
    Jul 27, 2004
  5. Chuck Amadi
    Replies:
    2
    Views:
    421
    chuck amadi
    Jun 6, 2004
Loading...

Share This Page