Today, I've got problem because of messy of Microsoft Word comments in our database. It's because of our clients wrote some messages in MsWord and paste these into CFTextarea richtext data. That's why those data cannot be displayed at our project. It's my bad that I have not thought about how to prevent these kind of problems during project development.

[More]

This entry was posted on December 27, 2012 at 2:32 AM and has received 1049 views. There are currently 0 comments. Print this entry.

Today, I've created simple UDF for convert date format "dd/mm/yyyy" to "mm/dd/yyy". Because our clients want to use "dd/mm/yyyy" format as our national format into our projects. You may all know that it's very easy to convert but it's dedicated to those who start learning Coldfusion UDF.

[More]

This entry was posted on December 24, 2012 at 1:49 AM and has received 848 views. There are currently 0 comments. Print this entry.

As we all know if webservices of another party using window NT authentication, we cannot use CFInvoke for calling webservices. At that time, we need another 3rd party webservices integrator for coldfusion to access another party. At that time, we need to use CFObject instead of CFInvoke.

This entry was posted on August 14, 2012 at 10:06 PM and has received 1231 views. There are currently 2 comments. Print this entry.

In my previous post (here to view), I've mentioned how to replace Javascript Alert box with CFMessageBox. Here again, to replace Javascript Confirm box with CFMessage.

[More]

This entry was posted on June 19, 2012 at 2:24 AM and has received 1436 views. There are currently 0 comments. Print this entry.

Today I got the problem that I cannot use following sentence in one of my instance.

And hit JS error and don't know why. That's why I just go viewsource and found that CFIDE is missing for one of my CF instances. I cannot convince why Adobe cannot include CFIDE for multiple instances installation. That's why I know there is two ways to solve this bug of Coldfusion multiple instance installation.

[More]

This entry was posted on December 23, 2011 at 11:13 PM and has received 1958 views. There are currently 4 comments. Print this entry.

Today, I've oddly found IncrementValue in Coldfusion. In my previous time, when I need to increase count in Coldfusion, I always use as follow.

[More]

This entry was posted on November 5, 2011 at 2:04 AM and has received 1680 views. There are currently 9 comments. Print this entry.

I'm now planning to take Coldfusion 9 exam for my career enhancement. Because I'm Adobe Certified Expert in Coldfusion 8 and I feel like myself to take Coldfusion 9 either. Some people will argue that certificates are not needed if you really know of it but for new career, it's needed. When I want to apply for new job, I'm not sure whether the new employer know I really know Coldfusion or not without having certificate. 

Coldfusion 9 Exam Structure

• Programming fundamentals
• Working with the Application framework
• Interacting with databases
• Working with components
• Interacting with persistent components
• Working with XML
• Reusing code
• Interacting with remote systems
• Managing files
• Tuning application performance
• Building advanced user interfaces
• Reporting

[More]

This entry was posted on October 12, 2011 at 3:46 AM and has received 2116 views. There are currently 0 comments. Print this entry.

Today I need to fetch data from *.csv (which has nearly 15,000 records) file and insert such data into our database. At that time, I need to consider how to retrieve data from this file and how to insert into our database. So, I need to consider which method I need to use between "looping in array" and "ListToArray". That's why I've wrote with "looping in array" first.

Here is simple list data including in CSV file.

[More]

This entry was posted on September 29, 2011 at 5:25 PM and has received 1487 views. There are currently 9 comments. Print this entry.

These days I'm about to develop growth chart module for my current project enhancement. In this growth chart, I need to merge two chart series called area chart and bar chart to display patient percentile. In Coldfusion Chart, if we're trying to merge two chartseries, x-axis of both must be same records. If not, our chart might be displayed wrong data.

Here is my sample coding of CFChart.

[More]

This entry was posted on September 20, 2011 at 9:32 PM and has received 1408 views. There are currently 0 comments. Print this entry.

Today, I found that cfthrow is very useful to me for error handling in my project. Because prior programmer of my current wrote some funny code for error handling without using cfthrow. I'm not sure whether they don't know cfthrow or not. Honestly, I didn't know most of Coldfusion Tags and functions before I took CF8 exam. When preparing for CF8 exam, I know most of tags and functions of CF8. Thanks, CF8 exam.

Ok, let's continue. Here is funny coding our prior programmer wrote.

[More]

This entry was posted on July 19, 2011 at 6:24 PM and has received 1689 views. There are currently 2 comments. Print this entry.