Newsgroups: comp.databases.oracle.misc
Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newscon02.news.prodigy.com!prodigy.net!wns13feed!worldnet.att.net!4.24.21.153!newsfeed3.dallas1.level3.net!news.level3.com!news.sanjose1.Level3.net!Level3.net!news.indiana.edu!news.er.usgs.gov!news
From: Brian Peasland <dba@nospam.peasland.net>
Subject: Re: Really need help...skill testing question
In-Reply-To: <1153411520.770945.273860@p79g2000cwp.googlegroups.com>
X-Nntp-Posting-Host: edc-cv-160-64.cr.usgs.gov
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Message-ID: <J2pMz5.LuL@igsrsparc2.er.usgs.gov>
User-Agent: Thunderbird 1.5.0.4 (Windows/20060516)
Sender: news@igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739)
Content-Transfer-Encoding: 7bit
Organization: U.S. Geological Survey, Reston VA
References: <1153408976.088936.128330@i3g2000cwc.googlegroups.com>   <J2pL40.Iyy@igsrsparc2.er.usgs.gov> <1153411520.770945.273860@p79g2000cwp.googlegroups.com>
Mime-Version: 1.0
Date: Thu, 20 Jul 2006 16:25:49 GMT
Lines: 100
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:128664

clinttoris@hotmail.com wrote:
> Brian Peasland wrote:
>> clinttoris@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||',<BR>
>>> <BR>
>>> Here is the hyperlink:<BR><BR>'||
>>> 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 "<BR>". 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@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||',<BR>
>  <BR>
>  Here is the hyperlink:<BR><BR>'||
> '<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||',<BR>
   <BR>
   Here is the hyperlink:<BR><BR>'||
  '<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@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