I think the issue is that you don't have the off_id in the rsMGposts recordset. You need to add that column to the recordset so it can keep track of which record you are updating.
Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.
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.