Knowledge Base

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…

Sourav Paul August 4, 2024 No Comments

How to restrict your Google Map Autocomplete API to any country?

If you are using Google Map AutoComplete API, and if you want that AutoComplete input only show the country which you want, will only show…

Saikat Mondal August 3, 2024 No Comments

How to add menu in WordPress admin panel ?

Here we see how to add custom menu in admin sidebar. Sometimes when we work with plugins and we need to show some features or…

Snigdha Paul August 3, 2024 No Comments

How to write transaction in cfscript?

transaction { try { // code to run transaction action="commit"; } catch(any e) { transaction action="rollback"; } } try-catch is optional in transaction but is…

Sujan Kundu August 3, 2024 No Comments

How to Install or Enable IIS Manager on Windows?

Internet Information Services (IIS) is a Microsoft web server that runs on the Windows operating system and is used to exchange static and dynamic web…

Anirban Poddar August 3, 2024 No Comments

Add custom class in avatar image via filter hooks.

To add a custom class in wordpress avatar image, we have to use filter hooks in get_avatar function. Filter hooks example: //avatar custom class function…

Rohit Patra August 3, 2024 2 Comments

How to use the ORDER BY clause in an inner MS SQL?

Sample Table:- emp_idemp_namejob_namedep_id68319KAYLINGPRESIDENT100166928BLAZEMANAGER300167858SCARLETANALYST200163679SANDRINECLERK2001 sql:- SELECT * FROM ( SELECT * FROM ( SELECT emp_id, emp_name, job_name, dep_id, ROW_NUMBER( ) OVER( ORDER BY dep_id ) AS…