In Postgresql we can save the default timestamp with now() method:
CREATE TABLE test
(
id serial NOT NULL,
name character varying(255),
last_modified_time timestamp without time zone DEFAULT now()
)
This will save the date timestamp in this format:
If we want to use the last_modified_time in code we usually convert Read more…
Adding images and links in Jira
1. Adding an image in Jira comment: There are two ways using which we can insert an image in Jira:
User can specify various attributes to the image such as height, width, horizontal space, Vertical space etc.
For example:
2. Adding an Read more…
Whenever the situation occurs to rerender the page contents without reloading the whole page, we use ajax in it. By using ajax we get the response data back in the success function which we will show on the screen. Let’s have a look:
Screenshot 1
In the above screenshot Read more…
1. Log on to AWS console account.
2. Click on Snapshot option:

3. Right Click on the desired snapshot ID and select Modify permissions:
4. Select the option whether to share it publicly or you can share it in private:
5. Add the valid AWS Account Number in the provided Read more…
When we pass a floating point value to a variable, then the value which we store in the variable is not the actual value but it is something approximately near to that number which transfers to that variable.
Let us understand this by a PHP example:
<?php Read more…
How to enable or disable autocommit of changes in MySQL using MySQL workbench?
Go to Edit->Preferences->SQL Editor->SQL Execution and check your current settings:
Also commit/rollback can be done with the buttons on SQL tab Read more…
Situation: We have a web to lead form and every time we create a lead it always takes “Personal” as record type which is default record type in our org. We want to set another recordType like Agentco or Trucking etc of lead.
Initially, we thought that triggers Read more…
AWS: Upgrading MySQL version
Below are few step to upgrade Mysql version very easily on AWS-RDS:
1. Log on to AWS console.
2. Open AWS RDS from Database section:
3. Click on Instances:
4. Select the Database Instance which you want to upgrade:
5. Right Click on Read more…
Truncate records from custom object in Salesforce without using apex code
Salesforce provides a feature to delete bulk records for the standard objects. This can be achieved by navigating Setup -> Data Management-> Mass Delete Records.
But in case we want to delete large amount of records for a custom object Read more…
Using tools and steps listed below we can implement web distribution and Load balancer in AWS and also this will save cost of buying ssl certificate from CA authorized vendors. Instead, it will use certificates provided by Amazon server.
Tools to use AWS CloudFront, Route53, Elastic Load Balancing and Read more…
WebRequest gives response in the form of Stream. In order to use it further in the form of c# object, I have used below code:
Sample code :
WebRequest requestHttp = WebRequest.Create(reqURL);
using(WebResponse responseHttpRequest = requestHttp.GetResponse()) {
Stream responseStream = responseHttpRequest.GetResponseStream();;
StreamReader reader = new StreamReader(responseStream);
string text = reader.ReadToEnd Read more…
Problem: What is the difference between using the final keyword with a primitive versus an object? What is immutability and can final assure that?
Final: Final is a keyword in java which is used to make variable, methods, classes immutable. It means we can’t change Read more…
Platform: DocuSign
Problem: How to download form data (i.e. Data filled by the client in docusign document) in csv?
Solution: For downloading the Docuform data as CSV file follow these steps:
1. Open your docusign account.
2. From the Documents page locate the Read more…
In Cakephp, console applications are useful in running background processes and can be run without access to web browser. The CakePHP console provides a framework for creating shell scripts.To run the cakephp functions, first of all create a shell to use in console.
For example, create a TestShell in Read more…
C# – Exception in salesforce login with valid credentials
Stacktrace :
Exception thrown: ‘Salesforce.Common.ForceAuthException’ in Salesforce.Common.dll
Exception thrown: ‘Salesforce.Common.ForceAuthException’ in mscorlib.dll
at Salesforce.Common.AuthenticationClient.d__1.MoveNext()
Description :
I am using oauth-rest api to login into salesforce. I have passed valid consumer key, secret Read more…
While testing Registration form, the best way is to use automation script rather than manual testing which is time consuming. Automated script helps to get better results in shorter time. Like we can generate random users with the script and test the form with multiple hits at the same time Read more…
Error: Call to undefined function mcrypt_encrypt()
Description: In one of our project, I was trying to save a field value in encrypted format in the database, using PHP, which could be retrieved back to its normal value, where we need to display it.
So for that Read more…
Install the AWS CLI Using the MSI Installer (Windows)
Download the AWS CLI MSI installer for Windows (64-bit) click-here or directly access https://s3.amazonaws.com/aws-cli/AWSCLI64.msi.
Run the above downloaded MSI installer. Follow the instructions that appear:
The CLI installs to C:\Program Files Read more…
If we follow cakephp rules to create a form then we can use cakephp inbuilt functionality like we don’t need to assign labels to form fields. Cakephp automatically creates a label for each form field also in case of update/insert validation error messages, the message is automatically shown Read more…
DevExtreme is a commercial application framework created by DevExpress. DevExtreme framework uses html5 and javascript code and targets today’s most popular smartphones and tablet devices. Devextreme supports both mobile application and web application.
In devextreme there are three flavors of the core functionality that we can use in our Read more…
