September 4, 2011
Static method implementation in ColdFusion

I found some discussion about static method equivalence in ColdFusion.

In C# we can declare class as static and static class can only have all the static methods and static variables. And we can call static class methods without creating its instance.

In ColdFusion we must need to create an instance of cfc. Then & then we can call it’s method. To avoid creating instance each time, you can create object in Application init() function, and make it at application scope, so you can directly call the methods. But this is still a nasty approach, as we are still creating an object when Application initializes.

Then I remember that ColdFusion is not an Object Oriented Language. We make it look like OOP! It happens mostly when we use ColdBox or Model Glue or any other application framework, where most of the coding is in cfc only. Now a days people are using cfscript tag more as Lots of tags are now available in cfscript. And when we use cfscript tag we, feel like it's an OOP language! But remember ColdFusion is a scripting language as PHP and Classic asp. cfscript tag itself trying to remind us by its name!


By Vikas
Tags: ColdFusion
August 27, 2011
sql server(store procedure) mechanism convert empty string date parameter to initial date(1900-01-01)

Hello Friends, It may you know about it but I would like to share this thing with you. We were working on one of project where we faced issue. we are storing data through sql server store procedure using date parameter. As per our logic, the date parameter has not date value it may be empty string. Whenever date parameter has empty string sql server store initial date(1900-01-01) in the date field. We checked our whole logic to find out how the initial date come if date parameter has an ...

By Bharat Patel
Tags: SqlServer
August 19, 2011
Work around ColdFusion local scope

Hi friends,

These days am working as a tester. I never thought that developer can also do that if they really take interest in testing! Infect someone can also learn from the testing, even testing can also test their understanding for knowledge.

While testing I saw one case where I get more variable in the array object other then I defined. Then I again take a look and I came to know that local variable was causing an issue.

Let me give you some examples and exercise. Make sure that before you see the output just think what would be the output. Consider that all following code is written in sample cfml page and we are using ColdFusion 9.

By Vikas
Tags: ColdFusion9, ColdFusion
August 17, 2011
Bug - count() function in ColdFusion query of query


It has been a great time since I started working on ColdFusion. I must say that it is the easiest language in the world and yet it is a powerful and can be compared to any major programming language.

In last few days, I was using ColdBox and MockBox framework in our current project. I was using query of query which is very similar to SQL query, and we can use it over query object in ColdFusion.

Count() is a math function, but if we use it with select statement like count(*), it returns a number of rows fetched in select query. I used it query of query, and it was giving me the correct count if my select statement is returning some rows, but if it is not returning any row then ideally it should give 0 as output, but it gives [empty string].

By Vikas
Tags: ColdFusion9, ColdFusion
August 8, 2011
How to use SQLite manager extension in Firefox?

Hi friends,

It was really strange when I installed an extension from Mozilla and I cannot find how to use it!!

Well Then I think there must be an icon, which I don't see on tool bar.

Right click on the top of the Firefox, and choose customize.
Then look for the SQLite icon, drag it to toolbar. Click on the icon to use it.

Simple? I can't say, because I find bit difficult!

Tags: FireFox
August 8, 2011
Understanding event handler and parallel processing


These days I am trying to play with browser’s local database. I get very much interesting experience while assigning a value to variable.

I used the following code in JavaScript (Only works in Firefox) ...

By Vikas
Tags: JavaScript
August 6, 2011
How to use query of query in cfscript

We can use queries of queries in cfscript with the Query.cfc. But this is possible in Coldfusion 9 because Query.cfc has introduced in Coldfusion 9.

Let's see the following code ...

Tags: ColdFusion9, ColdFusion
August 6, 2011
Introduction to HTM5 local data storage

Hi friend,

I am doing some research on HTML5 supported client side local storage.

HTML5 introduces some new concept to store information on client pc. It is very help and opens a new dimension to create offline applications.

For local storage, HTML5 accepts use of SQLite database. Each of the method uses SQLite database. There are main three methods:

1. localStorage
2. Web SQL
3. IndexedDB

By VIkas
Tags: HTML5, SQLite
August 4, 2011
CF Builder Error: "Unhandled event loop execution" when trying install new software

Got new project and started working this, going through documentation provided by client and where he mention code repository will be Git. Well, we use SVN for code version but never used Git, I do have idea about GIT and account in Github site but never get chance to look into it. As ususal to start with GIT first of all I look for eclipse plugin for this and found one at Thoguht to give try and click menu "Help >> Install New Software..." and get alert need to start builder with administrator. I guess this is because CFBuilder installed on program files folder which usually require administrative access to add/remove files in it. So restarted cfbuilder with administrative access and again click on same menu but this time nothing happen, tried twice, thrice but nothing happen.

Tags: CFBuilder, ColdFusion
July 20, 2011
Camera and read directory was not working in BlackBerry 5.0 PhoneGap application - solved


Camera and read directory was not working in BlackBerry models with OS 5.0 when using PhoneGap.



I had deleted json2.js file reference from my html page, because I was not using this js library anywhere in my project.

After spending 2 hours, I realize that this file was used by PhoneGap js api to use camera and read directory, specially in 5.0 OS devices.


I didn't find significance of this file in PhoneGap documentation. That's why developers will survive in open source market.

By Vikas
Tags: BlackBerry