Originally Said By: Dooza
Well my solution wasn't easy, and it took several attempts to make a page work as expected.Here is mine: pricebook.dataset.asp
The form doesn't submit, it has a button that when clicked executes some Javascript. This gets the values from the selected selects, then constructs a querystring, and reloads a Spry dataset. The dataset is from an XML file that is generated from the database. The query used in creating the XML is a stored procedure that takes up 5 parameters.
There is actually 2 XML datasets reloaded, one is for the manufacturer filter. I created some custom code to handle the filter.
I did have to modify the Web Assist code slightly to show/hide the other drop downs. There are up to 4 drop downs available depending on the categories selected.
It wasn't easy this way, but without Web Assist changing or adding some code I couldn't see any other way of this working.
Steve
Off Topic, but how are you creating the XML from the DB? Is there an ASP page involved that performs the query and outputs/writes in XML? I've been looking for a solution to this for a while, but I only found PHP solutions.
