Editing recordsets

I have an update page which I need to alter the recordset, I need to add additional filter which I do, then save then upload and everything is great.
But when I go back to that page in DW and open the resordset it reverts the query to the old one without the additional filters, and something writes a new recordset with the same name!

How should I update the recordset created by DataAssist?

Nick

This seems very strange.

If you try and edit a recordset via the Dreamweaver recordset bindings interface, I find that dreamweaver often duplicates the recordset, so you get 2 recordsets with the same name.

Have you tried editing the recordset manually in the code window, without opening up the bindings interface ?

Yes, and that works fine for adding ot he select statement but the the WA/DW has a very specific method of writing the the where statement when filtering by Session, Get or Post. Often I like to open the recordset via the pallet the copy the query to work with in a query editor.

Just opening the recordset breaks it!

Nick

can you send a copy of your page so I can examine the code to see if there is something there that may be causing the issue.