I have a SQL Query (SQL2005) returns for XML statement, my client is
using ExecuteXmlReader to execute the query, everything if fine until I
use ReadOutXML, the string has a extra \ before every ", how do I
remove it? Here is the xml result I got
<SearchResults xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">
<SearchResult id=\"2B12DD88-B472-449A-8A69-62563174A28A\">
<title> testTitle
</title>
</SearchResult>
</SearchResults>
(If I load the return string to DOM document, I can get it removed, but
I do not want to take the performance hit)
Please advice.
Thanks in advance.
John
1  1113 
Hopefully, by now, you should have found a solution for this. If you are
still looking for solution, i would suggest you to load the xml stream into
string and then use the .REPLACE method to eliminate the namespace before
loading into dataset.
What do you say?
--
Every thing is perfect, as long as you share!!!
"John" wrote: I have a SQL Query (SQL2005) returns for XML statement, my client is
using ExecuteXmlReader to execute the query, everything if fine until I
use ReadOutXML, the string has a extra \ before every ", how do I
remove it? Here is the xml result I got
<SearchResults xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\">
<SearchResult id=\"2B12DD88-B472-449A-8A69-62563174A28A\">
<title> testTitle
</title>
</SearchResult>
</SearchResults>
(If I load the return string to DOM document, I can get it removed, but
I do not want to take the performance hit)
Please advice.
Thanks in advance.
John
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: revjjjames |
last post by:
Hello -
What is the correct expression to remove any extra line breaks beyond
two in a string?
Sincerely,
Jim
|
by: Arjen |
last post by:
Hello,
In code view I use a tab as mark-up character.
When I run my web application I can see the tabs with the source viewer in
my browser.
Is there a way to remove the tabs, extra spaces...
|
by: Will |
last post by:
here is the code:
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
Dim start As Integer = 4
Dim top As Integer = 25
Dim i As Integer
Dim nowdate...
|
by: James Black |
last post by:
If you go to http://dante.acomp.usf.edu/HomeworkAssistant/index.php you
will see my code.
Type in:
s = a + b and hit tab, and you will see the extra words.
How do I remove these?
Here is a...
|
by: Bosconian |
last post by:
I know that
str.replace(/^\s+|\s+$/g,'');
will trim a string of space, but what about removing extra spaces from the
middle?
Where
"hello world"
|
by: tshad |
last post by:
Is there a reason to use session.remove over session.contents.remove?
Don't they both remove the key and data from the contents collection?
I assume that session(x) = nothing does essentially...
|
by: Registered User |
last post by:
Hi experts,
I'm trying to write a program that replaces two or more consecutive
blanks in a string by a single blank.
Here's what I did:
#include <stdio.h>
#include <string.h>
#define MAX 80
|
by: CMNetworx |
last post by:
ok, so I am grabbing a file off of my server, and I strip out all of the html tags and extra crap that I don't want, and write it to a text file, however the content that makes it to the file still...
|
by: ashish1779 |
last post by:
hi I am new in PHP, i have face one problem when I crawl any site and i have to save the whole HTML content in database, on that time all the HTML tags are changes into the extra space in content...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
| |
