Recordset Behavior

I think it's time to add a Recordset behavior to DataAssist. The built in one with Dreamweaver has always been limited. Here are a few features that would be nice:

1. Extend the simple mode to include more than one filtering parameter, and be able to choose AND and OR
2. A Dynamic option when entering the variable/value for the filter - such as being able to select a session variable rather than trying to remember what it's called, exiting out of the dialog to find it.
3. And in the same section, be able to enter a result from a previous recordset. This would only work if the recordset that supplied the data came first, so it may have to reorder them. I've done this manually several times and it's a pain - not so much in entering the code for the Field value, but you get errors when the value is null.

DW has always been limited when it comes to generating recordsets so I tend not to use it unless it is a simple get all or filter by one.

I use Navicat which can make much more complex queries which can then be copied and pasted into the advanced query window