I need to update some content, preferable directly in the DB as i need to update some href src values from the inner img value. I migrated the content using cmsimport (love it by the way), when i perform an update statement directly in the SQL db even with the cache off the editor seems still to load the old html code rather then the updated one. the frontend will load the correct html. Anybody an idea how i can get this fixed. As mentioned this is only a one time thing, so don't care if it's dirty.
html code is something like <a href='needtoreplace'><img src='media/pic1.jpg' />some text</a>
which i convert in tsql to <a href='media/pic1.jpg'><img src='media/pic1.jpg' />some text</a>
Updating content in DB - Migration issue
I need to update some content, preferable directly in the DB as i need to update some href src values from the inner img value. I migrated the content using cmsimport (love it by the way), when i perform an update statement directly in the SQL db even with the cache off the editor seems still to load the old html code rather then the updated one. the frontend will load the correct html. Anybody an idea how i can get this fixed. As mentioned this is only a one time thing, so don't care if it's dirty.
html code is something like <a href='needtoreplace'><img src='media/pic1.jpg' />some text</a>
which i convert in tsql to <a href='media/pic1.jpg'><img src='media/pic1.jpg' />some text</a>
I think the best way is to use the contentService API. Working directly in the database can be tricky.
Dave
Yes as Dave says use the ContentService API :)
is working on a reply...