Solved

Getting the Hyperlink stored in database

Posted on 2002-05-21
13
192 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
Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

 
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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

One of the biggest threats in the cyber realm pertains to advanced persistent threats (APTs). This paper is a compare and contrast of Russian and Chinese APT's.
Data breaches are on the rise, and companies are preparing by boosting their cybersecurity budgets. According to the Cybersecurity Market Report (http://www.cybersecurityventures.com/cybersecurity-market-report), worldwide spending on cybersecurity …
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

770 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