ASP displaying email link from database incorrectly

[rmc]

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")%>">
<!--webbot bot="DatabaseResultColumn"
s-columnnames="ID,First,Maiden,Last,Address1,Address2,City,State,Zip,Phone1,
Phone2,Email" s-column="Email" b-tableformat="FALSE" b-hashtml="FALSE"
b-makelink="FALSE" clientside b-MenuFormat preview="&lt;font
size=&quot;-1&quot;&gt;&amp;lt;&amp;lt;&lt;/font&gt;Email&lt;font
size=&quot;-1&quot;&gt;&amp;gt;&amp;gt;&lt;/font&gt;" startspan
s-ColumnTypes="3,202,202,202,202,202,202,202,202,202,202,202" --><%=FP_Field
Val(fp_rs,"Email")%><!--webbot bot="DatabaseResultColumn" endspan
i-checksum="8328" --></a>

The result I get is this:

[email protected]#http://[email protected]#

It's adding the extra "#http://[email protected]#"

How do I prevent this from happening?

Thanks,

Rich

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

Regards,

Richard M. Coda
PC Type Graphic Design

 

[Kathleen Anderson [MVP - FP]]

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.

 

[rmc]

yes it was.

Rich

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/



s-columnnames="ID,First,Maiden,Last,Address1,Address2,City,State,Zip,Phone1,

 

[Kathleen Anderson [MVP - FP]]

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/resources/dbrwtipsandtricks.asp#email

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

yes it was.

Rich

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/

s-columnnames="ID,First,Maiden,Last,Address1,Address2,City,State,Zip,Phone1,

 

[rmc]

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]]

Rich:
Can you send me an email?

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

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

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/resources/dbrwtipsandtricks.asp#email

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

s-columnnames="ID,First,Maiden,Last,Address1,Address2,City,State,Zip,Phone1,

 

[rmc]

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://[email protected]# 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