DZone Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

Snippets has posted 5883 posts at DZone. View Full User Profile

Change

07.18.2008
| 2488 views |
  • submit to reddit
        // description of your code here

change this:

        db_dml revision_add {
            insert into mfp_notesi (item_id, revision_id, title)
            values (:item_id, :revision_id, :title)
        }


for this:

        db_exec_plsql revision_add {
            select content_revision__new(:title, null, null, null, null, :title, :item_id, :revision_id, null, null, null)
        }

        db_dml insert_note {
            insert into mfp_notes (note_id) values (:revision_id)
        }