My blog was almost dead last weekend because which encountered get 28 error in mysql. That's why I was seeking how come this error occurred in my blog. After a few hours, I found that query cache in mysql exceed the limited amount due to struct function of Coldfusion.

As the outcome of troubleshooting, using Struct in coldfusion may leak database memory and should make clear all value in Struct after using.

In mysql, Coldfusion create the blank temporary table for struct function when we using it. After assigning value into struct by developers, Coldfusion also adding value from struct into the blank temporary table.

For every single request, Coldfusion always create the single blank temporary table for struct. For million requests, Coldfusion will also do like that? :)

This entry was posted on October 31, 2010 at 7:07 PM and has received 1665 views. There are currently 0 comments. Print this entry.

Today, I found that using enablecfoutputonly in cfsetting can suppress white space.

Normal coding

Render this coding and look at View source. You will get there is "space" between number and [br] tag.

With cfsetting with enablecfoutputonly.

Render this coding and look at View source. You will get there is no "space" between number and [br] tag.

This entry was posted on October 30, 2010 at 9:09 PM and has received 3025 views. There are currently 0 comments. Print this entry.

Since I've been assigned into application project, I'm too rare to use cfcache in my project. Because it's live-time application that's why we don't need to cache any information anyhow. But now, it's time to use cfcache in our application for enhancing performance. So I gotta learn through the usage of cfcache and the properties of the attributes of it. Among them, I really like "dependson" attritube of cfcache. How it works is, it will flush the page if found any value in this attribute is changed.

This entry was posted on October 25, 2010 at 6:58 PM and has received 1751 views. There are currently 0 comments. Print this entry.

Well, I'm very new to involve at any interfaces in my life. Since August 2010, I have a chance to learn HL7 interface for my company which are going to integrate with another hospital software. When I need to send our information to another system, I always generate XML file and send them. When receive their information from them, receive XML file either and install our system. Once I heard HL7 interface, I thought they will also use integrated file as XML (because XML is standardize file system for integrated two systems). Actually, they use txt file as their integrated file.

HL7 means Health Level Seven which dedicated to share information between two hospitals (maybe, to others as well). In HL7, there are so many standardize events and segments (which has one to many relationships means one event has so many segments). For example, A01 event called Admit Patient which has MSH, EVN, PID, PV1 and so on.

[More]

This entry was posted on October 24, 2010 at 7:25 PM and has received 1891 views. There are currently 2 comments. Print this entry.

I've spent 24 hours for migration my official blog from MangoBlog to BlogCFC. I don't want to clarify why I decided to move from MangoBlog to BlogCFC because most of facts have been clarified by Nil at his blog. http://nil.checksite.co.uk

For me, the important reason that I choose BlogCFC because of Mobile version and others are such as tweetbacks and gravatars picture from comment (which I really like this one :)).

MangoBlog has also advantages such as one-click-plugin-installation and themes which are based on Blogger and Wordpress. Please don't get me wrong either.

Database migration? No idea. I configured two databases by myself(manual) because my hosting is based on Railo which doesn't currently support ORM.

[More]

This entry was posted on October 23, 2010 at 12:55 AM and has received 2525 views. There are currently 2 comments. Print this entry.

Today, I found that cfcontinue is same as continue of javascript. I'm not sure whether it would be useful or not even you're trying to use looping. I'm not sure why Adobe add cfcontinue as new tag in Coldfusion 9. I think, it would be useful for somewhere else. But for me, it's so far to use. Usage of cfcontinue is just like continue in javascript. If action happen in condition, Coldfusion will skip this action and will continue the rest of looping.

[More]

This entry was posted on October 20, 2010 at 9:42 PM and has received 1601 views. There are currently 1 comments. Print this entry.

Honestly, I'm so far to use cfcomponent in my life rather than cffunction. Because, most of our applications are based on Coldfusion MX7 before and which have been recently upgraded to coldfusion 9 for almost 1 year. That's why I lost some new features of Coldfusion 8 and 9. As CFdevelopers told, CFC is the most powerful tool in Coldfusion and can recover the some weakness of Coldfusion MX. That's why, I tried to use CFC and cfcomponent is very simple and not make developers to feel complicated. First of all, I need to create new cfc file called myTest.cfc.

[More]

This entry was posted on October 19, 2010 at 2:11 AM and has received 2111 views. There are currently 0 comments. Print this entry.

In these days, I'm so far to learn for my javascript enhancement. In my last project, I need to write about auto-refresh timer for ChChRart. In these coding, I was supposed to use setTimeOut. Unfortunately, it can't support my Chart to refresh always. Actually, it can refresh only one time once the page has been rendered. That's why I tried to use setInterval.

setTimeOut : action will be run (only one time) defined milliseconds are timeout. setInterval: action will be run always whenever defined milliseconds are timeout.

[More]

This entry was posted on October 18, 2010 at 7:07 PM and has received 1781 views. There are currently 2 comments. Print this entry.

Before time, I didn't notice doctype declaration at the top of every pages and I don't either know how does it work. Yesterday, I created a new style sheet about change button style when mouse-over. As you know, it's very simple to do for developers and don't need to create much coding for it. After creating and then I tested, it doesn't work. I bet all are correct in my style. Here is stylesheet.

[More]

This entry was posted on October 17, 2010 at 4:25 AM and has received 3072 views. There are currently 0 comments. Print this entry.

Today, I've tested how to load content like facebook and twitter when scrolling down at the bottom of document. I feel it's cool and flexible for developers and users. As mention in previous post, don't need to include pagination and don't need to retrieve all data from database.By using like that, we can save our client time to click pagination link and don't need them to worry how many pages he/she already clicked. In this demo, index.cfm is the main page and action.cfm will display the rest of limited records when scrolling down at the bottom of document.

[More]

This entry was posted on October 14, 2010 at 7:28 PM and has received 3796 views. There are currently 12 comments. Print this entry.