how to Override the text having "&" in html

Question

0.00/5 (No votes)

See more:

My problem is very interesting
I have some data stored in database
as text like
I & YOU
THEY & HE
AMERICA & INDIA

as Single Text
when I am fetching the data
and showing the same in
page
its getting trimmed after the "&"
Am getting I ,THEY,AMERICA
and so on .

This Must be due to the syntax matching with  .
How can I solve this issue.

[edit]HTML encode added - OriginalGriff[/edit]

Posted 14-Oct-12 23:57pm

Karwa_Vivek

Updated 15-Oct-12 0:29am

OriginalGriff

v2

Add a Solution

Comments

project virus 15-Oct-12 6:20am

which another language u r using..please discuss dis Que. briefly.

Karwa_Vivek 15-Oct-12 6:49am

Actually I am Fetching the Database Values
and storing the same in a String
and then passing the string to other page using a link reference
and then showing the value in other page .I am using SQL Database. and VB.net

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

MT_ · Answer 1 · 2012-10-15T00:24:00

Solution 1

Vivek,

Are you sure the data is stored in the database as you are showing. Actually if your database column is varchar, then you have to save as & for it to store correctly and retrieve.

Just write select * from table in SSMS (if using SQL) and check.
-Milind

Posted 15-Oct-12 0:24am

MT_

OriginalGriff · Answer 2 · 2012-10-15T00:33:00

Ampersand is a special character in HTML - it introduces a sequence so that "<" for example, is shown as a "<", and ">" as a > - otherwise your text would be processed as a tag by the browser.

Depending on what language you used to store the strings, you could (and should) HTML encode them before you store them - otherwise your site could well be vulnerable to an HTML Injection attack, as well as displaying the data incorrectly.

You don't say what you use, so we can't suggest anything!