Against All Odds - CF Function

Remove MSWord comment in Coldfusion

Thu, 27 Dec 2012 02:32:00 -0700

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]

Convert date format UDF

Mon, 24 Dec 2012 01:49:00 -0700

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]

Webservices without using cfinvoke

Tue, 14 Aug 2012 22:06:00 -0700

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.

Replace Javascript Confirm box with CFMessagebox

Tue, 19 Jun 2012 02:24:00 -0700

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.


function DisplayMessageConfirm (obj, messageText) {
	var RandCount = Math.random();
	
	ColdFusion.MessageBox.create(obj + RandCount, 'confirm', 'CESID', messageText, onfinish, {width:300, modal:true});
	ColdFusion.MessageBox.show(obj + RandCount);
}

[More]

CFIDE with multiple instance

Fri, 23 Dec 2011 23:13:00 -0700

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]

IncrementValue in Coldfusion is useful

Sat, 05 Nov 2011 02:04:00 -0700

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.






	mycount++;

[More]

Coldfusion 9 exam preparation

Wed, 12 Oct 2011 03:46:00 -0700

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]

ListToArray and Looping in Array

Thu, 29 Sep 2011 17:25:00 -0700

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.


007|PPSHEIN|MALE|COLDFUSION DEVELOPER
008|MIKE|MALE|ANDROID DEVELOPER
009|RAYMON|MALE|APPLE DEVELOPER

[More]

Merge Area Chart and Bar Chart in Coldfusion

Tue, 20 Sep 2011 21:32:00 -0700

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]

Playing with CFThrow

Tue, 19 Jul 2011 18:24:00 -0700

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]

Type in cflock is very important

Mon, 04 Jul 2011 19:42:00 -0700

Today, I realized that "type" in cflock is very important and essential for shared data manipulation. In Adobe Coldfusion documentation, which said "type" is optional in cflock but when we need to process shared data, it's not optional. IT'S VERY IMPORTANT. Why I know like that is because of I'm currently preventing about concurrency issues for my project. In these coding, we already used cftransaction as putting the whole queries and processes within cftransaction but cannot prevent at all. After that, I've put cflock again outside of cftransaction like that. [More]

ListToArray save my time

Tue, 31 May 2011 23:48:00 -0700

Currently, I'm on HL7 module for my current project. For HL7 project, we need to collect all of patient information and save it into text file. After that, we need to send this text file to another party. So we need to send all patient data by creating list value and separated by "|" as delimiters. Here is example of MSH segment information.


MSH|^~\&|HISSAH|HISSAH|PCS||201106011138||ADT^A36|AHIS00000004|P|2.3|||AL|NE|||||

For this case, we don't know how to check whether all of sequences are correct or not. If we check manually, it will take so long and not efficient for our testers and system analyst. That's why I need to write simple Coldfusion program for that. That's why I wrote the following coding.

#i#

[More]

FileExists vs IsImage in Coldfusion

Sun, 29 May 2011 19:25:00 -0700

Today, I'm very clear to know how to use FileExists and IsImage in coldfusion. Before time, I though these two tags working in the same boat but once I used these two, both are very different but slightly same.

What's the slightly same? It's very simple that we're not using the full path of file like that.




	Image exists.

	Image doesn't exist.




	File exists.

	File doesn't exist.

If we're using the full path of image/file, FileExists doesn't work at all. At that time, we need to use IsImage for checking image exist or not.




	Image exists.

	Image doesn't exist.

Because, FileExists can check the directory of image/file and cannot check the full path URL of image/file. In this case, we need to use IsImage for checking image exists or valid type of image.

Sorry, I really missed out IsImageFile function of coldfusion which can support to check whether an image file is valid. Thanks, Ray for commenting about that.

Funny usage of CFImage within CFTry/CFCatch

Sat, 28 May 2011 21:46:00 -0700

Last Friday, my boss told me that I need to cooperate my module into other team's huge project called HIS (Hospital Information System) about displaying patient's photograph. That's why I needed to review their existing coding and needed to know the image path (directory). In this coding, I've found the following funny usage about cfimage within cftry/cfcatch.

If I'm not mistaken, the purpose of above coding is the error message will be shown if no image found. As my experience, don't need to use cfimage, cftry, cfcatch tags if we need to check whether the image is existed or not. Just simple to use FileExists. It's very useful and don't need to write that much coding like above. Here is very simple and useful for checking file/image exists or not.

Concurrency between CFLock and CFTransaction

Mon, 25 Apr 2011 23:40:00 -0700

In these days, our project encounter concurrency issues which mean two users can access to one item and this item cannot be correctly updated after processing. As we all, Coldfusion provide CFLock and CFTransaction for concurrency but I don't know which one is useful and suitable yet. In my existing project, they've used CFTransaction for concurrency but those issues are still happening whatever they've used it in. That's why I need to check which one is suitable for concurrency. I've created three files for testing purpose. There are index.cfm, cflock.cfm and cftransaction.cfm. index.cfm


[iframe src="cftransaction.cfm?getID=1" width="500" height="150"][/iframe]
[iframe src="cftransaction.cfm?getID=2" width="500" height="150"][/iframe]
[iframe src="cftransaction.cfm?getID=3" width="500" height="150"][/iframe]

[More]