• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 200
  • Last Modified:

Getting the Hyperlink stored in database

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
rohit_ab
Asked:
rohit_ab
1 Solution
 
kotanCommented:
Can you show the code?
0
 
kotanCommented:
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
 
rohit_abAuthor Commented:
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
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
cheekycjCommented:
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
 
Jan LouwerensSoftware EngineerCommented:
You are escaping the text retrieved from the database. Simply don't escape the text.
0
 
kotanCommented:
0
 
kotanCommented:
So you must configure you template first to have hyperlink support. Then, get the URL store in database.
0
 
cheekycjCommented:
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
 
cheekycjCommented:
any updates for us?

CJ
0
 
kotanCommented:
cheekyci,

Isn't the url you provided same as mine, is it?
0
 
cheekycjCommented:
oops.. I didn't even see that.. sorry.  I must have missed your comment completely.  

CJ
0
 
KuldeepchaturvediCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now