Recently, I've found that CF9 doesn't give any error if filefield attribute isn't set in cffile. I'm not sure whether it's good or not. Because I've developed simple program for migration data from old server to new server with *.csv file. I've developed and tested it in CF9 and it working fine. But when I deployed it into CFMX server, I got the error just like "filefield attribute in cffile is .....". That's why I was amazed and how come it error is coming out even thought it works fine in our UAT server. So, I've looked through cffile tag and check filefield attribute is missing or not. Oddly, it's really missing. Now, I can convince that CF9 won't give you any error message if you don't want to set filefield attribute cffile. Cool or not, I'm not sure.

This entry was posted on February 27, 2011 at 6:04 PM and has received 1996 views. There are currently 0 comments. Print this entry.

This week is very busy time for me. Because I have to implement HL7 segment with Oracle Stored Procedure. As we all know, Oracle SQL command isn't that same with Microsoft SQL. That's why some of command are very complicated for me to implement. Today, I need to retrieve the only one latest record from table with Oracle. In Coldfusion, it's very easy. To put maxrows = "1" and descending in query as follow:

In Microsoft, it's very simple. To put TOP command and descending in query as follow:

In Oracle, it's not that easy. If we put ROWNUM and descending in query, the first record will be returned. Because ROWNUM doesn't work with Order By descending in query. That's why we need to do with query with query formula in Oracle as follow:

Phweee...!!! Oracle crack my brain again. :)

This entry was posted on February 22, 2011 at 3:11 AM and has received 1678 views. There are currently 0 comments. Print this entry.

I cannot convince why query execution time is damn slow with "BlockFactor". Last week, I've read the following article from Adobe Performance tuning for ColdFusion applications. In this article, the author recommended that using "BlockFactor" in CFQuery can substantial performance gain.

blockFactor By default, the cfquery tag returns results sets from databases one record at a time. The blockFactor attribute tells ColdFusion server (which passes this information to the database driver) to retrieve between 1 and 100 records at a time. For queries that typically return result sets larger than a single row, requesting multiple rows in a block can result in a substantial performance gain. Setting this value too high can diminish performance as well, so it is recommended that you tune this number based on the expected average size of the result set.

Note: If you know that less than 100 rows will be returned (for example if you're writing a query that either returns 0 or 1 rows), do not bother adding the blockFactor attribute.

[More]

This entry was posted on February 16, 2011 at 12:35 AM and has received 1780 views. There are currently 8 comments. Print this entry.

I've found yesterday that Raymond wrote Two quick Application.cfc questions on his blog It's simple questions with so many hidden questions for me. Honestly, I'm too rare to use application.cfc and "this" scope in current projects. Because most of our projects are based on CFMX7. That's why I sometimes self-studying by myself when I wanna learn new things in Coldfusion.

After reading this post and comments, I realized that we can declare two variables between "this" scope in application.cfc. There are "this.name" and "this.datasource". So, I've tested as follow:

When I run this coding, the result is as follow:

I found that this.name="TestingCFC" is stored as applicationname in Coldfusion. On the other hand, I lost this.datasource = "DSNTestingCFC". It's odd that Coldfusion can automatically recognize that current datasource name is "DSNTestingCFC" in CFQuery tag.

This entry was posted on February 13, 2011 at 5:18 PM and has received 2305 views. There are currently 0 comments. Print this entry.

Today, I've read how to create Google Chrome extension. It's interesting and want to create Blog Feed Reader. That's why I kept going with this article and create a simple extension for blogCFC.

First of all, I need to create a folder for the extension. Then, create manifest.json file and needed to put following coding into it.

After that, I need a image to represent the extension on Google Chrome Toolbar.

[More]

This entry was posted on February 8, 2011 at 11:02 PM and has received 2342 views. There are currently 19 comments. Print this entry. Download attachment.

In my previous post, I've shown To increase the speed of Coldfusion application. Fortunately, @James Moberg commented about between the performance of CFLoop and CFScript Loop. He told me that For Loop in CFScript is oddly slower than CFloop. As some developers' suggestion, using everything (probably) CFScript is faster than others comparing the performance and rendering time. That's why I want to test the different between CFScript Loop and CFLoop with CF8 and CF9.

I've created the following simple coding and render in CF8 first.

[More]

This entry was posted on February 7, 2011 at 5:24 PM and has received 3086 views. There are currently 7 comments. Print this entry.

In my previous time, I didn't notice the performance of our CF application. Because all CF applications are fine and working smoothly with less data amount in local internet. Approximately, we don't have no more 20 tables in our database and not more than 100000 records in each tables. That's why never encounter our server is hanging and crushed. When we launched our project to Live, our server sometimes hang and application timeout. My GM told me that it's because of CF cannot handle the large amount of data and we should change to .NET (C#) version. I cannot accept his suggestion. It's not because of CF. It's because of the way of our coding. That's why we need to figure out the solutions and need to enhance our coding. In our coding, we use a lot of evaluate and looping. In Adobe documentation, using evaluate may decrease of CF performance and use other available functions instead of evaluate. That's why we need to change our coding as follow:

[More]

This entry was posted on February 6, 2011 at 5:25 AM and has received 2561 views. There are currently 8 comments. Print this entry.

Creating user in Microsoft SQL is very simple. It's to go Microsoft SQL enterprise manager and create user it. In Oracle, creating user in sqlplus is simple. I'm not sure whether there is another way or not. But we normally use sqlplus when we need to create user.

First of all, I need to login into sqlplus. Then, need to type following command.

This entry was posted on February 1, 2011 at 5:28 PM and has received 2501 views. There are currently 0 comments. Print this entry.