Link to home
Start Free TrialLog in
Avatar of afentonjm
afentonjmFlag for Jamaica

asked on

XML negating a quote

I Am trying to insert into a tables using XML, But i get a error because the value of one of the xml elements has a single  quote ( < tablename   notes = " 2000.00 rec'd from......" /> ) how do i negate the single quote.
ASKER CERTIFIED SOLUTION
Avatar of TimCottee
TimCottee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Hello,

Use    XML Entity  reference in place of single quote.   i.e  "&#39;".  

Now your new syntax looks like ......

( < tablename   notes = " 2000.00 rec&#39;d from......" /> )



All the best,
V.Thadnava Krishna.