Blog

April 29, 2010
Clear values of all form elements using jQuery

Hello friends,

I always wanted to have one common function to reset all form elements. Please have a look at jQuery code that does the same thing. It finds out all element of form and loops over it and reset them. I hope this thing will be helpful specifically where there are many search fields and you need to reset them frequently ...

Read More
Comments(0)
Tags: jQuery
April 27, 2010
Correct Method to check if a Javascript function is Exists or not

Hi everyone,

Sometime you might want to call a function in Javascript but check whether the function exists or not before calling it. You can test if a function exists in Javascript by simply testing for the name of it in an if() condition.

But Note that you can't test for the function name by itself.
This will work but if the function doesn't exist the Javascript will error out ...

Read More
Comments(0)
Tags: HTML, JavaScript, jQuery
April 27, 2010
List all databases, objects, tables by a simple single line query.

Hello,

Try below query and see all databases and objects get listed in sql server.

sp_msforeachdb 'select "?" AS db, * from [?].sys.tables';
Read More
Comments(0)
Tags: SqlServer
April 24, 2010
ColdFusion And AJAX File Upload

Hello All,

I have created simple jquery plugin for file upload.
I have used multiple file upload in Ajax but it’s not possible to upload file in Ajax.
This problem can be solved by this two method.

  1. flash to solve this problem.
  2. JavaScript works.

Javascript works more nice than Flash.

Read More
Comments(0)
Tags: ColdFusion, jQuery
April 24, 2010
Visitor's Browser Window Display Area

To know the available display area in a visitors browser excluding the pixels occupied by the toolbars and other add-ons on the users browser use the following javascript code ...

Read More
Comments(0)
Tags: HTML
April 23, 2010
Overwrite old click event function Not Working in IE

Hi everyone
I just came across this problem that is happening in IE.
In the html I am adding an onclick event to an element that calls a function 'changeStatus' like this ...

Read More
Comments(0)
Tags: HTML, jQuery
April 23, 2010
Facing nested param serialization problem - Appending "[]" after variable - jQuery.

Our current application has been affected by a change in the latest jQuery (1.4.1) from the previous release.

In form submission using ajax, jQuery now posts multiple selectbox or checkboxes values with a character "[]" appended to variable (I think jQuery is being more favorable to PHP).

I used firebug to look my argument passed. Just look below how it passed an argument with "[]" appended ...

Read More
Comments(1)
Tags: jQuery
April 22, 2010
Find longest executing queries in sql server (2005,2008)

Hi guys,

I have been working with queries today and wanted to find some queries which was very high on its execution time. There was a need in the project to find out which query is running longest in sql server to avoid time outs and to optimize those queries for better performance. See the script below and definately it will be really helpful to you for better performing backend ...

Read More
Comments(0)
Tags: SqlServer
April 21, 2010
mssql - copy data from one table to another existing table

Hello friends,

Today, there was a need to insert data from one table to another table. There are many ways to insert data from one to another. Sql server provides a functionality to copy data from one to another using SELECT clause also. I hope it may be helpful for you ...

Read More
By Bharat Patel
Comments(2)
Tags: SqlServer
April 19, 2010
cfquery using cfscript

Hello Friends,

We can use cfscript to execute a query passing SQL statements to a data source. We can execute sql statement using execute method with query object. Look below for explaination and details. I hope it is helpful for you.

How to define query object in cfscript ...

Read More
By Bharat Patel
Comments(3)
Tags: ColdFusion9