Software Engineering

Arun Giri August 17, 2024 No Comments

How to write different types of joins in SQL?

SQL JOIN A JOIN clause is used to combine rows from two or more tables, based on a related column between them. Different Types of SQL JOINs…

Snigdha Paul August 10, 2024 No Comments

How to reverse an array in Coldfusion?

<cfscript> myArray1 = [67,12,45,98]; writeOutput("Before reverse : "); writeDump(myArray1); myArray2 = reReplace( serializeJSON( myArray1[::-1] ), "\[|\]", "", "ALL" ); myArray1 = listToArray( myArray2, ",", false,…

Saikat Mondal August 10, 2024 No Comments

How to create WordPress custom user role for custom plugin ?

Create custom user role for a WordPress plugin by using WordPress built-in functions.1. Create the Plugin File : First create a custom plugin if you…

Sandeep Mandal August 10, 2024 No Comments

How to filter a query in cfscript?

Syntax: users = queryNew( "id,userType,name", "integer,varchar,varchar" ); queryAddRow(users, [{ id: 1, userType: "user", name: "John" },{ id: 2, userType: "admin", name: "Sam" },{ id: 3,…

Sourav Paul August 10, 2024 No Comments

How to do all the Ajax loading in one place?

If you have a lot of AJAX in a file and you want to add loading to them, then you can define this place without…

Anirban Poddar August 10, 2024 No Comments

How to create a child theme in wordpress?

First create a new folder in your wp-content/themes directory with a theme name, let’s name it ‘my-child-theme’. Now you have to create a file named style.css, It…

Rohit Patra August 10, 2024 No Comments

ColdFusion variables scope precedence ordering.

Description:- If you use a variable name without a scope prefix, ColdFusion checks the scopes in the following order to find the variable.ColdFusion searches variables…

Arun Giri August 10, 2024 No Comments

How to write insert and update operations in a single query?

When we attempt to update or insert a record based on the primary key, we use an if-else condition in our code base and write…

Sushovan Mukherjee August 5, 2024 No Comments

How to install Microsoft SQL Server on MacOS

You can install Microsoft SQL Server on Windows and Linux Operating Systems. However, you can use the docker system to install it on MacOS. Prerequisites…

Sourav Paul August 4, 2024 No Comments

How to restrict your input field just to take the number?

If you want an input in your form that you will only take the number in that input, no alphabet or any symbol, you can…

+91 943 331 9991