Re: Really need help...skill testing question

From: <clinttoris_at_hotmail.com>
Date: 20 Jul 2006 09:43:09 -0700
Message-ID: <1153413789.854741.145840@p79g2000cwp.googlegroups.com>

Brian Peasland wrote:
> clinttoris_at_hotmail.com wrote:
> > Brian Peasland wrote:
> >> clinttoris_at_hotmail.com wrote:
> >>> Hello experts,
> >>>
> >>> I just wrote some code to email users using UTL_SMTP. Now my problem
> >>> is in the body of the email I want to say "Here is your hyperlink" and
> >>> then display the link. I have the link sitting in a database that I
> >>> want to pull out and display however when the user receives the email
> >>> one cannot click the link to goto the hyperlink it is just plain black
> >>> text. Here is part of the code that does this
> >>>
> >>> message := 'Hello'||v_data.Name||', 
> >>> 
> >>> Here is the hyperlink: '||
> >>> v_data.Link;
> >>>
> >>> Obviously there is more code to this but this is the jist of the code.
> >>> Any ideas. The Link field in the database is a Varchar2(4000). It's
> >>> an oracle database using oracle 10 with microsoft exchange server.
> >>>
> >>> Thanks.
> >>>
> >> From above, I can see that you know that you have to include HTML
> >> markup tags such as " ". But you'll also have to include the "<A
> >> HREF>" tag around your link as well.
> >>
> >> This works if your recipient receives email as HTML code, but what if
> >> their email program receives mail as straight text?
> >>
> >> Cheers,
> >> Brian
> >>
> >>
> >>
> >> --
> >> ===================================================================
> >>
> >> Brian Peasland
> >> dba_at_nospam.peasland.net
> >> http://www.peasland.net
> >>
> >> Remove the "nospam." from the email address to email me.
> >>
> >>
> >> "I can give it to you cheap, quick, and good.
> >> Now pick two out of the three" - Unknown
> >
> >
> > Brian thanks for the reply.
> >
> > As soon as I sent the message I did think of the a href and have added
> > the code as follows
> >
> > message := 'Hello'||v_data.Name||', 
> > 
> > Here is the hyperlink: '||
> > '<a href=>'||v_data.link||'</a>';
> >
> > So now it looks like I have a hyperlink when the user receives the
> > email but when the user clicks the link they receive it is still
> > unclickable. Any ideas.

> Your HREF tag is incomplete. You have the link name wrapped in between
> the <a> and </a> tags. This is what the user sees. However, you have
> not provided the information for the browser to actually make it a link.
> Try something more like this:

> message := 'Hello'||v_data.Name||', 
> 
> Here is the hyperlink: '||
> '<a href='||v_data.link||'>'||v_data.link||'</a>';

>
>


> > Also, not sure what you mean with your last part about what if they

> > receive email as straight text.  How do I know this?  Does Microsoft

> > outlook have a setting for this? Could you expand on this. Thanks
> > again brian.

> Outlook, Outlook Express, and many of the other email programs in use
> today can display both HTML and Text emails. Now that I think about it,
> I cannot think of email programs in wide use today that cannot do both
> (that wasn't the case a number of years ago). So my original comment is
> probably nothing to worry about.

> Cheers,
> Brian

> --
> ===================================================================

> Brian Peasland
> dba_at_nospam.peasland.net
> http://www.peasland.net

> Remove the "nospam." from the email address to email me.

>
>

> "I can give it to you cheap, quick, and good.
> Now pick two out of the three" - Unknown

Brian,

Thanks so much. That did the trick. I corrected the a href syntax and it is working fine now. Have a great day Brian. Received on Thu Jul 20 2006 - 11:43:09 CDT