Search In
A Transaction groups a set of tasks into a single execution unit. Each transaction begins with a specific task and ends when all the tasks in the group successfully finish.If all of these tasks execute successfully, then a transaction is committed an
Hello Readers,
The below blog shows the pagination in Joomla.
When we use the pagination in Joomla, we require the model and the view to write the code.
Suppose we have a component (com_example).Open the component file (com_example/models/items.ph
To display or load more results, whether it is commenting on a blog website, like or images on social media or products on eCommerce website the best UX pattern for this is either pagination, a Load more button or infinite scrolling. In this tutorial
By default Ghost uses sqlite3. But if you want to configure Ghost with MySQL Database, you can reconfigure the default settings in config.js file.
Open config.js (<path-to-your-project>/config.js), replace the below lines of code:
database:
Many a times, we have come across a need that execution of DML statement on one database table should lead to modification in another table with some specific set of values. What’s the novice way to do? Simple, fire the first modification query then
This blog will help user learn how to avoid the duplicate entries in the database. Storing duplicate values in the table must be avoided while inserting data in the database table. As these duplicate entries can create many problem in the application
With the help of SQL Order By statement we can sort our data in a table either in ascending order or descending order based upon the user, what he wants.
Note -> Some Databases have already sort the data order by default .
Syntax :
select express
Manual Penetration Test:-
It is very hard to discover entire vulnerabilities by applying automated tools.There are few vulnerabilities which can be determined by manual checks only. Penetration testers can accomplish more better attacks on software
Hello All,
Working with asp.net web api, we have multiple ways of handling error that is at controller level, method level we can use try and catch block and we can put our logic there to handle errors.
But to handle error occurred any where in our
CTE:Common Table Expressions
1)CTE's replace subqueries i.e they are result of complex queries so can be defined as temporary resultset.
2)CTE's are mainly used for recursive programming.
3)The lifetime of CTE's is the individual query it live in
