Software / Technology Tips

The DATETIME function’s major change in SQL Server 2008 is the four DATETIME data types that are newly introduced. They are : DATE, TIME, DATETIMEOFFSET and DATETIME2. In addition to these newly introduce data types, there are new DATETIME functions also present. DATE Data type:- In SQL Server 2008, this data type is used to…

Most of the biggest blunders are caused by small – silly mistakes –ALWAYS be alert when you use the Live build.·         Check the back-up policy of your Live application DB with your client. Encourage them to have at least a daily backup of the database. All it costs is few minutes of setup work and…

I have seen many beginners confused over the use of # sign in ColdFusion and most are so confused that they use it anywhere they can! I have been asked this question so many times, that I decided to write about it. The basic thing you need to remember about using # in ColdFusion is…

Here are some steps through which we can integrate facebook in our site using php with zend framework. Here I am going to discuss on how to integrate facebook in your site using php with zend framework. For this you have to first register your application in facebook. Please check the following URL “ Here…

We generally use ColdFusion tags in our coding. But sometimes we prefer to use script version of that, instead the tag. Also in ColdFusion 9.0.1 have a script version code for almost every tags. In ColdFusion 9.0.1 the script version of cfquery has a bug as follows. Let our table name is “USERS(USER_ID, FIRST_NAME, LAST_NAME,…

SQL Server returns data in a random order. A simple SELECT returns data in the order they were entered.. Although we can have our results returned in the order in which they were entered, but the only way to ensure the order is the use of ORDER BY clause. The following shows how to sort the…

While using the function member, any numbers of parameter (including none) may appear in the calling function based on need. So to have a flexible function we can use params modifier while writing the definition of functions. The params keyword specify a method parameter that takes an argument where the numbers of arguments become variable…

Step 1: Open the “functions.php” of your theme and search for function {theme_name}_widgets_init(). If you are going to create your theme from scratch then, you have to define this function otherwise above function is             already present and you have to modify it. Step 2: In the above function write the below code for each widget…

This tip is to handle the scenario where the user needs to extract the transaction details from some text file or other source and show them on POS Transaction screen programmatically from RMS custom POS Add-Ins. Suppose the user has retrieved all the required values to be populated on transaction screen then by using the…

In many projects, YouTube videos are embedded and there is a need to display these images in grid view. For displaying videos in grid view, we have to create another view for thumbnail view, create objects for this view and add it to the main view. However, I have a simpler and effective solution for this: Sample Project for…