Find and Replace SQL queries for DotNetNuke - 3 Videos
Posted by: DNN Creative Magazine for DotNetNuke,
on 02 Jul 2007 |
View original | Bookmarked: 0 time(s)
(To fix problems after transferring a localhost database to a live website and other useful functions)
In this video tutorial we demonstrate using a Find and Replace SQL procedure to fix problems such as editing image urls after uploading a localhost installation to a live website.
This means that you can automatically adjust any html code within the text / html module across all of the pages in your DotNetNuke installation in a matter of seconds, rather than manually editing each page.
This method can also be used for editing words in the text / html module. For instance, suppose you wish to change your company name, you can apply these SQL techniques to search for the current company name and replace it with a new company name.
Other techniques can include searching for inline CSS code in the text/html module, such as font tags, and deleting all of the code so that all styling comes from the skin.css files.