View Full Version : XMLDataSet filter

04-20-2008, 10:04 AM
This should be simple, but I just can't find the answer at the moment. I am trying to apply a filter to a spry table using a XMLDataSet by selecting a value in a Spry validation select.

The XMLdata that drives the table is as follows

var ds2 = new Spry.Data.XMLDataSet("Data/NetballDatafeed190401.xml", "NetballList/NetballProducts[SubType='{ds3::Type}']",{sortOnLoad:"SubType",sortOrderOnLoad:"ascending"});

One of the fields in the XML table is SubType and so I am using [SubType='{ds3::Type}']" to dynamically set this up as I change the drop down selection.

The spry drop down selection is defined as

<div spry:region="ds3">
<select name="select" onchange="ds3.setCurrentRow(this.value)" spry:repeatchildren="ds3">
<option value="{ds_RowID}}">{Type}</option>

On loading the table shows the selection of data I want, however once I select a value from the dropdown list the table goes blank. The ds3 dataset that drives the dropdown list has 1 field which is all the different options to filter ds2 on.

Any help or different solutions would be gratefully received