techiners.in

TVF Pitchers

TVF- THE VIRAL FEVER

Before I begin with the Web Series, Let me introduce about TVF. What is TVF? TVF-ONE : India's Premium Online Entertainment Network, owned and operated by 'The Viral Fever Group'. TVF-ONE is India's first and biggest Organized OnlineTV, where you can watch regular shows and content, created especially for the young audience, across genres like Humor/Drama/Trends etc. on its channels 'TVF-Qtiyapa' & 'TVF-RecycleBin'. The Viral Fever or (TVF), Founded by Arunabh Kumar, is a new age Media Brand, driven by the spirit of "Lights...Camera...Experiment !" with businesses in Branded Content, Live Events, TV Shows, Production Services and Youth Entertainment.

WHAT WE WILL WE LEARN IN THIS POST?

After reading this post we must be able to fetch one or all record from the table conditionally. We will fetch one record based on the condition mentioned in where clause or all records when a particular value is to be retrieved. i.e., we can either select one record of our choice or all records when we choose some particular value. This is useful when we need to fetch single record or to display all records to the user. Either show selected record or all records.

HOW WE ARE GOING TO ACHIEVE THIS?

We will use most common, simple select statement and some variables along with Boolean Logic. Why Boolean Logic? Because we won't use case or if else statement.

Lets begin our excursion...

Unlike Split() function in C#, we don't have any pre-defined in SQL, that splits the string containing the delimiter. While during development, it is sometimes required the functionality of split function similar to that of C# in SQL too.

After a very long time, techiners back again with a new post that will explain the process of creating a function that split the string containing the delimiter, which accepts two parameters- one string and other delimiter.

The first parameter is the string that contains the delimiter and needs to be split across it.

So without much ado, lets start...

This post will highlight a very common error that comes often when we visit a webpage/website that uses AJAX. We know that in AJAX we have anonymous functions like: success, error etc. success gets called when our ajax request gets successfully completed and it returns a response whereas error gets called when ajax encounters a problem in processing a request.

Create a pop up window

Sometimes in our application we need to take input dynamically from the user such as when a user tries to submit a form which contains a drop down for selecting a Country that is mandatory, but the Country is not present in the drop down list which the user wants to select. If this is the case, than probably user will select any country in order to get rid of the error message of selecting mandatory country. There must be a way to dynamically add new country. So, In this post we will learn how to create a pop up window using jquery that will allow the user to add new country simultaneously loading it into drop down and make available for selection.