[RESOLVED] Help with XML query

hi guys! currently i have the code below which query something from Sharepoint List Service but how will I modify it in such a way that it will query all rows from field2 with value in other words i want to get all those rows in field2 which has value.

Code:

---


Web_Reference_Folder_Name.Lists listService = new Web_Reference_Folder_Name.Lists();
listService.Credentials= System.Net.CredentialCache.DefaultCredentials;

XmlDocument xmlDoc = new System.Xml.XmlDocument();

XmlNode ndQuery = xmlDoc.CreateNode(XmlNodeType.Element,"Query","");
XmlNode ndViewFields = xmlDoc.CreateNode(XmlNodeType.Element,"ViewFields","");
XmlNode ndQueryOptions = xmlDoc.CreateNode(XmlNodeType.Element,"QueryOptions","");

ndQueryOptions.InnerXml = "<IncludeMandatoryColumns>FALSE</IncludeMandatoryColumns>" +
    "<DateInUtc>TRUE</DateInUtc>";
ndViewFields.InnerXml = "<FieldRef Name='Field1' /><FieldRef Name='Field2'/>";
ndQuery.InnerXml = "<Where><And><Gt><FieldRef Name='Field1'/>" +
    "<Value Type='Number'>5000</Value></Gt><Gt><FieldRef Name='Field2'/>" +
    "<Value Type='DateTime'>2003-07-03T00:00:00</Value></Gt></And></Where>";
try
{
    XmlNode ndListItems = listService.GetListItems("List_Name", null, ndQuery,
        ndViewFields, null, ndQueryOptions);
    MessageBox.Show(ndListItems.OuterXml);
}

catch (System.Web.Services.Protocols.SoapException ex)
{
    MessageBox.Show("Message:\n" + ex.Message + "\nDetail:\n" + ex.Detail.InnerText +
        "\nStackTrace:\n" + ex.StackTrace);
}

---

My Solution:

Code:

---


ndQuery.InnerXml = "<Where><IsNotNull><fieldRef Name='field2'/></IsNotNull></Where>";

---

Use the XMLDocument object's SelectNodes() method. You can specify an XPath string in it:

/something/field1/field2[exists(field2/text())]