DotNetNuke Daily Tip #8 7/5/06 Module Update SQL Scripts

DotNetNuke Daily Tip for 7/5/2006

After a brief haitus for the July 4 festivities here in the States the DotNetNuke Daily Tips are back!

For our daily tip today I'll be covering a minor item to watch out for when you develop your own custom modules using the DataProvider model. DotNetNuke's provider model and PrivateAssembly installer for modules can be an extremely powerful tool when you know how to use them. Here's one catch with the module upload process.

If you've developed a custom module and have upgrade scripts for your module that fire with the PA installer you may have SQL scripts have a '+' in them, perhaps concatenating strings together. You need to be sure to save the .SqlDataProvider file in UTF-8 format. I always seem to have the best luck doing this with plain old notepad. Open the file in notepad, save as, and be sure to choose UTF-8 as the encoding. You can make Visual Studio do this, but had some challenges actually getting VS to save properly with that encoding so I always open and save my files in Notepad just to be sure. If you don't do this you'll run into a few problems when you upload your modules via the PrivateAssembly installer and it tries to run the SQL scripts.

Stay tuned for another DotNetNuke Daily Tip coming tomorrow!