how to use greater than symbol in xml to write sql query

Question

//This is my xml file
<sql id="data8">select .......... and DATEDIFF(CURDATE(),modified_date) > 7 group by ......</sql>

//And i am accessing this in webmethod in aspx.cs page.

 var doc = new XmlDocument();
 doc.Load(Server.MapPath("XMLFile.xml"));
    string cmdstr = doc.DocumentElement.SelectSingleNode("//queries/sql[@id='data8']").InnerXml;

But i am getting error "Unknown column 'gt' in 'where clause'". PLease help

Answer 1

Please try read InnerText property's value instead of InnerXml