Solved

Getting the Hyperlink stored in database

Posted on 2002-05-21
13
189 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
Comment Utility
Can you show the code?
0
 
LVL 6

Expert Comment

by:kotan
Comment Utility
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
Comment Utility
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
 
LVL 19

Expert Comment

by:cheekycj
Comment Utility
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
Comment Utility
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
Comment Utility
0
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 6

Expert Comment

by:kotan
Comment Utility
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
Comment Utility
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
Comment Utility
any updates for us?

CJ
0
 
LVL 6

Expert Comment

by:kotan
Comment Utility
cheekyci,

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

Expert Comment

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

CJ
0
 
LVL 19

Expert Comment

by:Kuldeepchaturvedi
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
A safe way to clean winsxs folder from your windows server 2008 R2 editions
This tutorial demonstrates a quick way of adding group price to multiple Magento products.
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

744 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

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now