Microsoft SQL Server | MySQL LIMIT equivalent in Microsoft SQL Server

written by : Kailash Kumar ( Software Engineer )
August 25, 2016
|
0 Comments
|

Suppose you want to retrieve values from row from 5 to 10 from a table in SQL server. Since LIMIT keyword does not work in it so we can use any of these 2 alternative methods:

Solution 1 :

SELECT * FROM ( SELECT *, ROW_NUMBER() OVER (ORDER BY name) as row FROM TableName Read more…

How to access Moodle files outside the Moodle?

written by : Shalini Vashist ( Software Technical Lead )
|
0 Comments
|

We can access Moodle outside the Moodle (without login) by passing token in the URL.

For example :

http://localhost/Moodle_new/webservice/pluginfile.php/26/qtype_match/subquestion/17/5/6/PineApple.jpg?token=6yhg9331af9d9284abb36cyjh0c67114a

If token is not be passed into the URL, then it redirects to Moodle’s login screen Read more…

Get Salesforce SObject name through Salesforce Record Id

written by : Virender Singh ( Senior Software Engineer )
August 24, 2016
|
0 Comments
|

Description : We have Salesforce recordId but need to identify what is the type of Sobject corresponding to this record id.

Solution : We can get Sobject name from recordId with getSobjectType() function, sample code below:

Apex Code :

public void echoSObjectName(String RecID)
{
objName = RecID.getSobjectType();
System.debug(‘Object Name is ‘ + objName Read more…

CakePHP bake: SQLSTATE[42S02]: Base table or view not found

written by : Rita Sharma ( Software Consultant )
|
0 Comments
|

While running cake bake command for cakephp 3.0 we got the following error:

SQLSTATE[42S02]: Base table or view not found: 1146 Table ‘tablename .columnname’ doesn’t exist

The culprit was a column with name test_id in one of the tables. As per bake command’s conventions about foreign Read more…

Salesforce | How to replace depreciated custom component ‘HTML Area’ for home page

written by : Harish Chauhan ( Senior Software Engineer )
August 23, 2016
|
0 Comments
|

In the release of summer 14 Salesforce added the functionality of creating custom component for the home page.

In the past we were able to write HTML code in Salesforce using the HTML area under custom components on home page. For example if we needed to show RSS feed on Read more…

Selenium IDE | Test a form with multiple data sets

written by : Dixit Soni ( Software Test Engineer )
|
0 Comments
|

If we have a Registration form and we want to test it with multiple datasets by using Selenium IDE then we have to follow these steps:

1. First record the whole process of form filling with one set of data

2. The data will be collected as shown below in Read more…

Salesforce | Convert DateTime to Epoch format

written by : Savina Chandla ( Senior Software Engineer )
August 22, 2016
|
0 Comments
|

In Salesforce apex code, we can use DateTime class methods to convert date and time to required format. And in one such case we needed to get Datetime in epoch format, also known as Unix TimeStamp for saving date and time.

To get the epoch from a datetime variable we Read more…

Heroku | Change PHP session timeout

written by : Nitin Pant ( System Administrator )
|
0 Comments
|

In Heroku, there is no way to change HTTP session timeout (or some other php.ini settings) from user interface. For this create a file with name .user.ini and specify the properties in it. This file is to be created in root folder of project.

In our case we Read more…

Moodle/Totara | Create custom fields for a course

written by : Neha Mishra ( Senior Software Engineer )
August 19, 2016
|
0 Comments
|

Create custom fields for a course in Moodle/Totara

1. Go to Site administration. Select custom fields inside Courses as shown below :

2. Select option – which type of custom field do you want (say, menu of choices).

3. Fill the below form as per your requirement and save.

4. Now Read more…

Selenium | Mass CSV file generation by fetching data from database

written by : Sumit Sharma ( Software Test Engineer )
|
0 Comments
|

In a project we are working on there are large number of pdf files for which field mapping data is stored in the database. In this project pdf forms are auto filled with data from Salesforce. Which PDF form field is mapped to which corresponding Salesforce object or field is Read more…

Font family looks regular in Ubuntu and Windows but looks bold in Mac

written by : Kajal Marwaha ( Web Designer )
August 18, 2016
|
0 Comments
|

In one of our web development projects, we used font family named Calibri for breadcrumbs. This font worked fine on Ubuntu and Windows but on each browser of Mac fonts appeared bold.

We wrote the following code for making the text font normal and consistent for all operating systems :

.breadcrumb Read more…

CakePHP | Redirect from http to https URL

written by : Kailash Kumar ( Software Engineer )
|
0 Comments
|

If you want to redirect from http to https in CakePHP, generally redirect method code is like this

$this­->redirect(array(“controller” => “myController”,”action” =>t; “myAction”));

But if your site is running on http protocol it will redirect to the url with http protocol:

‘http://www.kailash.com/myController Read more…

Insurance Agency Management System – Direct versus Agency Billing

written by : Varun Chopra ( CEO )
August 17, 2016
|
0 Comments
|

Basics first – Client is the insured person or who gets himself, his property or vehicle insured by the insurance company. Insurance company is also known as Insurance Carrier or insurer. And there is insurance agency that acts as interface between Client and Carrier to make it easy for Client to Read more…

Moodle and Java | Retrieving users’ data from Moodle using External Java Application

written by : Richa Sharma ( Software Engineer )
|
0 Comments
|

Retrieving users’ data from Moodle using External Java Application

We can write a basic REST moodle client code using Java to fetch users’ records from moodle. Before writing the code, you need to perform below steps in Moodle which are required in order to fetch the data:

1. Create external Read more…

AWS EC2 | How to automate the Snapshot command

written by : Navneet Kashyap ( Senior System Administrator )
August 16, 2016
|
0 Comments
|

You can create snapshots of the EBS volume which can help to restore to a prior state in future if required. Better is you can create a bash script and put the commands for taking snapshot in it and then put the script in task scheduler to run at specific Read more…

Linux | Installation of custom AWS metrics script & prerequisites for AMI

written by : Navneet Kashyap ( Senior System Administrator )
|
0 Comments
|

1.1 Login to Amazon Linux-AMI / Centos / RedHat.

Using ssh

1.2 To Upgrade from a previous version of the scripts :

# sudo yum install perl-DateTime

1.3 To install the scripts for the first time

# sudo yum install perl-DateTime perl-Sys-Syslog perl-LWP-Protocol-https

1 Read more…

Selenium | How to count the number of products on a web page

written by : Namisha Arora ( Software Testing Consultant )
August 12, 2016
|
0 Comments
|

In this post I will give an example of a Selenium script to count the number of products displayed on a web page. This is the screenshot of webpage:

As you can see products are displayed row wise with 4 products in 1 row. On scrolling down there are many Read more…

MySQL | A short note on database indexes

written by : Kunal Kumar ( Software Engineer )
|
0 Comments
|

Index is used for storing values for a specific column in a table. An index is created on a column of a table and used to speed up search queries.

For Example :

Suppose we have a database table called Users with three columns – User_Name, User_Age, and User_Address. Assume that this Read more…

Curl | How to test a Restful web service using curl

written by : Rita Sharma ( Software Consultant )
August 11, 2016
|
0 Comments
|

Let’s consider, we have a demo Restful service (created in Java Spring here but you can create in any language) to login user which accepts username and password as input and returns Success/Failure in response.

Request Object : Demo Login Request class

Response Object :

Here is how to call Read more…

Cakephp 3.0 | Steps to create theme controller

written by : Rita Sharma ( Software Consultant )
|
0 Comments
|

Description : Cakephp 3.0 provides a way to display different front end view for different clients using Themes. Theme is a plugin which follows the same structure as other cakephp plugins. Before Cakephp 3.0 it was only used to separate front end view for the clients. But in Cakephp Read more…

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 Next page ›
Send your message