InfoPath Dev

Here is a piece of code

string test = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Car/my:Car_Model"_IP", NamespaceManager).Value;

// Retrieve the rows of the secondary data source

XPathNodeIterator rows = secDSNav.Select("/dfs:myFields/dfs:dataFields/dfs:SPData[@Car_Model_SP = 'test']", NamespaceManager);

It works fine if i change the[@Car_Model = 'test']",  by a real value that exists in the list, e.g [@Car_Model = 'bmw']",   but I cant filter using the variable test.

Do you have any ideas?

Thanks

When you use the variable test, your XPath looks like this, right?

"/dfs:myFields/dfs:dataFields/dfs:SPData[@Car_Model_SP = '" + test + "']"

Thanks a lot! My syntax was wrong.

I am trying to set conditions when filtering. I am using the string-length function to determine if strings exist or not (FilterModel and FilterManufacturer are 2 drop downs). However, i am getting an "expression must evaluate to a node-set" error. Is there another way to determine the existence of a string when filtering? Thanks in advance!

string FilterModel = MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:Car/my:Car_Model", NamespaceManager).Value;

XPathNodeIterator rows = secDSNav.Select("/dfs:myFields/dfs:dataFields/dfs:group[(@Cat = 'Car' and @Car_Model = '" + FilterModel + "' and @Car_Manufacturer = '" + FilterManufacturer + "') or (@Cat = 'Car' and @Car_Manufacturer = '" + FilterManufacturer + "' and string-length('" + FilterModel + "') = 0) or (@Cat = 'Car' and string-length('" + FilterManufacturer + "') = 0 and string-length('" + FilterModel + "') = 0 )]", NamespaceManager);