Solved

Getting the Hyperlink stored in database

Posted on 2002-05-21
13
194 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
[X]
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
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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

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

Suggested Solutions

This article was originally published on Monitis Blog, you can check it  here . If you have responsibility for software in production, I bet you’d like to know more about it. I don’t mean that you’d like an extra peek into the bowels of the sour…
Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime is disastrous for companies and can lead to major hits on a brand, reputation, an…
Attackers love to prey on accounts that have privileges. Reducing privileged accounts and protecting privileged accounts therefore is paramount. Users, groups, and service accounts need to be protected to help protect the entire Active Directory …

726 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