Kathleen
Tue Jun 19 19:50:46 CDT 2007
Phew!
I *think* the clickable email is not working because your field name has a
space in it - you can either try enclosing it in brackets, like this [Email
Address]
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others
"lakedesign" <lakedesign@discussions.microsoft.com> wrote in message
news:89E7DABF-EC1E-4749-9B33-2EC23497EDA4@microsoft.com...
> Thank you - that worked!
>
> Now for the email issue - any ideas as to why it doesn't work?
>
>
> "Kathleen Anderson [MVP - FrontPage]" wrote:
>
>> For the hyperlink, I don't think you are removing enough code before you
>> replace it with the code from my site.
>>
>> You need to remove:
>>
>> <!--webbot bot="DatabaseResultColumn"
>> s-columnnames="ID,emailaddress,weblink" s-column="weblink"
>> b-tableformat="TRUE" b-hashtml="FALSE" b-makelink="FALSE" clientside
>> b-MenuFormat preview="<font
>> size="-1"><<</font>weblink<font
>> size="-1">>></font>"
>> startspan --><%=FP_FieldVal(fp_rs,"weblink")%><!--webbot
>> bot="DatabaseResultColumn" endspan i-checksum="15521" -->
>>
>> and replace it with
>>
>> <%="<a target='_blank' href=""" & FP_FieldLink(fp_rs,"weblink") & """>" &
>> FP_FieldVal(fp_rs,"weblink") & "</a>"%>
>>
>> --
>>
>> ~ Kathleen Anderson
>> Microsoft MVP - FrontPage
>> Spider Web Woman Designs
>> web:
http://www.spiderwebwoman.com/resources/
>> Please reply to the newsgroup for the benefit of others.
>>
>>
>>
>>
>> "lakedesign" <lakedesign@discussions.microsoft.com> wrote in message
>> news:D133A561-416D-4A12-AD01-DEABBDF29BCB@microsoft.com...
>> > Kathleen
>> > Sorry about the delay in getting back to you. I don't kow what I'm
>> > doing
>> > wrong.
>> > If I paste the code without the grayed out code, then it doesn't work.
>> > The
>> > grayed out code is a webbot - does that have anything to do with it? I
>> > also
>> > tried the instructions for earlier versions of FP, but the when I
>> > right-click
>> > on the column, hyperlink is not an option. I've tried pasting the code
>> > in
>> > notepad, inserting the target blank code and repasting into FP - it
>> > still
>> > gives me an erorr and reverts back to the orginal code.
>> >
>> > Here is the code for both the email and website columns. If you can
>> > see
>> > what is wrong with it, I'd appreciate the help. (currently, I don't
>> > have
>> > the
>> > email column hyperlinked since it doesn't work.)
>> >
>> > <td><b>Email Address:</b></td>
>> > <b>Email:</b>><td>
>> > <p>
>> > <!--webbot bot="DatabaseResultColumn"
>> > s-columnnames="Category,CompanyName,FirstName,LastName,Address,City,StateOrProvince,PostalCode,WorkPhone,HomePhone,FaxNumber,Email
>> > Address,Website,Join Date,Notes,Dues Amount,FN2,LN2,FN3,LN3,DUES DUE
>> > DATE,DATE PAID,Month Due" s-column="Email Address"
>> > b-tableformat="FALSE"
>> > b-hashtml="FALSE" b-makelink="FALSE" clientside b-MenuFormat
>> > preview="<font
>> > size="-1"><<</font>Email Address<font size="-1">>></font>"
>> > s-ColumnTypes="202,202,202,202,202,202,202,202,202,202,202,202,202,135,203,6,202,202,202,202,135,135,202"
>> > startspan --><%=FP_FieldVal(fp_rs,"Email Address")%><!--webbot
>> > bot="DatabaseResultColumn" endspan i-checksum="34607" -->
>> > </p>
>> > </td>
>> > </tr>
>> > <tr>
>> > <td><b>Website:</b></td>
>> > <td>
>> >
>> > <!--webbot bot="DatabaseResultColumn"
>> > s-columnnames="Category,CompanyName,FirstName,LastName,Address,City,StateOrProvince,PostalCode,WorkPhone,HomePhone,FaxNumber,Email
>> > Address,Website,Join Date,Notes,Dues Amount,FN2,LN2,FN3,LN3,DUES DUE
>> > DATE,DATE PAID,Month Due" s-column="Website" b-tableformat="FALSE"
>> > b-hashtml="FALSE" b-makelink="TRUE" clientside b-MenuFormat
>> > preview="<font
>> > size="-1"><<</font><a href=".">Website</a><font
>> > size="-1">>></font>"
>> > s-ColumnTypes="202,202,202,202,202,202,202,202,202,202,202,202,202,135,203,6,202,202,202,202,135,135,202"
>> > startspan --><%="<a href=""" & FP_FieldLink(fp_rs,"Website") & """>" &
>> > FP_FieldVal(fp_rs,"Website") & "</a>"%><!--webbot
>> > bot="DatabaseResultColumn"
>> > endspan i-checksum="16432" -->
>> > </td>
>> >
>> >
>> > "Kathleen Anderson [MVP - FrontPage]" wrote:
>> >
>> >> On this page:
http://www.easthamptonct.org/ehbiz/display.asp the code
>> >> to
>> >> open the link in a new window looks like this:
>> >>
>> >> <p><b>Web Site:</b> <%="<a target='_blank' href=""" &
>> >> FP_FieldLink(fp_rs,"website") & """>" & FP_FieldVal(fp_rs,"website") &
>> >> "</a>"%></p>
>> >>
>> >> HTH,
>> >>
>> >> --
>> >>
>> >> ~ Kathleen Anderson
>> >> Microsoft MVP - FrontPage
>> >> Spider Web Woman Designs
>> >> web:
http://www.spiderwebwoman.com/resources/
>> >> Please reply to the newsgroup for the benefit of others
>> >>
>> >>
>> >> "lakedesign" <lakedesign@discussions.microsoft.com> wrote in message
>> >> news:01FBF415-DA9B-46A1-A38F-2CC2855F598D@microsoft.com...
>> >> > Kathleen,
>> >> > Thank you for your reply.
>> >> > I'm using Outlook Express.
>> >> >
>> >> > It did give me a warning when trying to insert code for new window,
>> >> > but
>> >> > ignored what I typed and went back to original version.
>> >> >
>> >> > "Kathleen Anderson [MVP - FrontPage]" wrote:
>> >> >
>> >> >> Inline.
>> >> >>
>> >> >> --
>> >> >>
>> >> >> ~ Kathleen Anderson
>> >> >> Microsoft MVP - FrontPage
>> >> >> Spider Web Woman Designs
>> >> >> web:
http://www.spiderwebwoman.com/resources/
>> >> >> Please reply to the newsgroup for the benefit of others.
>> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >> >> "lakedesign" <lakedesign@discussions.microsoft.com> wrote in
>> >> >> message
>> >> >> news:C1FD54BD-82E4-46E8-84B0-F74867EFD9C1@microsoft.com...
>> >> >> >I followed Spiderwebwoman's instructions on creating clickable
>> >> >> >email
>> >> >> > addresses in the DRW, but it gives me a page not found. Any
>> >> >> > suggestions?
>> >> >> > (I
>> >> >> > use FP2003)
>> >> >>
>> >> >> What are you using as your default email client on your computer?
>> >> >>
>> >> >> >
>> >> >> > Also, with her instructions to make the hyperlinks open in a new
>> >> >> > window -
>> >> >> > I
>> >> >> > can't get my FP to accept the added code.
>> >> >>
>> >> >> It *should* accept it, although it may give you a warning message
>> >> >> about
>> >> >> modifying the code.
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>