Category: Zoho
Shopify webhook getting fired multiple times and then getting deleted from shopify store
In our Shopify store we have an order creation webhook that points to a cakephp action URL. The action that webhook points to fetches the order data and then saves this to the database. The problem that we were facing
Sorting Alphanumeric Data in PHP
While fetching data from database, in SQL query I had ‘order by’ clause but the results were not sorted when the data was in alphanumeric form. The reason for this is that SQL sorts character by character from left to
Why Hadoop and Big Data are getting popular
Surprisingly, over 90% of the data in the world today has been created only in the last couple of years. With the revolution in mobile industry, social media networks, sharing of digital photos and videos online we are continuing to
CakePHP | How to handle special characters (like apostrophes) in queries
Let us take an example: We have table employees with following fields: id int primary key, name varchar(50), city varchar(50) We have following records in the table: (1, isha, amr); (2, Hamlet’s, ghy); (3, éhjj, amr); 2nd and 3rd records
Salesforce | Data Loader Application error about upgrade to TLS 1.1 or Higher
You may receive receive error in Salesforce Data Loader Application about upgrade of TLS 1.1 or Higher. To resolve this issue follow these steps: Step 1: Install latest version of Java. Step 2: Goto setup in Salesforce > type Data
Why HTML tables are discouraged and HTML DIVs are promoted?
Sometimes we have a choice to use <table> tag or <div> tag but there are many advantages of using <div> tag over <table> tags. Firstly when browser loads a table it waits for entire table text to reach browser side
Support Plan Content
Support Plans IT support has become important for every business company, no matter what is the size of business. Some companies do not tie up with any IT company for maintaining their IT infrastructure as they feel they can take
PostgreSQL | Create a connection to a local postgres database in pgAdmin |||
Steps to create a connection to a local postgres database in pgAdmin ||| : 1. Make sure PostgresSql and its components should be installed in ubuntu system. 2. Check what databases are available in postgresSql through terminal 3. Login to
MySQL | How to support European characters on database level
European characters like è é å ñ ü ,à, è, ì, ò, ù – À, È, Ì, Ò, Ù, ™, © ,• , ∑, α, β, «, » do not get inserted correctly in MySQL by default. To fix it,