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