Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Getting the Hyperlink stored in database

Posted on 2002-05-21
13
193 Views
Last Modified: 2012-05-04
I have stored an Htyperlink in the database and wanted to populate that hyperlink in a HTML Report. This HTML report is being generated thru' a template defined  on a Oracle Report Writer. The Hyper Link stored as

<A HREF="http://www.hotmail.com"> HoTMaiL</A>

but while populating this hyperlink in my HTML report it shows me the exact same contents stored in my database i.e.
<A HREF="http://www.hotmail.com"> HoTMaiL</A>

When I saw the source code then it was showing me the "<" and ">" sign as "&lt;" & "&gt;" respectively.

I am working on JSP to populate this hyperlink from database.

Can anyone suggest me the solution of this problem so that I can get the hyperlink in my HTML report?
0
Comment
Question by:rohit_ab
13 Comments
 
LVL 6

Expert Comment

by:kotan
ID: 7026229
Can you show the code?
0
 
LVL 6

Expert Comment

by:kotan
ID: 7026241
Why don't you store it as http://www.hotmail.com instead of whole line of <A HREF="http://www.hotmail.com"> HoTMaiL</A>
0
 

Author Comment

by:rohit_ab
ID: 7026321
Since the report is being generated from Oracle report writer using (rdf/rep) so code wont be available......and if we are just trying to storing just http://www.hotmail.com then this link will be available only as a plain text in the HTML report. I have tried out to store the &#60 & &#62 instead of "<" and ">" sign but it  was not at all working.
0
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 
LVL 19

Expert Comment

by:cheekycj
ID: 7027475
I guess it is converting it for html display rather than html source.. can you change a setting.

I don't think JSPs have a converter btw HTML display to HTML source.

CJ
0
 
LVL 5

Expert Comment

by:Jan Louwerens
ID: 7028185
You are escaping the text retrieved from the database. Simply don't escape the text.
0
 
LVL 6

Accepted Solution

by:
kotan earned 500 total points
ID: 7031403
0
 
LVL 6

Expert Comment

by:kotan
ID: 7031414
So you must configure you template first to have hyperlink support. Then, get the URL store in database.
0
 
LVL 19

Expert Comment

by:cheekycj
ID: 7032729
Maybe this will help:

http://sandbox.aits.uillinois.edu/Ora60Doc/rbbr60/bawor_we.htm#1012476 [section 4.6 Adding hyperlink destinations and hyperlinks]

CJ
0
 
LVL 19

Expert Comment

by:cheekycj
ID: 7075696
any updates for us?

CJ
0
 
LVL 6

Expert Comment

by:kotan
ID: 7076985
cheekyci,

Isn't the url you provided same as mine, is it?
0
 
LVL 19

Expert Comment

by:cheekycj
ID: 7078588
oops.. I didn't even see that.. sorry.  I must have missed your comment completely.  

CJ
0
 
LVL 19

Expert Comment

by:Kuldeepchaturvedi
ID: 9553927
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

"Accept kotan's comment as answer."
 
Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Kuldeepchaturvedi
EE Cleanup Volunteer
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
netstat -a in AIX unix 8 48
report generation frameworks 1 69
how to add new optional parameter to JSP 1 49
designing in object programming 12 94
The advancement in technology has been a great source of betterment and empowerment for the human race, Nevertheless, this is not to say that technology doesn’t have any problems. We are bombarded with constant distractions, whether as an overload o…
There's a lot of hype surrounding blockchain technology. Here's how it works and some of the novel ways it' s now being used - including for data protection.
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question