SQL query to link report column depending on value
In this example I will show how to set link column and exclude some columns depending on their value. Suppose I want to link only those records who got active…
Check for existing record using stored procedure in ASP.NET
Check for existing record in SQL Server database using stored procedure In this example I will explain, how to check for record exist before insert data into a table in…
Formatting report column in currency in Oracle
Here is the little script to convert number to char and trailing with $ symbol. select new_cost, to_char( old_cost,'$999,99,999') as original_cost from cpt_products; It displays result like – 12227 $6,000…
Enable disable button using JQuery
Sometimes you need to disable or enable some elements in your document and jQuery makes this task easy. All you have to do is to set disabled attribute to “disabled”.…