Category: web development

MySQL: remove special character from DB field

UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘<‘, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘>’, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘”‘, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘%’, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘;’, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘(‘, ”); UPDATE table_name SET `field_name` = REPLACE(`field_name`, ‘)’,… Continue reading MySQL: remove special character from DB field

Visual Studio 2011 Express for web beta (Visual Studio 2012)

I started using it from several days ago at work. Good Intellisence for CSS, which is really useful Intellisence for JavaScript, heard that’s working. Build in Unit Test, not used yet though Real time search functionality. As soon as you type a keyword editor shows the result on screen, which is the same function as… Continue reading Visual Studio 2011 Express for web beta (Visual Studio 2012)

Unit Test Getting Started

Which is the best one? http://stackoverflow.com/questions/393184/which-unit-test-framework-and-how-to-get-started-for-asp-net-mvc Many recommend xUnit, but NUnit and MSTest is easy to start. So, I’ll start with NUnit, cause MSTest doesn’t support WVD 2010 express. How to setup NUnit at VWM 2010 express Or Visual Studio C# express http://www.dijksterhuis.org/setting-up-nunit-for-c-unit-testing-with-visual-studio-c-express-2008/ BTW, Good news, WVD 2011 beta has MS unit test out of… Continue reading Unit Test Getting Started