Software / Technology Tips

At times we do face problems modifying names of a table or a column after the application has been scaled. This is more problematic when working with large applications as I have learnt from experience. It generally requires a lot of rework with existing codes. So lately, in my PHP projects I have been using global_db_config…

Description: Suppose we have a form that should appear automatically filled out based on information pulled from a database. We have several datatype fields. Printing out “True” or “False” , “Yes” or “No” on the required field as per the information wuldn’t look nice, as this is supposed to look like a form that has…

Challenge: I was given a scenario in which i need to represent a large number by few character it must be hard to break the code. For ex: A 8 digit number into 5-6 character. That too uniquely identified per number (i.e code corresponding to each number should not match the code corresponding to different…

To my knowledge perhaps the least used operator in C# is the null-coalescing operator . But you can use it effectively to reduce the lines of code you write . The null-coalesce operator can be used to define / return a default value for a nullable value type / reference type and this is represented…

In wordpress stylesheet and javascript can be added in the traditional conventional way. For eg this But problem arises when we go for child themes. If we build a child theme, it inherits all of its theme templates from the parent theme, unless we give it its own copy of a particular template. So if…

I have faced some situations earlier in which something was getting done by looping though data structures but i wanted to overcome that. Then in process of avoiding those looping, i came to know some interesting and helpful functions in C#. These are: Select() function: How to convert a string array to an integer array?…

Sometimes we require a vertical toolbar in ipad because we don’t have any controller for this. This code give you a vertical toolbar. This is the .h file for toolBar ToolBar.h-> @interface toolBar : UIView { CGPoint origin_; UISegmentedControl* SegmentedControl_; NSArray* SegmentImageArray_; } - (id) initWithOrigin:(CGPoint) origin; - (void) makeToolBar; @end ToolBar.m file-> #import "toolBar.h"…

Regular expressions are a powerful tooI as most of you will agree but how does one use it with SQL queries ? Recently I had a requirement where I had to write a query that searches for the word “test” in a description field. Usually we use MYSQL “LIKE” or “Full Text” index queries to…

A pie chart is a circular chart divided into sectors. In a pie chart, the arc length of each sector is proportional to the quantity it represents. It is used to showcase different percentages of an entity distributed with time or any other parameter. For example it can be used to show Profit of a…

SQL Server 2005 introduced the OUTPUT clause that I appreciate and want to demonstrate. We can use this clause to capture values from inserted and deleted virtual tables. Previously this data was only available through triggers. So Output returns information based on each rows affected by an INSERT, UPDATE, DELETE, or MERGE statement. These results…