MySQL | Insert multiple records and update if record(s) already exist in a single query

| By Webner

In MySQL, we generally perform insert, update, select and delete operations on records of table. Multiple Insert operation can also be easily performed on table. Take an example of Employees table with fields: Multiple records can be inserted in Employees

Cordova/Phonegap | How to fix footer at bottom when virtual keyboard is opened

| By Webner

Problem : Footer is not visible or fixed at bottom, when virtual keyboard is opened in Phonegap/Cordova Application. Solution : Consider following div create for footer : <div data-role=”footer” data-position=”fixed” class=’custom_footer’ data-theme=’b’ data-tap-toggle=”false”></div> To keep Footer fixed at bottom and

Salesforce | Show picklist field value of custom object on Visualforce page

| By Webner

We can show the picklist field value on Visualforce page in a selectlist ( dropdown) using the following code in the controller class: public class classname { public List<SelectOption> selectItemsList() { List<SelectOption> selectOptions = new List<SelectOption>(); Schema.DescribeFieldResult describeResult = CustomObject__c.PickListFieldName__c.getDescribe();

Linux | How to grep only uncommented contents from any configuration file

| By Webner

Problem : How to grep only uncommented contents from any configuration file which is big in size, has many comments and blank lines Solution: This can be achieved by following single command : # grep -v ‘^$’ /etc/httpd/conf/httpd.conf | grep

Netsuite | Invalid email address or account number error on NetSuite, but passed correct credentials

| By Webner

ERROR: Invalid email address or account number error on NetSuite, but passed correct credentials. Need to authenticate NetSuite sandbox account through java application and fetch all the contacts. Below is the link to the WSDL file used to log in:

MySQL | Upgrade MySQL 5.5 to 5.6 in Ubuntu 14.04

| By Webner

MySql 5.5 is the default version for Ubuntu 14.04 Steps to Upgrade the mysql-server If you have existing database in Mysql 5.5. It should be migrated automatically. Take the backup of existing databases: mysql> mysqldump –lock-all-tables -u root -p -all-databases

Zoho | Create Zoho Subscription using the PHP and subscription API

| By Webner

We can create new Zoho Subscriptions via code by using PHP curl and with the help of Subscription APIs. Below is the sample code which is required to create a subscription: $headerArray = array(“Content-Type: application/json;charset=UTF-8”, “X-com-zoho-subscriptions-organizationid: 00000000”, “Authorization: Zoho-authtoken ——–Auth