The SQL MODEL clause was introduced as a new feature in Oracle 10g. Mark Rittman has a good article about how to use the new clause to generate financial statements.

The upcoming CFMX 7 updater, codenamed “Merrimack”, is in beta and will be released later this year. The updater will provide, in addition to bug fixes, improved platform support and will surface the “CFCProxy” machinery to allow Java code to call ColdFusion Components. The platforms include: Mac OS X native installer, RHAS 3.0 / 4.0, […]

If you are like me, you will not shy away from exploring new technologies. AJAX is becoming more and more popular among web developers. If you use ColdFusion and would like to take advantage of all the cool things AJAX can do, CFAjax is for you.

CFAjax is the AJAX implementation for ColdFusion. It makes ColdFusion […]

A couple of nice-to-know queries:

SELECT SESSIONTIMEZONE FROM DUAL;

returns the time zone of the client session.

SELECT DBTIMEZONE FROM DUAL;

returns the time zone of the database server.

Did you know that in addition to the function NVL, Oracle also has the function NVL2? which is quite different than its cousin NVL. So, what does NVL2 do?

It is not always easy to attach those big files to e-mail messages as the attachment limit for most ISPs is about 10MB. Don’t be disappointed - there are some slick –and free–Web sites for sending really big files. Both Dropload and YouSendIt let you send single files of up to 1GB in size. (Warning: […]

Did you know that Oracle PL/SQL packages can have an initialization section? The initialization part of a package is run only once, the first time you reference the package. Here is an example:

Right after I upgraded to CFMX7 a while back, I started getting the following error on some of my pages:

ColdFusion was unable to perform the CFLOCATION operation. Location URL cannot contain (carriage return) CR or (line feed) LF characters

I noticed that all of the pages that were generating this error had the function […]

From Oracle JDeveloper’s FAQ answering the question: Why is Oracle making JDeveloper free?

Free tools have an undeniable momentum right now in the Java development community. Oracle is taking free tools to a more advanced level of SOA application development by offering more than just a free Java IDE: Oracle is offering its complete […]

From the Google Blog:

Last October Keyhole and Google joined forces to integrate satellite imagery with Google search technology in a single product. Now we’ve landed on Google Earth. You can fly from space right down to any place on the planet and take in spectacular 3D views, and for major US cities […]