Recently, we have given ability in our one of the project to export data in excel sheet. For exporting data into excel we used POI Utility from Ben Nadel. In this package there are so many excel type conversion such as date, numeric, formula.. In exporting data into excel we have given formula to calculate percentage. For example (A3*D3)/100. All things work fine. Client needs to enter only value for calculating percentage amount.(eg. 2.5, 0.75).

Recently I am trying to upload a file and I get error message “An error occurred during the FTP putfile operation”. The CFFTP tag has one attribute ‘timeout’. It specifies maximum numbers of seconds (time) taken to perform CFFTP action (operation). Here, I am not specified the ‘timeout’ attribute of CFFTP tag. So it take default value ‘30’ seconds. And that cause the issue to upload large size files (size in MB) that takes more than 30 seconds to upload.

Implicit constructor for CFC
ColdFusion10 now support initialize while instantiate the CFC by passing key-value pair or struct. This method will NOT work if your CFC has init() method or initMethod attribute in CFCOMPONENT added. To enable implicit constructor specify accessors=true in cfcomponent or you have setter function for properties defined. If you define setter = false or setter not defined then value for that property will not set instead it will call onMissingMethod defined for CFC.

Got strange issue today while working with mySql and ColdFusion. This might be old issue but we never face issue since we normally work with MS Sql and I think this one is second/third project which use mysql as database. Error says java.sql.SQLException: value '.........with long garbage string and special characters......' can not be represented as java.sql.Date and this is due to mysql store 0000-00-00 stored as Null value of date.

Day 14 on ColdFusion 10, I haven't cover much in last 13 days but go deeper in functionality. Today I keep working with schedule task enhancement and research on event handler feature. This will let us define functions which will call on particular event. Following event/method supported in event handler CFC.

• onTaskStart : Call every time when task start, If function return false will not execute schedule.
• onMisFire : Call anytime schedule file misfire (other than schedule time) any how it only fire first time for me when I create schedule file and but later on manual call doesn't invoke.
• onTaskEnd: Call execution of task end.
• onError: Call on exception on task, either 404 or 500 error. P.S. This will not invoke in case of syntax error in your coldfusion page.
• execute : ColdFusion 10 allow you to write code in cfc function instead of calling any URL, if you do not provide URL while creating schedule file then it will look for execute function in your event handler but URL will get priority if both available.

In my last post I have covered Group and list scheduler enhancement in ColdFusion 10. Today I have spent some time with event hander and other enhancement. In coldfusion 10 added new attribute mode which task application or server as value, this will let you specify task is server specific or application specific and default mode is server. Application specific task can be created from Application only and it will not be editable from ColdFusion administrator although you can run, pause or delete it from there.

In yesterday blog I have list out all new feature added in schedule task in ColdFusion 10. Now time to test it out, covering list, group feature in this post. While creating schedule we can put schedule in specific group and later you can pause all/resume all schedule in same group without firing individual command. And list option added in action attribute which list out all current schedules in query format.

Schedule task is something that I used lot and specially one of our clients love to get email periodically for different reports. In many case we get limited with ColdFusion 9 schedule task, like for one of schedule task require to reschedule on different time once executed and time vary per database transaction. Following are list of new feature in schedule task.