Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › DataAssist › Delete All But The Latest One

Delete All But The Latest One

Thread began 4/08/2009 2:22 am by meister281653 | Last modified 4/08/2009 7:45 am by Ray Borduin | 1801 views | 2 replies |

4/08/2009 2:22 am | #1 meister281653

Delete All But The Latest One

Hi there,

I got a lots of Database entries. Now I want to delete all but the latest one. How does that work?

Denis

4/08/2009 4:45 am | #2 Ian

Just a stab in the dark, but retrieve the recordset ordered by the unique ID field descending.

Store that Unique ID in a Session Variable and then delete all records that are not equal to that Session Variable.

The DA Delete code may need some manual tweaking for that though..

Cheers
Ian

4/08/2009 7:45 am | #3 Ray BorduinWebAssist

You could probably just use a query like:

DELETE FROM tablename WHERE tableID <> (SELECT tableID FROM tablename ORDER BY tableID DESC Limit 1)

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.