Wouldn&#39;t that be `&amp;quot;` in xml? i.e.

    &quot;hi &amp;quot;mom&amp;quot; lol&quot; 

**edit: ** tested; works fine:

    declare @xml xml
    
     set @xml = &#39;&lt;transaction&gt;&lt;item value=&quot;hi &amp;quot;mom&amp;quot; lol&quot; 
        ItemId=&quot;106&quot;  ItemType=&quot;2&quot;  instanceId=&quot;215923801&quot;  dataSetId=&quot;1&quot; /&gt;&lt;/transaction&gt;&#39;
    
    select @xml.value(&#39;(//item/@value)[1]&#39;,&#39;varchar(50)&#39;)



tSql escapes a double quote with another double quote.  So if you wanted it to be part of your sql string literal you would do this:

    declare @xml xml 
    set @xml = &quot;&lt;transaction&gt;&lt;item value=&quot;&quot;hi&quot;&quot; /&gt;&lt;/transaction&gt;&quot;

If you want to include a quote inside a _value_ in the xml itself, you use an entity, which would look like this:

    declare @xml xml
    set @xml = &quot;&lt;transaction&gt;&lt;item value=&quot;&quot;hi &amp;quot;mom&amp;quot; lol&quot;&quot; /&gt;&lt;/transaction&gt;&quot;

Cannot comment anymore but voted it up and wanted to let folks know that `&amp;quot;` works very well for the xml config files when forming regex expressions for RegexTransformer in Solr like so: `regex=&quot;.*img src=&amp;quot;(.*)&amp;quot;.*&quot;` using the escaped version instead of double-quotes.

In Jelly.core to test a literal string one would use:

    &amp;lt;core:when test=&quot;${ name == &#39;ABC&#39; }&quot;&amp;gt; 

But if I have to check for string &quot;Toy&#39;s R Us&quot;:

    &amp;lt;core:when test=&quot;${ name == &amp;amp;quot;Toy&amp;apos;s R Us&amp;amp;quot; }&quot;&amp;gt;

It would be like this, if the double quotes were allowed inside:

    &amp;lt;core:when test=&quot;${ name == &quot;Toy&#39;s R Us&quot; }&quot;&amp;gt; 

 

	class Dad
	{
		protected static String me = &quot;dad&quot;;
		
		public void printMe()
		{
			System.out.println(me);
		}
	}
	
	class Son extends Dad
	{
		protected static String me = &quot;son&quot;;
	}
	
	public void doIt()
	{
		new Son().printMe();
	}

The function doIt will print &quot;dad&quot;. Is there a way to make it print &quot;son&quot;?


Is there a way to override class variables in Java?

    function Gadget(name, color)
    {
       this.name = name;
       this.color = color;
    }
    
    Gadget.prototype.rating = 3
    
    var newtoy = new Gadget(&quot;webcam&quot;, &quot;black&quot;)

    newtoy.constructor.prototype.constructor.prototype.constructor.prototype 

It always returns the object with rating = 3.

But if I do the following:

    newtoy.__proto__.__proto__.__proto__

The chain ends up returning `null`.

Also in Internet Explorer how would I check the null if there is not a `__proto__` property?

How does __proto__ differ from constructor.prototype?

Pretty simple question - I have an attribute that I would like to have double quotes in.  How do I escape them?  I&#39;ve tried

 - \&quot;
 - &quot;&quot;
 - \\\&quot;

And I&#39;ve made the @xml variable both xml type and varchar(max) for all of them.

     declare @xml xml --(or varchar(max) tried both)
     
     set @xml = &#39;&lt;transaction&gt;&lt;item value=&quot;hi &quot;mom&quot; lol&quot; 
     	ItemId=&quot;106&quot;  ItemType=&quot;2&quot;  instanceId=&quot;215923801&quot;  dataSetId=&quot;1&quot; /&gt;&lt;/transaction&gt;&#39;
     
     declare @xh int
     exec sp_xml_preparedocument @xh OUTPUT, @xml
     
     insert into @commits --I declare the table, just removed it for brevity
     select
     	x.*
     from openxml(@xh,&#39;/transaction/item&#39;)
      WITH (
     	dataItemId int,
         dataItemType int,
     	instanceId int,
     	dataSetId int,
     	value varchar(max)
      ) x

How do I escape double quotes in attributes in an XML String in T-SQL?

Pretty simple question - I have an attribute that I would like to have double quotes in. How do I escape them? I've tried
<ul>
<li>"</li>
<li>""</li>
<li>\"</li>
</ul>
And I've made the @xml variable both xml type and varchar(max) for all of them.
<pre><code class="hljs language-sql"> declare @xml xml --(or varchar(max) tried both)
 
 set @xml = '&#x3C;transaction>&#x3C;item value="hi "mom" lol" 
 	ItemId="106" ItemType="2" instanceId="215923801" dataSetId="1" />&#x3C;/transaction>'
 
 declare @xh int
 exec sp_xml_preparedocument @xh OUTPUT, @xml
 
 insert into @commits --I declare the table, just removed it for brevity
 select
 	x.*
 from openxml(@xh,'/transaction/item')
 WITH (
 	dataItemId int,
 dataItemType int,
 	instanceId int,
 	dataSetId int,
 	value varchar(max)
 ) x
</code></pre>

Obviously the reader doesn&#39;t like this format incoming from the response XML.

Wondering if I can reformat this.  Trying to convert to `DateTime` using the following code with my `XmlReader`:

    reader.ReadContentAsDateTime();

The string &#39;3/18/09 10:16 PM&#39; is not a valid AllXsd value

I got this XML file:

	&lt;root&gt;
		&lt;level1 name=&quot;A&quot;&gt;
			&lt;level2 name=&quot;A1&quot; /&gt;
			&lt;level2 name=&quot;A2&quot; /&gt;
		&lt;/level1&gt;
		&lt;level1 name=&quot;B&quot;&gt;
			&lt;level2 name=&quot;B1&quot; /&gt;
			&lt;level2 name=&quot;B2&quot; /&gt;
		&lt;/level1&gt;
		&lt;level1 name=&quot;C&quot; /&gt;
	&lt;/root&gt;

Could someone give me a C# code using LINQ, the simplest way to print this result:&lt;br&gt;
(Note the extra space if it is a `level2` node)

    A
      A1
      A2
    B
      B1
      B2
    C

Currently I got this code:

	XDocument xdoc = XDocument.Load(&quot;data.xml&quot;));
	var lv1s = from lv1 in xdoc.Descendants(&quot;level1&quot;)
			   select lv1.Attribute(&quot;name&quot;).Value;

	foreach (var lv1 in lv1s)
	{
		result.AppendLine(lv1);

		var lv2s = from lv2 in xdoc...???
	}


LINQ to read XML

I&#39;m writing a GIS client tool in C# to retrieve &quot;features&quot; in a GML-based XML schema (sample below) from a server. Extracts are limited to 100,000 features.

I guestimate that the largest *extract.xml* might get up around 150 megabytes, so obviously DOM parsers are out I&#39;ve been trying to decide between [XmlSerializer][1] and [XSD.EXE][2] generated bindings --OR-- [XmlReader][3] and a hand-crafted object graph.

Or maybe there&#39;s a better way which I haven&#39;t considered yet? Like XLINQ, or ????

Please can anybody guide me? Especially with regards to the memory efficiency of any given approach. If not I&#39;ll have to &quot;prototype&quot; both solutions and profile them side-by-side. 

I&#39;m a bit of a raw prawn in .NET. Any guidance would be greatly appreciated. 

Thanking you. Keith.

----------

**Sample XML** - upto 100,000 of them, of upto 234,600 coords per feature.

    &lt;feature featId=&quot;27168306&quot; fType=&quot;vegetation&quot; fTypeId=&quot;1129&quot; fClass=&quot;vegetation&quot; gType=&quot;Polygon&quot; ID=&quot;0&quot; cLockNr=&quot;51598&quot; metadataId=&quot;51599&quot; mdFileId=&quot;NRM/TIS/VEGETATION/9543_22_v3&quot; dataScale=&quot;25000&quot;&gt;
      &lt;MultiGeometry&gt;
        &lt;geometryMember&gt;
          &lt;Polygon&gt;
            &lt;outerBoundaryIs&gt;
              &lt;LinearRing&gt;
                &lt;coordinates&gt;153.505004,-27.42196 153.505044,-27.422015 153.503992 .... 172 coordinates omitted to save space ... 153.505004,-27.42196&lt;/coordinates&gt;
              &lt;/LinearRing&gt;
            &lt;/outerBoundaryIs&gt;
          &lt;/Polygon&gt;
        &lt;/geometryMember&gt;
      &lt;/MultiGeometry&gt;
    &lt;/feature&gt;

  [1]: http://msdn.microsoft.com/en-us/library/system.xml.serialization.xmlserializer.aspx &quot;XmlSerializer&quot;
  [2]: http://msdn.microsoft.com/en-us/library/x6c1kb0s.aspx &quot;XSD.EXE - Visual Studio XML-schema-binder generator tool&quot;
  [3]: http://msdn.microsoft.com/en-us/library/system.xml.xmlreader.aspx &quot;XmlReader class&quot;


What is the best way to parse (big) XML in C# Code?

I have a gigantic QuickBooks SDK .XSD schema file which defines XML requests/responses that I can send/receive from QuickBooks.

I&#39;d like to be able to easily generate Java classes from these .XSD files, which I could then use to marshal XML to Java objects, and Java objects to XML. 

Is there an easy way to do this...? 

Ideally, it would not require any libraries external to the basic Java distro at run-time. But I&#39;m flexible... 

Generate Java classes from .XSD files...?

I know there are some online regex evaluators.. very useful, matching in real time. They are like web applications of RegexBuddy.

I was wondering if there is a similar thing for xPath selectors? I am just learning them and it would be valuable to me.

Is there an online tester that allows you to input XML and then an xPath selector and match (live would be better, but I doubt someone has written a JavaScript interpreter?) them?

Thanks

Is there an online tester for xPath selectors?

How do I do a `SELECT * INTO [temp table] FROM [stored procedure]`? Not `FROM [Table]` and without defining `[temp table]`?

`Select` all data from `BusinessLine` into `tmpBusLine` works fine.

    select *
    into tmpBusLine
    from BusinessLine

I am trying the same, but using a `stored procedure` that returns data, is not quite the same.

    select *
    into tmpBusLine
    from
    exec getBusinessLineHistory &#39;16 Mar 2009&#39;

**Output message:**

&gt; Msg 156, Level 15, State 1, Line 2
&gt; Incorrect syntax near the keyword
&gt; &#39;exec&#39;.

I have read several examples of creating a temporary table with the same structure as the output stored procedure, which works fine, but it would be nice to not supply any columns.


Insert results of a stored procedure into a temporary table

Ideally I want to do this:

    UPDATE TOP (10) messages SET status=10 WHERE status=0 ORDER BY priority DESC;

In English: I want to get the top 10 available (status=0) messages from the DB and lock them (status=10). A message with a higher priority should be gotten first.

unfortunately MS SQL doesn&#39;t allow an order by clause in the update.

Anyway how to circumvent this?

How to update and order by using ms sql

The code is as follows: 


    ALTER PROCEDURE dbo.pdpd_DynamicCall 
    @SQLString varchar(4096) = null
    
    AS
    
    Begin
    
        create TABLE #T1 ( column_1 varchar(10) , column_2 varchar(100) )
    
        insert into #T1 
            execute (&#39;execute &#39; + @SQLString )
    
        select * from #T1 
    
    End


The problem is that I want to call different procedures that can give back different columns.
Therefore I would have to define the table #T1 generically.
But I don&#39;t know how.

Can anyone help me on this problem?


Dynamic SQL results into temp table in SQL Stored procedure

I&#39;ve been using [this][1] for some time:

    SUBSTRING(str_col, PATINDEX(&#39;%[^0]%&#39;, str_col), LEN(str_col))

However recently, I&#39;ve found a problem with columns with all &quot;0&quot; characters like &#39;00000000&#39; because it never finds a non-&quot;0&quot; character to match.

An alternative technique I&#39;ve seen is to use `TRIM`:

    REPLACE(LTRIM(REPLACE(str_col, &#39;0&#39;, &#39; &#39;)), &#39; &#39;, &#39;0&#39;)

This has a problem if there are embedded spaces, because they will be turned into &quot;0&quot;s when the spaces are turned back into &quot;0&quot;s.

I&#39;m trying to avoid a scalar UDF.  I&#39;ve found a lot of performance problems with UDFs in SQL Server 2005.


  [1]: https://stackoverflow.com/questions/92093/removing-leading-zeroes-from-a-field-in-a-sql-statement

Better techniques for trimming leading zeros in SQL Server?

Is there to way write a T-SQL command to just make it sleep for a period of time?  I am writing a web service asynchronously and I want to be able to run some tests to see if the asynchronous pattern is really going to make it more scalable.  In order to &quot;mock&quot; an external service that is slow, I want to be able to call a SQL server with a script that runs slowly, but isn&#39;t actually processing a ton of stuff.

Sleep Command in T-SQL?

Wondering if there is an easy way to do a simple HTML escape/unescape in Objective C.  What I want is something like this psuedo code:

    NSString *string = @&quot;&amp;lt;span&amp;gt;Foo&amp;lt;/span&amp;gt;&quot;;
    [string stringByUnescapingHTML];


Which returns

    &lt;span&gt;Foo&lt;/span&gt;

Hopefully unescaping all other HTML entities as well and even ASCII codes like &amp;#1234; and the like.

Is there any methods in Cocoa Touch/UIKit to do this?

Objective C HTML escape/unescape

If I write something like this:

    string s = @&quot;....&quot;......&quot;;

it doesn&#39;t work.

---
If I try this:

    string s = @&quot;...\&quot;.....&quot;;

it doesn&#39;t work either.

How can I add a &quot; character to a multi line string declaration in C#?

How can I add &quot; character to a multi line string declaration in C#?

I have an untrusted string that I want to show as text in an HTML page. I need to escape the chars &#39;`&lt;`&#39; and &#39;`&amp;`&#39; as HTML entities.  The less fuss the better.

I&#39;m using UTF8 and don&#39;t need other entities for accented letters.

Is there a built-in function in Ruby or Rails, or should I roll my own?


How to HTML encode/escape a string? Is there a built-in?

I have a dropdown list that contains a series of options:

    &lt;select id=SomeDropdown&gt;
      &lt;option value=&quot;a&#39;b]&amp;lt;p&gt;&quot;&gt;a&#39;b]&amp;lt;p&gt;&lt;/option&gt;
      &lt;option value=&quot;easy&quot;&gt;easy&lt;/option&gt;
    &lt;select&gt;

Notice that the option value/text contains some nasty stuff:

 - single quotes 
 - closing square bracket
 - escaped html

I need to remove the a&#39;b]&amp;lt;p&gt; option but I&#39;m having no luck writing the selector. Neither:

    $(&quot;#SomeDropdown &gt;option[value=&#39;a&#39;&#39;b]&amp;lt;p&gt;&#39;]&quot;);

or

    $(&quot;#SomeDropdown &gt;option[value=&#39;a\&#39;b]&amp;lt;p&gt;&#39;]&quot;);

are returning the option.

What is the correct way to escape values when using the &quot;value=&quot; selector?

jQuery selector value escaping

For many Subversion operations, appending the &#39;@&#39; symbol to the end of a file or URL argument allows you to target a specific revision of that file.  For example, &quot;svn info test.txt@1234&quot; will give information about test.txt as it existed in revision 1234.

However, when the name of the file contains an @, it is incorrectly interpreted by Subversion as a revision specifier:

&gt; svn info &#39;test@.txt&#39;
svn: Syntax error parsing revision &#39;.txt&#39;


I&#39;ve tried double and single quotes as well as escaping with &#39;/&#39;, &#39;\&#39;, and &#39;@&#39;.  How can I tell Subversion to treat the @ symbols as part of the file name?

Content Type	Original Author	Original Content on Stackoverflow
Question	Tom Ritter	View Question on Stackoverflow
Solution 1 - Xml	Marc Gravell	View Answer on Stackoverflow
Solution 2 - Xml	Joel Coehoorn	View Answer on Stackoverflow
Solution 3 - Xml	pulkitsinghal	View Answer on Stackoverflow
Solution 4 - Xml	Mark	View Answer on Stackoverflow

How do I escape double quotes in attributes in an XML String in T-SQL?

Xml Problem Overview

Xml Solutions

Solution 1 - Xml

Solution 2 - Xml

Solution 3 - Xml

Solution 4 - Xml

How does proto differ from constructor.prototype?

Is there a way to override class variables in Java?

Attributions