ASP displaying email link from database incorrectly

's Computer Specifications

Hi:

I've set up a database and an ASP form page that basically will search based
on either first, maiden or last name (for my HS reunion) and display contact
info for the person whose name is typed in.

The code that FP2003 generates is as follows (along with the manual tweak to
get it to be a mailto

<a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>">
<%=FP_Field
Val(fp_rs,"Email")%></a>

The result I get is this:

(E-Mail Removed)#<a href="http://name...domain.com</a>#

It's adding the extra "#http://(E-Mail Removed)#"

How do I prevent this from happening?

Thanks,

Rich

--
***************************************************************

Regards,

Richard M. Coda
PC Type Graphic Design

's Computer Specifications

Was this the manual tweak?

FP2003: In Design view, right-click on the field, select Hyperlink, choose
Link to: Email Address, Parameters, Choose Insert Field Value, and select
the fieldname containing the e-mail address from the dropdown list and click
OK and OK again.

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

rmc <(E-Mail Removed)> wrote:
> Hi:
>
> I've set up a database and an ASP form page that basically will
> search based on either first, maiden or last name (for my HS reunion)
> and display contact info for the person whose name is typed in.
>
> The code that FP2003 generates is as follows (along with the manual
> tweak to get it to be a mailto

>
> <a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>">
> <%=FP_Field Val(fp_rs,"Email")%></a>
>
> The result I get is this:
>
> (E-Mail Removed)#<a href="http://name...domain.com</a>#
>
> It's adding the extra "#http://(E-Mail Removed)#"
>
> How do I prevent this from happening?
>
> Thanks,
>
> Rich

's Computer Specifications

yes it was.

Rich

"Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Was this the manual tweak?
>
> FP2003: In Design view, right-click on the field, select Hyperlink, choose
> Link to: Email Address, Parameters, Choose Insert Field Value, and select
> the fieldname containing the e-mail address from the dropdown list and
click
> OK and OK again.
>
>
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> rmc <(E-Mail Removed)> wrote:
> > Hi:
> >
> > I've set up a database and an ASP form page that basically will
> > search based on either first, maiden or last name (for my HS reunion)
> > and display contact info for the person whose name is typed in.
> >
> > The code that FP2003 generates is as follows (along with the manual
> > tweak to get it to be a mailto

> >
> > <a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>">
> > <%=FP_Field Val(fp_rs,"Email")%></a>
> >
> > The result I get is this:
> >
> > (E-Mail Removed)#<a href="http://name...domain.com</a>#
> >
> > It's adding the extra "#http://(E-Mail Removed)#"
> >
> > How do I prevent this from happening?
> >
> > Thanks,
> >
> > Rich
>

's Computer Specifications

Rich:
For some reason, you are missing a set of single quotes in this:

<a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>">

There should be single quotes before and after the script tags, like this:

<a href="mailto:'<%=FP_FieldLink(fp_rs,"email")%>'">

Can you try the tweak again? It *is* different for each version of
FrontPage - that's why I've got three versions of it on this page:
http://www.spiderwebwoman.com/resour...icks.asp#email

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

rmc <(E-Mail Removed)> wrote:
> yes it was.
>
> Rich
>
> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> message news:(E-Mail Removed)...
>> Was this the manual tweak?
>>
>> FP2003: In Design view, right-click on the field, select Hyperlink,
>> choose Link to: Email Address, Parameters, Choose Insert Field
>> Value, and select the fieldname containing the e-mail address from
>> the dropdown list and click OK and OK again.
>>
>>
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> rmc <(E-Mail Removed)> wrote:
>>> Hi:
>>>
>>> I've set up a database and an ASP form page that basically will
>>> search based on either first, maiden or last name (for my HS
>>> reunion) and display contact info for the person whose name is
>>> typed in.
>>>
>>> The code that FP2003 generates is as follows (along with the manual
>>> tweak to get it to be a mailto

>>>
>>> <a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>">
>>> <%=FP_Field Val(fp_rs,"Email")%></a>
>>>
>>> The result I get is this:
>>>
>>> (E-Mail Removed)#<a href="http://name...domain.com</a>#
>>>
>>> It's adding the extra "#http://(E-Mail Removed)#"
>>>
>>> How do I prevent this from happening?
>>>
>>> Thanks,
>>>
>>> Rich

's Computer Specifications

Same thing...

here's the page: It's in there twide... my original way,, and your way
underneath it.

http://www.rcodaphotography.com/plhs78/contact.asp

Thanks.

Rich
"Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Rich:
> For some reason, you are missing a set of single quotes in this:
>
> <a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>">
>
> There should be single quotes before and after the script tags, like this:
>
> <a href="mailto:'<%=FP_FieldLink(fp_rs,"email")%>'">
>
> Can you try the tweak again? It *is* different for each version of
> FrontPage - that's why I've got three versions of it on this page:
> http://www.spiderwebwoman.com/resour...icks.asp#email
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> rmc <(E-Mail Removed)> wrote:
> > yes it was.
> >
> > Rich
> >
> > "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> > message news:(E-Mail Removed)...
> >> Was this the manual tweak?
> >>
> >> FP2003: In Design view, right-click on the field, select Hyperlink,
> >> choose Link to: Email Address, Parameters, Choose Insert Field
> >> Value, and select the fieldname containing the e-mail address from
> >> the dropdown list and click OK and OK again.
> >>
> >>
> >>
> >> --
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> rmc <(E-Mail Removed)> wrote:
> >>> Hi:
> >>>
> >>> I've set up a database and an ASP form page that basically will
> >>> search based on either first, maiden or last name (for my HS
> >>> reunion) and display contact info for the person whose name is
> >>> typed in.
> >>>
> >>> The code that FP2003 generates is as follows (along with the manual
> >>> tweak to get it to be a mailto

> >>>
> >>> <a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>">
> >>> <%=FP_Field Val(fp_rs,"Email")%></a>
> >>>
> >>> The result I get is this:
> >>>
> >>> (E-Mail Removed)#<a href="http://name...domain.com</a>#
> >>>
> >>> It's adding the extra "#http://(E-Mail Removed)#"
> >>>
> >>> How do I prevent this from happening?
> >>>
> >>> Thanks,
> >>>
> >>> Rich
>

's Computer Specifications

Rich:
Can you send me an email?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/

rmc <(E-Mail Removed)> wrote:
> Same thing...
>
> here's the page: It's in there twide... my original way,, and your way
> underneath it.
>
> http://www.rcodaphotography.com/plhs78/contact.asp
>
> Thanks.
>
> Rich
> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> message news:(E-Mail Removed)...
>> Rich:
>> For some reason, you are missing a set of single quotes in this:
>>
>> <a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>">
>>
>> There should be single quotes before and after the script tags, like
>> this:
>>
>> <a href="mailto:'<%=FP_FieldLink(fp_rs,"email")%>'">
>>
>> Can you try the tweak again? It *is* different for each version of
>> FrontPage - that's why I've got three versions of it on this page:
>> http://www.spiderwebwoman.com/resour...icks.asp#email
>>
>> --
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> http://www.spiderwebwoman.com/resources/
>>
>>
>> rmc <(E-Mail Removed)> wrote:
>>> yes it was.
>>>
>>> Rich
>>>
>>> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
>>> message news:(E-Mail Removed)...
>>>> Was this the manual tweak?
>>>>
>>>> FP2003: In Design view, right-click on the field, select Hyperlink,
>>>> choose Link to: Email Address, Parameters, Choose Insert Field
>>>> Value, and select the fieldname containing the e-mail address from
>>>> the dropdown list and click OK and OK again.
>>>>
>>>>
>>>>
>>>> --
>>>> ~ Kathleen Anderson
>>>> Microsoft MVP - FrontPage
>>>> Spider Web Woman Designs
>>>> http://www.spiderwebwoman.com/resources/
>>>>
>>>>
>>>> rmc <(E-Mail Removed)> wrote:
>>>>> Hi:
>>>>>
>>>>> I've set up a database and an ASP form page that basically will
>>>>> search based on either first, maiden or last name (for my HS
>>>>> reunion) and display contact info for the person whose name is
>>>>> typed in.
>>>>>
>>>>> The code that FP2003 generates is as follows (along with the
>>>>> manual tweak to get it to be a mailto

>>>>>
>>>>> <a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>">
>>>>> <%=FP_Field Val(fp_rs,"Email")%></a>
>>>>>
>>>>> The result I get is this:
>>>>>
>>>>> (E-Mail Removed)#<a href="http://name...domain.com</a>#
>>>>>
>>>>> It's adding the extra "#http://(E-Mail Removed)#"
>>>>>
>>>>> How do I prevent this from happening?
>>>>>
>>>>> Thanks,
>>>>>
>>>>> Rich

's Computer Specifications

Thanks to Kathleen for figuring this one out.

I had imported my data from Excel into Access. While trying to get this to
work (at one point) I changed the Field type in Access to Hyperlink. That
messed up the email field, adding the #http://(E-Mail Removed)# to the end.
What didn't help was that the column width in Access was at the default size
so I didn't even know this had happened.

Re-imported the excel file and left it as text and all is well.

Rich

"Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Rich:
> Can you send me an email?
>
> --
> ~ Kathleen Anderson
> Microsoft MVP - FrontPage
> Spider Web Woman Designs
> http://www.spiderwebwoman.com/resources/
>
>
> rmc <(E-Mail Removed)> wrote:
> > Same thing...
> >
> > here's the page: It's in there twide... my original way,, and your way
> > underneath it.
> >
> > http://www.rcodaphotography.com/plhs78/contact.asp
> >
> > Thanks.
> >
> > Rich
> > "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> > message news:(E-Mail Removed)...
> >> Rich:
> >> For some reason, you are missing a set of single quotes in this:
> >>
> >> <a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>">
> >>
> >> There should be single quotes before and after the script tags, like
> >> this:
> >>
> >> <a href="mailto:'<%=FP_FieldLink(fp_rs,"email")%>'">
> >>
> >> Can you try the tweak again? It *is* different for each version of
> >> FrontPage - that's why I've got three versions of it on this page:
> >> http://www.spiderwebwoman.com/resour...icks.asp#email
> >>
> >> --
> >> ~ Kathleen Anderson
> >> Microsoft MVP - FrontPage
> >> Spider Web Woman Designs
> >> http://www.spiderwebwoman.com/resources/
> >>
> >>
> >> rmc <(E-Mail Removed)> wrote:
> >>> yes it was.
> >>>
> >>> Rich
> >>>
> >>> "Kathleen Anderson [MVP - FP]" <(E-Mail Removed)> wrote in
> >>> message news:(E-Mail Removed)...
> >>>> Was this the manual tweak?
> >>>>
> >>>> FP2003: In Design view, right-click on the field, select Hyperlink,
> >>>> choose Link to: Email Address, Parameters, Choose Insert Field
> >>>> Value, and select the fieldname containing the e-mail address from
> >>>> the dropdown list and click OK and OK again.
> >>>>
> >>>>
> >>>>
> >>>> --
> >>>> ~ Kathleen Anderson
> >>>> Microsoft MVP - FrontPage
> >>>> Spider Web Woman Designs
> >>>> http://www.spiderwebwoman.com/resources/
> >>>>
> >>>>
> >>>> rmc <(E-Mail Removed)> wrote:
> >>>>> Hi:
> >>>>>
> >>>>> I've set up a database and an ASP form page that basically will
> >>>>> search based on either first, maiden or last name (for my HS
> >>>>> reunion) and display contact info for the person whose name is
> >>>>> typed in.
> >>>>>
> >>>>> The code that FP2003 generates is as follows (along with the
> >>>>> manual tweak to get it to be a mailto

> >>>>>
> >>>>> <a href="mailto:<%=FP_FieldLink(fp_rs,"Email")%>">
> >>>>> <%=FP_Field Val(fp_rs,"Email")%></a>
> >>>>>
> >>>>> The result I get is this:
> >>>>>
> >>>>> (E-Mail Removed)#<a href="http://name...domain.com</a>#
> >>>>>
> >>>>> It's adding the extra "#http://(E-Mail Removed)#"
> >>>>>
> >>>>> How do I prevent this from happening?
> >>>>>
> >>>>> Thanks,
> >>>>>
> >>>>> Rich
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Menus displaying incorrectly?	Phil	Windows Vista General Discussion	1	25th Mar 2008 08:39 AM
IE displaying page incorrectly	Tom Harrington	Windows XP Networking	0	26th Jan 2006 11:58 PM
incoming Japanese email displaying incorrectly	=?Utf-8?B?c2Vha3JldA==?=	Microsoft Outlook Discussion	3	15th Jul 2005 06:55 PM
Outlook displaying ad when clicking on any link in email	Tony Baker	Microsoft Outlook	4	1st Apr 2004 02:31 PM
Fonts displaying incorrectly		Windows XP Internet Explorer	1	28th Nov 2003 01:07 PM