Today, I've been asked about how to do Image Captcha in CFMX7 by my ex-colleague. Well, I didn't see so far image manipulation in CFMX7 but most of CF developer use ImageCFC. Honestly, I don't want them to use ImageCFC for only captcha function because I don't think they can manipulate it very well. That's why I suggest them to create "simple maths calculation formula (4+5 = ?)". Because it's very simple to create and don't need to consider for browser compatible and other risks.

I need to put following coding into form.cfm.

[More]

This entry was posted on November 29, 2010 at 4:29 AM and has received 1963 views. There are currently 0 comments. Print this entry.

Last weekday, I've read Flickr API developers section. As we all know, there is already CFlickr which support us to integrate CF and Flickr for uploading photos, retrieving photos and so on. But, I'm getting sick of installing this CFlickr in my blog because I only need to display my photography in my blog and don't want to upload and edit anymore.

To display Flickr in our blog, we can also use with RSS feed. If we use RSS feed by retrieving data from Flickr, Flickr will product small images. I've already posted about it in my blog already. Simple Flickr Integration But I don't like those small thumbnail. What I gonna do if I want to display medium thumbail? Answer is very simple. "Use Flickr API"

Usage of Flickr API

[More]

This entry was posted on November 28, 2010 at 11:12 PM and has received 2512 views. There are currently 0 comments. Print this entry.

In my current company, our Project Manager told our team just like if DB can handle data manipulation, let them do. Don't put load on Coldfusion for data manipulation. Regarding his guild-lines, we're about to create Stored Procedure, Functions and Views at Oracle. That's why I need to learn more Oracle's commands and functions. Meanwhile, I found Oracle for Loop and abort function. Usage is kinda simple and I'll compare it them with CFLoop.

Here is For Loop usage in Oracle

Here is example

Above coding, we loop 1 to 7 and concatenate LCOUNT value into MYCOUNT. Within looping, stop looping if LCOUNT reach 7.

[More]

This entry was posted on November 22, 2010 at 4:19 PM and has received 1944 views. There are currently 2 comments. Print this entry.

Today, I've developed Simple Flickr Integration with Coldfusion. It's just simple and no thing to be surprised what I've done. As we all, Flickr support us to give API features for integrate with them. But, it's not right time for me to use this Flickr API because I don't want to upload any photo to Flickr via my blog or website because of bandwidth limitation at my hosting.

Here is coding which fetch photograph from Flickr.

Here is my photography on Flickr

This entry was posted on November 19, 2010 at 8:50 PM and has received 1996 views. There are currently 0 comments. Print this entry.

Today I've wrote new complex stored procedure in Oracle for HL7 interface. As I mention in above post, I'm very new to Oracle and haven't known yet all of Oracle's functions and commands. But I need to create new Oracle stored procedure for existing project. When I creating Stored Procedure, I've found two different looping of Cursor. There are Open Cursor and For Loop cursor. Both of them are equal to retrieve data from table but different performance.

As far as I know, Open cursor stands for limited data amount handling and will get slow when large data amount in it. For loop cursor can handle large data amount.

[More]

This entry was posted on November 10, 2010 at 11:57 PM and has received 2356 views. There are currently 0 comments. Print this entry.

I got a problem to test web-spider created by Raymond in my blog yesterday. Even I put the right files and the right coding into my blog, I couldn't test and run this file. I don't know why and I don't want to bother to him anymore. That's why I kept troubleshooting for it by myself. Few minutes later, I just found it's because of Railo.

In Adobe Coldfusion, we need to write the following code if we want to get content from the website inside in CFScript.

In Railo, it's quite different. We need to write the following code if we want to get content from the website inside in CFScript.

That's the first one I know different between Railo and Adobe. I think there might have a few different functions and tags between them. I can't convince why Railo don't want to develop the same function structure and calling style like Adobe Coldfusion. I think they're trying to make simple than Adobe Coldfusion.

[More]

This entry was posted on November 9, 2010 at 12:01 AM and has received 2184 views. There are currently 7 comments. Print this entry.

Adobe Coldfusion 9 exam is out on 5th Nov 2010. That's why I need to upgrade Coldfusion 8 certification to 9 soon. If not, my Coldfusion 8 certificate will be expired soon. I got there are different between Coldfusion 8 and Coldfusion 9 about Topic Area.

Topic area of Adobe Coldfusion 8

1. Programming Fundamentals

2. Working with the Application framework

3. Handling exceptions

4. Interacting with databases

5. Working with XML

6. Reusing code

7. Managing client state

8. Interacting with remote systems

9. Managing files

10. Tuning application performance

11. Delivering and presenting information

Adobe ColdFusion 8 Developer Certification Examination Specification

[More]

This entry was posted on November 5, 2010 at 8:17 AM and has received 1997 views. There are currently 0 comments. Print this entry. Download attachment.

In these days, I'm on HL7 project and need to create functions and store procedures in Oracle for message sending. In our HL7 standard, all of transaction will be manipulated by Oracle and don't make busy to Coldfusion due to we use less coding inside in CFML file and hope Oracle can manipulate the large data amount than CFML.

Honestly, I'm very new to Oracle and still need self-learning Oracle's functions and commands for developing Functions and Store Procedures.

First of all, I've recently finished reading Cursor Loop in Oracle. Because I need to concatenate the data come from table.

[More]

This entry was posted on November 4, 2010 at 12:54 AM and has received 3304 views. There are currently 0 comments. Print this entry.

As we all know, there are a lot of functions in Coldfusion and I can't know all of them when I need to use. That's why I print out all of Coldfusion functions lists and put it on my wall. Even I did it already, I missed to use some core functions to put my projects. REMatch is one of them.

The usage of REMatch is to compare two strings and return the match string both of them as array. Adobe recommend that when we're gonna use REMatch, try it with regular expression and which will be powerful.

Before I didn't know REMatch function, I've created ListGetDifferent function by myself for searching the same value and the different value between two lists.

http://www.ppshein.net/index.cfm/2010/9/9/compare-list-in-coldfusion

Once I know REMatch, I feel I don't need to use my own UDF anymore when I need to compare two string but NOT list.

[More]

This entry was posted on November 2, 2010 at 6:50 PM and has received 1871 views. There are currently 0 comments. Print this entry.

In these days, our system is getting slow and sometimes it hangs even there are not much that data in our database. That's why I kept troubleshooting which bugs made it to getting slow. Obviously, everything seemed fine in my codes and I strongly believed that it might not be because of my codes. But I found I put a lot of CreateUUID() in my codes for getting random value.

So I googled about CreateUUID() in Adobe. Oddly, Adobe mention like that Calling the createUUID function multiple times under load in Macromedia ColdFusion MX and higher can cause the Windows system clock to accelerate.

Regarding Adobe announcements, I need to change the way of getting random value

instead of

This entry was posted on November 1, 2010 at 9:23 PM and has received 1586 views. There are currently 4 comments. Print this entry.