?
Solved

XML negating a quote

Posted on 2004-04-05
2
Medium Priority
?
464 Views
Last Modified: 2013-11-19
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.
0
Comment
Question by:afentonjm
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 43

Accepted Solution

by:
TimCottee earned 200 total points
ID: 10757561
Hi afentonjm,

Double it, SQL will interpret two successive ' ('') as a single quote and store the single quote but will not generate an error.

Tim Cottee
Brainbench MVP for Visual Basic
http://www.brainbench.com
0
 
LVL 14

Expert Comment

by:Thandava Vallepalli
ID: 10757718
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.
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

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

I have a large data set and a SSIS package. How can I load this file in multi threading?
What if you have to shut down the entire Citrix infrastructure for hardware maintenance, software upgrades or "the unknown"? I developed this plan for "the unknown" and hope that it helps you as well. This article explains how to properly shut down …
The viewer will learn how to dynamically set the form action using jQuery.
The viewer will learn the benefit of using external CSS files and the relationship between class and ID selectors. Create your external css file by saving it as style.css then set up your style tags: (CODE) Reference the nav tag and set your prop…

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