Payment Gateways used in Australia

Paypal – Various ways of integration solutions – Transfer transaction data through Session. – Most preferred way for SME and NPOs. – Developer’s page and it’s explanation contents are a little unorganised, so it’s a bit hard to grasp a whole picture of services for new comers. – Developer Resource: X.com, Sandbox eWay – Build:… Continue reading Payment Gateways used in Australia

Use Sublime Text theme color in Visual Studio 2010

I started using Sublime Text since I went to the DDD event at Sydney, where all presenters were using Sublime Text as their main editor. Soon, I became a fan of it. Now I wanted to use its theme color on text editor screen in Visual Studio. Dark background with light font color may be… Continue reading Use Sublime Text theme color in Visual Studio 2010

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