Categories
MySQL

Create Trigger in MySQL

Using CREATE TRIGGER statement you can create a trigger. You have to put the trigger name after the trigger statement. Let’s see an example of Create Trigger: For example we have two tables i.e. users and userhistory. users:userIDfirstNamelastName userhistory:userIDlast_update Read Also: INSERT … ON DUPLICATE KEY UPDATE Now we will create a trigger before update […]

Categories
Css3

Columns using CSS3

It is very difficult to pull off column-based layouts in CSS. But, now there is a way to this using the CSS rule – columns i.e. Columns using CSS3. Columns using CSS3 – HTML: <div class=”container”> <p>But I must explain to you how all this mistaken idea of denouncing pleasure and praising pain was born […]

Categories
KnockoutJS

KnockoutJS – Observables

3 concepts in which KnockoutJS is build upon is:– Through observables dom elements and ViewModel exchange information– Bindings between UI and ViewModel– Templating web applications To make it observable declare as:this.property = ko.observable(‘value’); Let’s try below Observables example: <!DOCTYPE html> <head> <title>KnockoutJS – Observables</title> <script type=”text/javascript” src=”http://ajax.aspnetcdn.com/ajax/knockout/knockout-3.1.0.js”></script> </head> <body> <!– This is input box, used […]

Categories
KnockoutJS

KnockoutJS MVVM Application Framework

Now a days everyone use a single page application i.e. all necessary information are gathered into a single page and KnockoutJS is no exception of this which uses MVVM Application Framework. This is a client side framework which very easily bind html to domain data with MVVM pattern. MVVM is an architectural design pattern for […]

Categories
Corporate

How Many Hours Are International Students Allowed to Work in Canada?

Canada is also an ideal alternative for overseas students who want to get a good education and live in a cosmopolitan environment while working part-time. Students from India and other parts of the world must know and comprehend the rules and regulations governing working hours in order to maintain a balance between studies and finances. […]

Categories
AngularJS

AngularJS internationalization

For internationalization AngularJS uses three types of filters i.e. currency, date and numbers. We need to incorporate corresponding js depends on locale of the country. <script src=”https://code.angularjs.org/1.2.5/i18n/angular-locale_da-dk.js”></script>

Categories
MySQL

MySQL custom row number in a result set

You can add a sequential number as a custom row number of a row using SET clause and increment at next row. Suppose users table has columns name and age.When you want to show the result you want to add extra column serial_no. So using below query you can achieve custom row number: SET @serial_number = […]

Categories
Business Feature Story

6 Reasons to Hire a Professional Land Clearing Contractor

Just because your land is readily available doesn’t necessarily mean you can use it. Most of the time, you must prepare it to grow crops or start a construction project. One of the best ways to prepare your land is to clear it. Some landowners strongly believe they can clear their lands. However, if a […]

Categories
MySQL

MySQL Trigger

MySQL triggers are nothing but a SQL statement stored in the database. When any event associate with a table is fired i.e. insert, update or delete a trigger is executed. TRUNCATE statement delete the all data in a table but does not execute the triggers associated with this. The different between trigger and stored procedure […]

Categories
jQuery

SlidesJS, a jQuery responsive slideshow plug-in

SlidesJS is a jQuery responsive slideshow plug-in for version 1.7.1+ with various features like responsive, CSS3 transition. It has the following features: Responsive CSS3 transitions Touch effect Easy setup Options width (number) & height (number) start (number) navigation (object) pagination (object) play (object) effect (object) callback (function) Here is a simple example: <!doctype html> <head> […]