FireworksColdFusionDreamweaverFreehandFlashMXHome
Latest New Content

Latest Free Content
View All
Free Content
Accessibility
CMX Learning Guides
Hosted by enterhost

ColdFusion


All Categories


Cartweaver Admin Hints and Mods - Part 10: Creating a Taxes Collected Report Using ColdFusion
by Tom Muck - 21-Oct-09
Reader Level: Reader Level

Cartweaver is an online shopping cart system available from www.cartweaver.com for PHP, ColdFusion, and ASP. It is intended as an easy-to-use solution for building an online store. It doesn't have all the bells and whistles of some of the more pricey carts available, but with a little coding, many new features can be added. This is part 10 in the series and will show how to set up a tax collected report in ColdFusion, using the existing orders report as a starting point.

The Cartweaver Admin Hints and Mods Series:
Cartweaver Admin Hints and Mods - Part 1: Creating a Low Stock Warning for PHP
Cartweaver Admin Hints and Mods - Part 2: Creating a Low Stock Warning for ColdFusion
Cartweaver Admin Hints and Mods - Part 3: Creating an Order Report Graph for ColdFusion
Cartweaver Admin Hints and Mods - Part 4: Creating an Order Report Graph for PHP
Cartweaver Admin Hints and Mods - Part 5: Adding Customer Search Parameters for ColdFusion
Cartweaver Admin Hints and Mods - Part 6 Adding Customer Search Parameters for PHP
Cartweaver Admin Hints and Mods - Part 7: Creating and Order Report for Products Using PHP
Cartweaver Admin Hints and Mods - Part 8: Creating an Order Report for Products Using ColdFusion
Cartweaver Admin Hints and Mods - Part 9: Creating a Taxes Collected Report Using PHP
Cartweaver Admin Hints and Mods - Part 10: Creating a Taxes Collected Report Using ColdFusion


Backing Up Databases For Offline Storage
by Adrian Senior - 14-Oct-09
Reader Level: Reader Level

If you are running your own server, then many hats are needed to ensure your clients data is correctly maintained. Everything from the web site and associated files, through to any database that might be used to support the web site needs to be backed up.

In this tutorial we will look at how to efficiently back up your SQL Server Databases and copy them down from the remote server for storing in a separate location. I use hardware within my office for this storage, the databases are copied down to my main machine and then copied across to an external hard drive. This process provides the latest backup in three different locations as well as providing a backup stack of the last thirty days for each database, that should cover all the bases nicely!


ColdFusion Worst Practices Part 2: Abusing Pound Signs (#)
by Ray West - 08-Oct-09
Reader Level: Reader Level

The pound sign (#) has a special meaning in ColdFusion. It tells the application server to evaluate what is inside the matching pound signs as a variable or an expression. If the value is a variable, or can be treated as an expression or a function, ColdFusion replaces the whole thing with the result of the evaluation.

However, using # signs is not always the best choice. You should not get it the habit of using them where they are not required. Overuse of pound signs can cause the server to work too hard and eventually cause performance issues. In this article we will look at several examples of when not using the # sign is the better choice.

The ColdFusion Worst Practices Series:
ColdFusion Worst Practices - Part 1: Misuing CFOUTPUT
ColdFusion Worst Practices - Part 2: Abusing Pound Signs (#)


Cartweaver Admin Hints and Mods - Part 8: Creating an Order Report for Products Using ColdFusion
by Tom Muck - 25-Sep-09
Reader Level: Reader Level

Cartweaver is an online shopping cart system available from www.cartweaver.com for PHP, ColdFusion, and ASP. It is intended as an easy-to-use solution for building an online store. It doesn't have all the bells and whistles of some of the more pricey carts available, but with a little coding, many new features can be added. This is part 8 in the series and will show how to set up a product sales report in ColdFusion, using the existing orders report as a starting point.

The Cartweaver Admin Hints and Mods Series:
Cartweaver Admin Hints and Mods - Part 1: Creating a Low Stock Warning for PHP
Cartweaver Admin Hints and Mods - Part 2: Creating a Low Stock Warning for ColdFusion
Cartweaver Admin Hints and Mods - Part 3: Creating an Order Report Graph for ColdFusion
Cartweaver Admin Hints and Mods - Part 4: Creating an Order Report Graph for PHP
Cartweaver Admin Hints and Mods - Part 5: Adding Customer Search Parameters for ColdFusion
Cartweaver Admin Hints and Mods - Part 6 Adding Customer Search Parameters for PHP
Cartweaver Admin Hints and Mods - Part 7: Creating and Order Report for Products Using PHP
Cartweaver Admin Hints and Mods - Part 8: Creating an Order Report for Products Using ColdFusion
Cartweaver Admin Hints and Mods - Part 9: Creating a Taxes Collected Report Using PHP
Cartweaver Admin Hints and Mods - Part 10: Creating a Taxes Collected Report Using ColdFusion


ColdFusion Worst Practices - Part 1: Misusing CFOUTPUT Free!
by Ray West - 11-Sep-09
Reader Level: Reader Level

In this series, we will try to highlight some worst practices in the use of ColdFusion syntax, features and options. These are not necessarily the kinds of things that will stop your site from working, but they are things that create bottlenecks, expose security weaknesses, or make your code difficult to read and maintain. In today's installment, we will look at the misuse of the CFOUTPUT tag.

The ColdFusion Worst Practices Series:
ColdFusion Worst Practices - Part 1: Misuing CFOUTPUT
ColdFusion Worst Practices - Part 2: Abusing Pound Signs (#)


Creating a Form Confirmation Page in ColdFusion
by Tom Muck - 12-Aug-09
Reader Level: Reader Level

A confirmation page is the last page you reach before submitting a form -- you fill in the fields, click submit, review your information, and then submit one final time. Confirmation pages can be built in different ways. I'll show one method using ColdFusion that utilizes hidden form fields to post to your final action page. I'll leave the bells and whistles to the reader (validation, css, etc) and show the meat of the technique that is being used.


Cartweaver Admin Hints and Mods - Part 5: Adding Customer Search Parameters for ColdFusion
by Tom Muck - 29-Jul-09
Reader Level: Reader Level

Cartweaver is an online shopping cart system available from www.cartweaver.com for PHP, ColdFusion, and ASP. It is intended as an easy-to-use solution for building an online store. With a little coding, many new features can be added. This is the fifth part in the series and will show how to modify the Customer search form in the admin for additional search fields in the ColdFusion version. The next part will show the same for PHP.

The Cartweaver Admin Hints and Mods Series:
Cartweaver Admin Hints and Mods - Part 1: Creating a Low Stock Warning for PHP
Cartweaver Admin Hints and Mods - Part 2: Creating a Low Stock Warning for ColdFusion
Cartweaver Admin Hints and Mods - Part 3: Creating an Order Report Graph for ColdFusion
Cartweaver Admin Hints and Mods - Part 4: Creating an Order Report Graph for PHP
Cartweaver Admin Hints and Mods - Part 5: Adding Customer Search Parameters for ColdFusion
Cartweaver Admin Hints and Mods - Part 6 Adding Customer Search Parameters for PHP
Cartweaver Admin Hints and Mods - Part 7: Creating and Order Report for Products Using PHP
Cartweaver Admin Hints and Mods - Part 8: Creating an Order Report for Products Using ColdFusion
Cartweaver Admin Hints and Mods - Part 9: Creating a Taxes Collected Report Using PHP
Cartweaver Admin Hints and Mods - Part 10: Creating a Taxes Collected Report Using ColdFusion


Cartweaver Admin Hints and Mods - Part 3: Creating an Order Report Graph for ColdFusion
by Tom Muck - 29-Jun-09
Reader Level: Reader Level

Cartweaver is an online shopping cart system available from www.cartweaver.com for PHP, ColdFusion, and ASP. It is intended as an easy-to-use solution for building an online store. It doesn't have all the bells and whistles of some of the more pricey carts available, but with a little coding, many new features can be added.

Part 2 showed how to add a low-stock warning to the Cartweaver admin for ColdFusion. This part will show a simple order graphical report. SQL will show how to write the query for SQL Server, the most popular ColdFusion database. Other databases will have similar syntax.

The Cartweaver Admin Hints and Mods Series:
Cartweaver Admin Hints and Mods - Part 1: Creating a Low Stock Warning for PHP
Cartweaver Admin Hints and Mods - Part 2: Creating a Low Stock Warning for ColdFusion
Cartweaver Admin Hints and Mods - Part 3: Creating an Order Report Graph for ColdFusion
Cartweaver Admin Hints and Mods - Part 4: Creating an Order Report Graph for PHP
Cartweaver Admin Hints and Mods - Part 5: Adding Customer Search Parameters for ColdFusion
Cartweaver Admin Hints and Mods - Part 6 Adding Customer Search Parameters for PHP
Cartweaver Admin Hints and Mods - Part 7: Creating and Order Report for Products Using PHP
Cartweaver Admin Hints and Mods - Part 8: Creating an Order Report for Products Using ColdFusion
Cartweaver Admin Hints and Mods - Part 9: Creating a Taxes Collected Report Using PHP
Cartweaver Admin Hints and Mods - Part 10: Creating a Taxes Collected Report Using ColdFusion


Cartweaver Admin Hints and Mods - Part 2: Creating a Low Stock Warning for ColdFusion
by Tom Muck - 17-Jun-09
Reader Level: Reader Level

Cartweaver is an online shopping cart system available from www.cartweaver.com for PHP, ColdFusion, and ASP. It is intended as an easy-to-use solution for building an online store. It doesn't have all the bells and whistles of some of the more pricey carts available, but with a little coding, many new features can be added.

Part 1 showed how to add a low-stock warning to the Cartweaver admin for PHP. Part 2 will show how to add a low-stock warning to the Cartweaver admin for ColdFusion.

The Cartweaver Admin Hints and Mods Series:
Cartweaver Admin Hints and Mods - Part 1: Creating a Low Stock Warning for PHP
Cartweaver Admin Hints and Mods - Part 2: Creating a Low Stock Warning for ColdFusion
Cartweaver Admin Hints and Mods - Part 3: Creating an Order Report Graph for ColdFusion
Cartweaver Admin Hints and Mods - Part 4: Creating an Order Report Graph for PHP
Cartweaver Admin Hints and Mods - Part 5: Adding Customer Search Parameters for ColdFusion
Cartweaver Admin Hints and Mods - Part 6 Adding Customer Search Parameters for PHP
Cartweaver Admin Hints and Mods - Part 7: Creating and Order Report for Products Using PHP
Cartweaver Admin Hints and Mods - Part 8: Creating an Order Report for Products Using ColdFusion
Cartweaver Admin Hints and Mods - Part 9: Creating a Taxes Collected Report Using PHP
Cartweaver Admin Hints and Mods - Part 10: Creating a Taxes Collected Report Using ColdFusion


Cartweaver Admin Hints and Mods Part 1: Creating a Low Stock Warning for PHP Free!
by Tom Muck - 03-Jun-09
Reader Level: Reader Level

Cartweaver is an online shopping cart system available from www.cartweaver.com for PHP, ColdFusion, and ASP. It is intended as an easy-to-use solution for building an online store. It doesn't have all the bells and whistles of some of the more pricey carts available, but with a little coding, many new features can be added.

In Part 1 of this series, we will show how to add a low-stock warning to the Cartweaver admin.

The Cartweaver Admin Hints and Mods Series:
Cartweaver Admin Hints and Mods - Part 1: Creating a Low Stock Warning for PHP
Cartweaver Admin Hints and Mods - Part 2: Creating a Low Stock Warning for ColdFusion
Cartweaver Admin Hints and Mods - Part 3: Creating an Order Report Graph for ColdFusion
Cartweaver Admin Hints and Mods - Part 4: Creating an Order Report Graph for PHP
Cartweaver Admin Hints and Mods - Part 5: Adding Customer Search Parameters for ColdFusion
Cartweaver Admin Hints and Mods - Part 6 Adding Customer Search Parameters for PHP
Cartweaver Admin Hints and Mods - Part 7: Creating and Order Report for Products Using PHP
Cartweaver Admin Hints and Mods - Part 8: Creating an Order Report for Products Using ColdFusion
Cartweaver Admin Hints and Mods - Part 9: Creating a Taxes Collected Report Using PHP
Cartweaver Admin Hints and Mods - Part 10: Creating a Taxes Collected Report Using ColdFusion


Conditional ColdFusion: Using the IIF Function
by Tom Muck - 23-Feb-09
Reader Level: Reader Level

There are many uses for conditional statements in programming. The basic principle of conditional programming is that you want to execute code based on a certain condition. The essence of conditional programming is executing code based on the condition being true, with an alternate piece of code being executed if the condition is not true. The IIF() function in ColdFusion provides a shortcut to using an If/else functionality. This article describes the IIF() function.


Useful 404 Pages in ColdFusion
by Arman Danesh - 27-Jan-09
Reader Level: Reader Level

In ColdFusion it is possible to create 404 error pages that can provide useful information t the user about the source of their error -- such as a bad link from another site, a bad internal link or simply a mis-typed URL. This article shows you how to add this type of intelligence to your 404 error pages in ColdFusion.


ColdFusion Application Logging with Twitter: Part 2
by Arman Danesh - 09-Dec-08
Reader Level: Reader Level

In Part 2 of this two-part series we look at how Twitter can be used to pass messages between two ColdFusion applications -- a poor-man's version of a message queue system.

The ColdFusion Application Logging with Twitter Series:
ColdFusion Application Logging with Twitter: Part 1
ColdFusion Logging with Twitter: Part 2


ColdFusion Application Logging with Twitter: Part 1
by Arman Danesh - 24-Nov-08
Reader Level: Reader Level

Twitter may been seen simply as a way to blog from a mobile phone. But -- in reality it is so much more. The very simplicity of the Twitter platform makes it an elegant way to log and monitor application activity in your ColdFusion applications. This article, the first of a two-part series, shows you how to generate application logs using Twitter which can then be easily monitored by support or development staff.

The ColdFusion Application Logging with Twitter Series:
ColdFusion Application Logging with Twitter: Part 1
ColdFusion Logging with Twitter: Part 2


ColdFusion Contact Form in One Easy File - Part 3
by Michael Evangelista - 20-Nov-08
Reader Level: Reader Level

Michael Evangelista is a freelance web developer, ColdFusion programmer, and owner of a successful web and print design company based in southern Utah. Michael's company, Evangelista Design, has grown from a locally-oriented small business web design company to an international team of designers and ColdFusion developers offering a wide range of online business solutions, including full-service web hosting, custom content management applications, corporate data systems, and more.

In Part 2 of this tutorial, we added several effective spam-prevention methods to our simple contact form, including a simple hidden honeypot field, comparison of submitted values against an easy-to-manage list of banned words and phrases, and a quick check to prevent submission of any html content (containing < and >).

Wired into a single ColdFusion file, we left off with a nifty little spam-blocking, self-submitting, auto-responding, error-handling dynamic gizmo, ready to be battle-tested in the war against spam. You should be able to drop the sample file from Part 2 into any .cfm page, adjust the cfmail settings and other options in the code, and go... it's really that easy!

So... if it works, what's left?

As with any creative or code-related project, there are always aspects that can be cleaned up, simplified and polished. In Part 3, the final part of this series, we'll do some of each:

The ColdFusion Contact Forms in One Easy File Series:
ColdFusion Contact Forms in One Easy File - Part 1
ColdFusion Contact Forms in One Easy File - Part 2
ColdFusion Contact Forms in One Easy File - Part 3




Integrating PayPal Payments Into Your Site with ColdFusion: Part 4
by Arman Danesh - 18-Nov-08
Reader Level: Reader Level

PayPal Website Payments are fairly easy to use once you understand them. This series covers integrating PayPal payments into your ColdFusion Web site. The fourth, and final, article in the series looks at using PayPal's shopping cart as well as dynamically creating encrypted payment buttons in your application.

The Integrating PayPal Payments Into Your Site with ColdFusion Series:
Integrating PayPal Payments Into Your Site with ColdFusion: Part 1
Integrating PayPal Payments Into Your Site with ColdFusion: Part 2
Integrating PayPal Payments Into Your Site with ColdFusion: Part 3
Integrating PayPal Payments Into Your Site with ColdFusion: Part 4


Integrating PayPal Payments into your site with ColdFusion: Part 3
by Arman Danesh - 03-Nov-08
Reader Level: Reader Level

This is the third article in a series about integrating PayPal payments into your ColdFusion Web sites and applications. In the first article we learned about the different PayPal payment services and set up our PayPal account and developer sandbox accounts. The second article introduced the payments workflow, the creation of simple pre-configured buttons and the use of the testing sandbox to test your site or application.

This article is where things get really interesting. So far, everything we've looked at is useful but only to a point. You can create lots of different buttons to sell different products, but everything is static. You can't dynamically build buttons, accumulate products in a PayPal shopping cart or confirm -- and react to -- payments within your site.

This article is where we get into some of this:

The Integrating PayPal Payments Into Your Site with ColdFusion Series:
Integrating PayPal Payments Into Your Site with ColdFusion: Part 1
Integrating PayPal Payments Into Your Site with ColdFusion: Part 2
Integrating PayPal Payments Into Your Site with ColdFusion: Part 3
Integrating PayPal Payments Into Your Site with ColdFusion: Part 4




Integrating PayPal Payments Into Your Site with ColdFusion: Part 2
by Arman Danesh - 27-Oct-08
Reader Level: Reader Level

This is the second article in a series about integrating PayPal payments into your ColdFusion Web sites and applications. In the first article we learned about the different PayPal payment services and set up our PayPal account and developer sandbox accounts.

This article looks at the details of the PayPal payments workflow, provides a simple example of using a PayPal pre-configured payments button and then moves on to explain how to work with the sandbox to experiment with payments in your application.

The Integrating PayPal Payments Into Your Site with ColdFusion Series:
Integrating PayPal Payments Into Your Site with ColdFusion: Part 1
Integrating PayPal Payments Into Your Site with ColdFusion: Part 2
Integrating PayPal Payments Into Your Site with ColdFusion: Part 3
Integrating PayPal Payments Into Your Site with ColdFusion: Part 4


Integrating PayPal Payments Into Your Site with ColdFusion: Part 1 Free!
by Arman Danesh - 21-Oct-08
Reader Level: Reader Level

PayPal Website Payments are fairly easy to use once you understand them. This series covers integrating PayPal payments into your ColdFusion web site. The first article in the series provides an overview of PayPal's offerings and then walks you through some basic tasks needed to get ready to implement your own PayPal solution with ColdFusion.

The Integrating PayPal Payments Into Your Site with ColdFusion Series:
Integrating PayPal Payments Into Your Site with ColdFusion: Part 1
Integrating PayPal Payments Into Your Site with ColdFusion: Part 2
Integrating PayPal Payments Into Your Site with ColdFusion: Part 3
Integrating PayPal Payments Into Your Site with ColdFusion: Part 4


ColdFusion Contact Forms in One Easy File - Part 2
by Michael Evangelista - 21-Oct-08
Reader Level: Reader Level

In Part 1 of this tutorial, we created a simple ColdFusion contact form, and set up some basic checking for a few required values, using validation and a very simple server-side check for an email address.

To process the form contents, we set up two dynamic messages - one to send the email to the site owner, and a custom auto-response 'thank you' message back to the person submitting the form.

Simple, easy, and it works... but we didn't do much to restrict the flow of content, including unwanted junk mail, into our contact form and our customers' inboxes.

In this section of the tutorial (Part 2 of 3), we will add several methods of spam prevention to our simple contact form, including:

...all in one simple file that you can insert into any page!

Michael Evangelista is a freelance web developer, ColdFusion programmer, and owner of a successful web and print design company based in southern Utah. Michael's company, Evangelista Design, has grown from a locally-oriented small business web design company to an international team of designers and ColdFusion developers offering a wide range of online business solutions, including full-service web hosting, custom content management applications, corporate data systems, and more.

The ColdFusion Contact Forms in One Easy File Series:
ColdFusion Contact Forms in One Easy File - Part 1
ColdFusion Contact Forms in One Easy File - Part 2
ColdFusion Contact Forms in One Easy File - Part 3




ColdFusion and Spry: Part 4
by Keith Dodd - 01-Oct-08
Reader Level: Reader Level

SPRY is a JavaScript-based framework that provides AJAX-powered dynamic web content. There are other JavaScript libraries available to accomplish similar results (such a JSON, jQuery, etc.) The SPRY library is produced by Adobe Labs, and, as of this writing, is in 1.6.1 release. (SPRY at Adobe Labs.) Although SPRY can be used with other server technologies, such as PHP, ASP.net, etc., SPRY seems to employ techniques that are especially intuitive to the ColdFusion developer.

In Parts I & II, we constructed a simple Picture Gallery with clickable thumbnails that then revealed full-size pics, some with further detail. The SPRY techniques used XML and its source was a static, hand-coded XML file. In Part III, we used one ColdFusion technique to create our XML source (using the tag). In this final part, we will look at another dynamic method of creating XML, as well as suggest other resources to quickly produce XML from data types, such as queries, arrays, etc. Unless your data rarely changes, creating XML dynamically is a more practical approach than hard coding. These latter techniques are not special for SPRY, but can be used anytime you want ColdFusion to produce XML, whether for something like SPRY, direct output to a web page, or Flash/Flex applications.

The CF techniques demonstrated can be used to output XML directly on the fly or provide XML files saved on the hard drive for direct access. For the latter purpose, ColdFusion might be used to update a certain XML file each time the data changes.

Keith Dodd got into web development as a second career following 30 years in public education, with 19 as a middle school principal. With help from friends and a lot of reading, he got into ColdFusion (version 3) and in 2003 was certificated as an Advanced ColdFusion MX Developer. In recent years, he has worked with Flash and the integration of Flash with ColdFusion (with a lot of help from CMX resources). He is just starting to delve into Flex.

The ColdFusion and Spry Series:
ColdFusion and Spry: Part 1
ColdFusion and Spry: Part 2
ColdFusion and Spry: Part 3
ColdFusion and Spry: Part 4


Preventing SQL Injection Attacks in ColdFusion
by Tom Muck - 22-Sep-08
Reader Level: Reader Level

SQL injection is a technique used by hackers to break into your database. SQL Server has been a target because of the vast number of users who do not use it properly. The sad fact is, web developers are assuming all roles in the development of their web sites, and many of them do not have some simple understandings of how security works in a database. A compromised database can destroy your business, or at the very least, give you a few headaches and wasted time restoring from backups. This article will show a few things that will help your web page against attacks.


ColdFusion Contact Forms in One Easy File - Part 1 Free!
by Michael Evangelista - 17-Sep-08
Reader Level: Reader Level

One of the most common and obvious needs of any professional web developer is the ability to collect information from an HTML form and submit it via email. There are many reasons why this is superior to a simple 'mailto' link, the most important being the ability to hide your actual email address from the ever-more-voracious spambots that plague our online universe (they love to find links like <a href="mailto:me@lotsofspamplease.com"> ... your address becomes a free lunch for the harvester spiders).

In this easy-to-follow tutorial you will learn how to :

...all in one simple <cfinclude> file that you can insert into any page!

This tutorial assumes you have some experience with html form elements, and very basic ColdFusion tags such as <:cfif>, <cfinclude>, <cfparam> and <cfoutput>. A general concept of <cfform> and the 'required' attribute for <cfinput> might also be helpful, but is not required.

Michael Evangelista is a freelance web developer, ColdFusion programmer, and owner of a successful web and print design company based in southern Utah. Michael's company, Evangelista Design, has grown from a locally-oriented small business web design company to an international team of designers and ColdFusion developers offering a wide range of online business solutions, including full-service web hosting, custom content management applications, corporate data systems, and more.

The ColdFusion Contact Forms in One Easy File Series:
ColdFusion Contact Forms in One Easy File - Part 1
ColdFusion Contact Forms in One Easy File - Part 2
ColdFusion Contact Forms in One Easy File - Part 3




ColdFusion and Spry: Part 3
by Keith Dodd - 15-Sep-08
Reader Level: Reader Level

Spry is a JavaScript-based framework that provides AJAX-powered dynamic web content. There are other Javascript libraries available to accomplish similar results (such a JSON, jQuery, etc.). The Spry library is produced by Adobe Labs, and, as of this writing, is in 1.6.1 release. (SPRY at Adobe Labs.) Although SPRY can be used with other server technologies, such as PHP, ASP.net, etc., Spry seems to employ techniques that are especially intuitive to the ColdFusion developer.

The Spry parts of this tutorial series (Parts I & II) just scratched the surface of working with Spry. However, they should have given you the basic concepts in a simplified manner, allowing you to go much deeper on your own. When you download Spry you get not only the necessary library, but many examples, as well as Spry widgets to accomplish many interesting effects. These can be invaluable in learning to use Spry.

In Parts I & II, we constructed a simple Picture Gallery with clickable thumbnails that then revealed full-size pics (and some with further detail). The Spry techniques used XML and its source was a static, hand-coded XML file.

In Parts III & IV, we will use ColdFusion techniques to create our XML source. Unless your data rarely changes, creating XML dynamically is a more practical approach than hard coding. (These latter techniques are not special for Spry, but can be used any time you want ColdFusion to produce XML, whether for something like Spry, direct output to a web page, or Flash/Flex applications.)

Keith Dodd got into web development as a second career following 30 years in public education, with 19 as a middle school principal. With help from friends and a lot of reading, he got into ColdFusion (version 3) and in 2003 was certificated as an Advanced ColdFusion MX Developer. In recent years, he has worked with Flash and the integration of Flash with ColdFusion (with a lot of help from CMX resources). He is just starting to delve into Flex.

The ColdFusion and Spry Series:
ColdFusion and Spry: Part 1
ColdFusion and Spry: Part 2
ColdFusion and Spry: Part 3
ColdFusion and Spry: Part 4


ColdFusion and Spry: Part 2
by Keith Dodd - 05-Sep-08
Reader Level: Reader Level

Spry is a JavaScript-based framework that provides AJAX-powered dynamic web content. There are other JavaScript libraries available to accomplish similar results (such a JSON, jQuery, etc.). The Spry library is produced by Adobe Labs, and, as of this writing, is in 1.6.1 release. (SPRY at Adobe Labs.) Although SPRY can be used with other server technologies, such as PHP, ASP.net, etc., Spry seems to employ techniques that are especially intuitive to the ColdFusion developer.

This series of tutorials just scratches the surface of working with Spry. However, it should give you the basic concepts in a simplified manner, allowing you to go much deeper after you have the basic concepts. A major plus for learning to use Spry is the set of many demos, articles, and samples. When you download Spry you get not only the necessary library, but these many examples, as well as Spry widgets to accomplish many interesting effects.

In Part I, we began construction of a simple Picture Gallery that would include an overview, a strip of thumbnails, and a detail area to display a full picture, along with caption and other possible information. We created two Spry datasets, dsOver and dsPics, and used these to accomplish the plan for the Overview and Thumbnail sections illustrated above.

In Part II, we will turn our attention to the Detail area.

Keith Dodd got into web development as a second career following 30 years in public education, with 19 as a middle school principal. With help from friends and a lot of reading, he got into ColdFusion (version 3) and in 2003 was certificated as an Advanced ColdFusion MX Developer. In recent years, he has worked with Flash and the integration of Flash with ColdFusion (with a lot of help from CMX resources). He is just starting to delve into Flex.

The ColdFusion and Spry Series:
ColdFusion and Spry: Part 1
ColdFusion and Spry: Part 2
ColdFusion and Spry: Part 3
ColdFusion and Spry: Part 4


ColdFusion and Spry: Part 1 Free!
by Keith Dodd - 28-Aug-08
Reader Level: Reader Level

Spry is a JavaScript-based framework that provides AJAX-powered dynamic web content. There are other JavaScript libraries available to accomplish similar results. such a JSON, jQuery, etc. (On this CMX site, Rob Williams has a couple of series on jQuery and jQuery UI Components.)The Spry library is produced by Adobe Labs, and, as of this writing, is in 1.6.1 release. (SPRY at Adobe Labs.) Although SPRY can be used with other server technologies, such as PHP, ASP.net, etc., Spry seems to employ techniques that are especially intuitive to the ColdFusion developer.

Keith Dodd got into web development as a second career following 30 years in public education, with 19 as a middle school principal. With help from friends and a lot of reading, he got into ColdFusion (version 3) and in 2003 was certificated as an Advanced ColdFusion MX Developer. In recent years, he has worked with Flash and the integration of Flash with ColdFusion (with a lot of help from CMX resources). He is just starting to delve into Flex.

The ColdFusion and Spry Series:
ColdFusion and Spry: Part 1
ColdFusion and Spry: Part 2
ColdFusion and Spry: Part 3
ColdFusion and Spry: Part 4


Inserting Excel File Values Into The Database
by Ray West - 08-Aug-08
Reader Level: Reader Level

In earlier articles, we read an Excel file using ColdFusion and validated the values in the fields of the spreadsheet. In this article, we will insert the values into a database table.

The Excel and ColdFusion Series:
Reading Excel Files in ColdFusion
Validating an Imported Excel File
Inserting Excel File Values Into the Database


Quickshot - Missing Images in CFDocument Free!
by Ray West - 30-Jul-08
Reader Level: Reader Level

ColdFusion's tag makes creating dynamic PDF images on the fly a breeze. There have been problems, though, including images in those documents. Many times, for various reasons, you can end up with a perfectly valid image reference in the HTML portion of your document that becomes a red X when the HTML is PDF'd.


Validating an Imported Excel File
by Ray West - 25-Jul-08
Reader Level: Reader Level

In a previous article, we covered using the POI library in ColdFusion to import native Excel files and process their worksheets and columns. This becomes very handy when you need to import data into an application that is provided via Excel. But before you go dumping data into a database and potentially messing something up, it is always wise to validate that the spreadsheet contains the columns and datatypes that you expect.

The Excel and ColdFusion Series:
Reading Excel Files in ColdFusion
Validating an Imported Excel File
Inserting Excel File Values Into the Database


Formatting Dates in CFGrid
by Ray West - 24-Jul-08
Reader Level: Reader Level

You surely know by now that ColdFusion 8 includes built-in Ajax functionality wrapped up in easy to use tags. Part of this functionality comes in an update to the CFGrid tag. In prior versions, CFGrid allowed you to create a sortable and updatable grid in the form of a Java applet or a Flash component. CF8 adds the HTML format to CFGrid which renders an ajaxified HTML grid that is sortable and editable.


ColdFusion 8 and AJAX Series - Part 4: CFWindow
by Chaz Chumley - 17-Jul-08
Reader Level: Reader Level

Continuing on our ColdFusion 8 and AJAX series we will take a look at CFWindow. So what are windows and why would I use them? Unlike pop-up windows you would create with the target attribute or javascript that can be blocked or not function at all depending on the user or there browser settings. CFWindow is a simple DHTML window for displaying information. Follow along as we explore the tag.

The ColdFusion 8 and AJAX Series:
ColdFusion 8 and AJAX Series - Part 1a: Layouts
ColdFusion 8 and AJAX Series - Part 1b: Layouts
ColdFusion 8 and AJAX Series - Part 2: Tabbed Layouts
ColdFusion 8 and AJAX Series - Part 3: Pods
ColdFusion 8 and AJAX Series - Part 4: CFWindow


Setting Up a Scheduled Task in ColdFusion
by Tom Muck - 15-Jul-08
Reader Level: Reader Level

ColdFusion has a mechanism in the ColdFusion admin to set up a scheduled task. These scheduled tasks are ColdFusion pages that you want to run on a schedule -- daily, weekly, hourly, every Monday at 1pm, or on any other schedule of your choosing. The task can be any ColdFusion page. This article will show how to set up a scheduled task through the ColdFusion administrator.


Quick Shot - Validating Imported Dates in ColdFusion Free!
by Ray West - 10-Jul-08
Reader Level: Reader Level

In previous articles, we have discussed the way that Microsoft stores dates in SQL Server and Excel and how that can be an advantage and a hindrance as you deal with your data. There is a method to the way that MS products store dates. It allows you to deal with time against an absolute reference rather than being concerned with its formatting (whether US, Euro, or other). But the way ColdFusion's validation functions treat dates can be tricky if you are trying to get some concrete assurance that you are processing valid information.


Adding a JDBC Driver to ColdFusion
by Tom Muck - 03-Jul-08
Reader Level: Reader Level

ColdFusion ships with JDBC drivers for most of the major databases, however, all JDBC drivers are not created equal. There are good ones and bad ones, and some of the newer drivers will improve performance and stability. In addition, some of the drivers that ship with various versions of ColdFusion have known problems (MySQL comes to mind). Also, there are databases that are not listed in the standard ColdFusion install that you may want to connect to. This article will show the simple process for adding a new driver to the ColdFusion server.


Reading Excel Files in ColdFusion
by Ray West - 26-Jun-08
Reader Level: Reader Level

ColdFusion has built in list functions that make it easy to handle comma separated lists that you can export from Excel. But sometimes you need to read an actual Excel binary file, which allows you to access additional information within the spreadsheet. Luckily ColdFusion has built in functionality that allows you to do that as well.

The Excel and ColdFusion Series:
Reading Excel Files in ColdFusion
Validating an Imported Excel File
Inserting Excel File Values Into the Database


Using CF Tags from CFScript Free!
by Tom Muck - 26-Jun-08
Reader Level: Reader Level

When working in ColdFusion, you have two basic ways of coding: ColdFusion tags and CFScript. Both are legitimate and both provide certain advantages. With ColdFusion tags, you have a full arsenal of functionality available. With CFScript, you have more basic script operations available, such as looping, setting variables, conditions, and other more mundane tasks. Frequently when writing scripts, however, you need some functionality that is only available to a ColdFusion tag. The more obvious solution is to close the tag, execute your tag, then re-open the tag to resume your coding. We'll talk about another way to approach this situation -- create functions that mimic CF tags.


Using Cookies to Log In A User
by Ray West - 18-Jun-08
Reader Level: Reader Level

In a previous article, we looked at setting and deleting cookies in ColdFusion. In this installment, we will use those cookies to remember a user and automatically log them into a site.


Using Multiple Application.cfc Files - Part 2
by Tom Muck - 12-Jun-08
Reader Level: Reader Level

In ColdFusion 7, the Application.cfc file became the application base structure of choice over the Application.cfm file. As you know, the Application.cfm file is the central file in a ColdFusion application that is run before every page in your site. Global functions and variables that are used by the application can be located in this file, or inside files that are included in Application.cfm. Now, with Application.cfc, we can fine-tune the application with application events: onRequestStart, onRequestEnd, onSessionStart, and others. This makes it extremely desirable to use the Application.cfc file over the older Application.cfm file.

Unfortunately, ColdFusion doesn't have the mechanism built into it to run multiple Application.cfc files, as was done with Application.cfm For example, in an administrative section you might have a separate Application.cfm file that includes the main application version of the Application.cfm file but also has additional functionality to protect the administrative directory. Fortunately, there is a way to do the same thing with Application.cfc using inheritance.

Part 1 of this series showed a basic format for extending the Application.cfc in one level of subdirectories. This article, Part 2, will show how to extend even further using cascading Application.cfcs the way that Application.cfm allows cascading, and show one way to convert these old Application.cfm files to Application.cfc

The Using Multiple Application.cfc Files Series:
Using Multiple Application.cfc Files - Part 1
Using Multiple Application.cfc Files - Part 2


Comparing Timestamps in ColdFusion Free!
by Ray West - 05-Jun-08
Reader Level: Reader Level

In a couple of previous articles, we looked at comparing timestamps in SQL Server and MYSQL, with an eye for capturing data that matches a supplied date even if the times are different. Lest we think there is only one way to do things, we got some comments regarding the ability to do this in the server side language (such as ColdFusion) as well.


Setting and Deleting Cookies in ColdFusion Free!
by Ray West - 02-May-08
Reader Level: Reader Level

Cookies are little bits of text information that you can store on your visitor’s computer to keep track of all kinds of things related to your site. Common uses are to track the last time a person was at the site or to store login information, at the user’s request, to allow them to be automatically logged in the next time the visit. In this article we will look at setting and deleting cookies in ColdFusion. In the next article we will use those cookies to automatically login a user when they ask the site to remember them.


Client-Side Interactivity... Without AJAX! Free!
by Doug Boude - 24-Apr-08
Reader Level: Reader Level

Keeping response times down and interactivity high has, and always will be, two important priorities with web interfaces of any kind. For standard HTML interfaces, AJAX is all the buzz and is great when it's necessary to maintain interaction with live data. But when a static version of the data will do just fine, there's at least one other alternative that you may want to consider….

Having spent four years disarming bombs for the Air Force, Doug Boude is now a Senior Web Application Architect for Fiserv Health in San Antonio, TX. He has been developing with ColdFusion since version 4.0. Doug has written several ColdFusion articles for Fusion Authority.


Modifying Classic ColdFusion Debugging: Part 2
by Tom Muck - 22-Apr-08
Reader Level: Reader Level

If you have your own ColdFusion development box, you probably have ColdFusion debugging turned on. I have always used the Classic debugging mode as opposed to Dockable, because I find the popup window takes too long and is too cumbersome to use. However, classic debugging has a few shortfalls. I addressed some with my article on Better Debugging Info for ColdFusion, however that article discussed a completely custom debugging file. Part 1 of this article discussed how to tweak the file used internally by ColdFusion to display debugging results. In that article we expanded arrays and structures for a better debug output. In this article, we'll add some useful query debugging information.

The Modifying Classic ColdFusion Debugging Series:
Modifying Classic ColdFusion Debugging: Part 1
Modifying Classic ColdFusion Debugging: Part 2


The Mystery of CFC Variables and Properties - Part 4
by Tom Muck - 16-Apr-08
Reader Level: Reader Level

If you use ColdFusion you should be using ColdFusion Components (CFCs). One of the more perplexing parts of developing CFCs for the beginning ColdFusion developer is how to define variables and properties. The proper use of variables is important for memory consumption and data integrity. You don't want variables hanging around that aren't needed or accessed from areas that they should not be accessed from.

The first part of this series explained some of the differences between local and global variables as they apply to CFCs. The second part of the series showed a simple CFC framework component. Part 3 showed a CFC that extends our base component. The first three parts are usable in any ColdFusion site with any database. Part 4 will focus on SQL Server and show how the tags can be turned into tags, and how the NULL values of the local properties can be used.

The Mystery of CFC Variables and Properties Series:
The Mystery of CFC Variables and Properties - Part 1
The Mystery of CFC Variables and Properties - Part 2
The Mystery of CFC Variables and Properties - Part 3
The Mystery of CFC Variables and Properties - Part 4


Quickshot - Detecting a Mobile Device in ColdFusion Free!
by Ray West - 09-Apr-08
Reader Level: Reader Level

With the increase of smart phones, PDAs and other handheld devices that can display web content, more and more sites are looking to include Wireless Application Protocol (WAP) and Wireless Markup Language (WML) content on their websites. Even if you do not try to replicate your content, often important pieces of your site can be delivered in a format that is easily readable and usable by the smaller screen of a mobile phone or other device.


The Mystery of CFC Variables and Properties - Part 3
by Tom Muck - 04-Apr-08
Reader Level: Reader Level

If you use ColdFusion you should be using ColdFusion Components (CFCs). One of the more perplexing parts of developing CFCs for the beginning ColdFusion developer is how to define variables and properties. The proper use of variables is important for memory consumption and data integrity. You don't want variables hanging around that aren't needed, or accessed from areas that they should not be accessed from.

The first part of this series explained some of the differences between local and global variables as they apply to CFCs. This second part of the series showed a simple CFC framework component. Part 3 shows a CFC that extends our base component. These first three parts are usable in any ColdFusion site wtih any database. Part 4 will focus on SQL Server.

The Mystery of CFC Variables and Properties Series:
The Mystery of CFC Variables and Properties - Part 1
The Mystery of CFC Variables and Properties - Part 2
The Mystery of CFC Variables and Properties - Part 3
The Mystery of CFC Variables and Properties - Part 4


The Mystery of CFC Variables and Properties - Part 2
by Tom Muck - 24-Mar-08
Reader Level: Reader Level

If you use ColdFusion you should be using ColdFusion Components (CFCs). One of the more perplexing parts of developing CFCs for the beginning ColdFusion developer is how to define variables and properties. The proper use of variables is important for memory consumption and data integrity. You don't want variables hanging around that aren't needed or accessed from areas that they should not be accessed from.

The first part of this series explained some of the differences between local and global variables as they apply to CFCs. This second part of the series will continue the discusion and show a simple CFC framework component. Part 3 will show a CFC that extends our base component.

The Mystery of CFC Variables and Properties Series:
The Mystery of CFC Variables and Properties - Part 1
The Mystery of CFC Variables and Properties - Part 2
The Mystery of CFC Variables and Properties - Part 3
The Mystery of CFC Variables and Properties - Part 4


Quick Shot - Securing Your ColdFusion Session Information
by Ray West - 20-Mar-08
Reader Level: Reader Level

As we have discussed in other articles, ColdFusion compensates for the stateless nature of web applications by using session variables to track information across the entire time of a user's visit to your site. This allows you to store a user's ID after sign on, for instance, and use it to retrieve information about them from a database or to keep track of information that the user enters while completing a multi page form.

In this article, we are going to go over two simple steps that should lessen the risk of anyone inadvertently providing access to their personal information on your site.


The Mystery of CFC Variables and Properties - Part 1 Free!
by Tom Muck - 20-Mar-08
Reader Level: Reader Level

If you use ColdFusion you should be using ColdFusion Components (CFCs). One of the more perplexing parts of developing CFCs for the beginning ColdFusion developer is how to define variables and properties. This article will attempt to explain some of the differences between local and global variables as they apply to CFCs. The proper use of variables is important for memory consumption and data integrity. You don't want variables hanging around that aren't needed, or accessed from areas that they should not be accessed from.

The second part of the series will continue the discusion and show a simple CFC framework.

The Mystery of CFC Variables and Properties Series:
The Mystery of CFC Variables and Properties - Part 1
The Mystery of CFC Variables and Properties - Part 2
The Mystery of CFC Variables and Properties - Part 3
The Mystery of CFC Variables and Properties - Part 4


ColdFusion and Exchange Server - Part 3: Updating and Deleting Calendar Events
by Ray West - 14-Mar-08
Reader Level: Reader Level

Once you have learned to create an appointment in Exchange Server, deleting it is a relatively simple operation. The key to deleting a calendar event is knowing the unique ID that Exchange assigned when you created the event. If you stored the ID returned by the Exchange connection in your database, you just need to retrieve it and use it to send a delete command to the server.

The ColdFusion and Exchange Server Series:
ColdFusion and Exchange Server - Part 1
ColdFusion and Exchange Server - Part 2: Creating Calendar Events
ColdFusion and Exchange Server - Part 3: Updating and Deleting Calendar Events


ColdFusion and Exchange Server - Part 2: Creating Calendar Events
by Ray West - 12-Mar-08
Reader Level: Reader Level

In a previous article, we covered making a connection to Exchange Server from ColdFusion 8 and retrieving some email information. In this installment, we will use a form to collect information about an appointment, send it to Exchange as a calendar item and stick it in a database for use within an application. Later we will retrieve appointment information, edit it and delete it.

The ColdFusion and Exchange Server Series:
ColdFusion and Exchange Server - Part 1
ColdFusion and Exchange Server - Part 2: Creating Calendar Events
ColdFusion and Exchange Server - Part 3: Updating and Deleting Calendar Events


Convert a Querystring into a Struct Using ColdFusion
by Tom Muck - 10-Mar-08
Reader Level: Reader Level

ColdFusion makes it easy to work with structures like URL variables, form variables, and other types of structures. Why would you want to convert a query string into a struct when the URL struct already contains the URL variable in struct form? Frequently you are presented with a URL string as opposed to a struct containing the URL or form variables. This is where ColdFusion's built-in list functions come to the rescue. With the list function and a loop, it's easy to convert a string into a structure containing members, and even convert the string back into a URL or form struct.


Saving Structures to Client Variables with ColdFusion Free!
by Bill Betournay - 07-Mar-08
Reader Level: Reader Level

I've always liked using Client variables in ColdFusion. In fact, I probably use them more then I should. The fact that I can set a client variable and not have to worry about passing it around my application in order to use its value is, well, lazily handy for me. However, serious programming involves Queries, Arrays and Structures. Client variables are not typically used to store these types of objects. This article talks about, and shows you how to, set Queries, Arrays and Structures to a Client variable.

Bill Betournay has been specializing in web development and database design since 1999. He is currently employed at Algoma Steel (A Subsidiary of Essar Global) in Northern Ontario as a programmer analyst and at Jordan Media Ltd., a Marketing and Application Development firm in the UK. For the past several years Bill has maintained a high profile within the Cartweaver (Coldfusion) community as a developer providing additional custom functionality via his web site DataPacks.com. Bill is often spotted lurking in the Cartweaver CF newsgroup.


Quickshot - Make Sure They Belong on Your Site Free!
by Ray West - 04-Mar-08
Reader Level: Reader Level

URL Tampering is one of the most common ways that people will try to mess with your site. They may try to change a URL String parameter to try and see or change or delete a record that they should not be able to access (which is something you should be trapping for anyway) or they may try to post a form into your site from an external server, allowing them to set whatever they want for hidden form fields.

In this Quickshot tutorial I will show you a quick and simple way to prevent people from accessing content on your site that they shouldn't see.


Ending a Session When the Browser Closes
by Ray West - 27-Feb-08
Reader Level: Reader Level

Most applications on the web are written as stateless applications, meaning that each page request is basically unaware of anything else that is happening around it. That means that you need to manage the information your pages need to interoperate with each other, like the current account number or what is in a shopping cart. You can do that using the URL string, or cookies or something called session variables.


Creating Custom Toolbars for the ColdFusion 8 Rich Text Editor
by Ray West - 22-Feb-08
Reader Level: Reader Level

Among the great new Ajax features of ColdFusion 8 is a rich text editor that you can easily add to your site, making the collection and display of text much more flexible and attractive. Based on the FCKEditor, the ColdFusion editor is quite full featured for a lightweight object and it allows the formatting of text collected in a form including many HTML features like tables and hyperlinks as well as fonts, styles, emoticons, special characters, text alignment and other things to allow more that just raw text entry into your application.


Quickshot: How to Parse Submitted Form Fields in ColdFusion Free!
by Ray West - 15-Feb-08
Reader Level: Reader Level

Most of the time, when your site submits a form to the server, you constructed that form so you know what fields to expect on the back side. On occasion, though, you may not know exactly what fields to expect when a form is dynamically created or may only contain data for certain fields. In ColdFusion, you can use a couple of methods to determine what fields exist in a form that has been received and what the data is for those fields.


Using Multiple Application.cfc Files - Part 1
by Tom Muck - 08-Feb-08
Reader Level: Reader Level

In ColdFusion 7, the Application.cfc file became the application base structure of choice over the Application.cfm file. As you know, the Application.cfm file is the central file in a ColdFusion application that is run before every page in your site. Global functions and variables that are used by the application can be located in this file, or inside files that are included in Application.cfm. Now, with Application.cfc, we can fine-tune the application with application events: onRequestStart, onRequestEnd, onSessionStart, and others. This makes it extremely desirable to use the Application.cfc file over the older Application.cfm file.

Unfortunately, ColdFusion doesn't have the mechanism built into it to run multiple Application.cfc files, as was done with Application.cfm For example, in an administrative section you might have a separate Application.cfm file that includes the main application version of the Application.cfm file but also has additional functionality to protect the administrative directory. Fortunately, there is a way to do the same thing with Application.cfc using inheritance.

The Using Multiple Application.cfc Files Series:
Using Multiple Application.cfc Files - Part 1
Using Multiple Application.cfc Files - Part 2


Making Stored Procedures Efficient Free!
by Ray West - 08-Feb-08
Reader Level: Reader Level

As a web application gets larger and needs to handle more traffic, special attention is needed to make sure it is running as efficiently as possible. More often than not, that means taking a look at the way that your data is marshaled from the database. I am constantly amazed at how much effort can be placed in making sure that pages are only so heavy and take X seconds to load on the HTML side, when very little consideration is given to how the database is being accessed.

The two things to remember when dealing with the optimization of your database are minimizing network traffic, and the reuse of execution plans. Both of these are accomplished by the proper use of stored procedures. In this article, we will cover a few tips to help you get the most out of your stored procedures.


Quick Shot - Using ColdFusion List Functions to Manipulate Text Free!
by Ray West - 07-Feb-08
Reader Level: Reader Level

ColdFusion's List functions are some of the most useful things in the language. They allow you to do all kinds of neat things with strings of text that can be divided by some character, like a comma delimited string or flat file layout.


Quickshot: Logging Out an Inactive User Free!
by Ray West - 06-Feb-08
Reader Level: Reader Level

As worried as people seem to be about their online information being compromised, they don't usually seem to take even the simplest precautions to keep wandering eyes off of their monitors and the information they display. If your application contains sensitive information, you may need to help your users protect it.


Building a CRM/Invoicing System
by Ray West - 01-Feb-08
Reader Level: Reader Level

Customer Relationship Management has become quite the buzzword lately, and for good reason. No business can succeed without customers, and it has become increasingly necessary for companies to keep a close eye on how they are servicing their existing customers and how they can obtain new ones. Services like Salesforce.com specialize in managing contact with leads, prospects and clients throughout their lifecycle. But they also come at a hefty price.

Many smaller companies could get by with a simpler CRM system, and there are some available in the open source market that might suffice. But there is nothing much available in ColdFusion, so I want to cover over a few articles the basics of creating a CRM and invoicing module that you can use standalone, or add to your existing application. In this first article, we will begin to look at a database structure.


ColdFusion and Exchange Server - Part 1
by Ray West - 22-Jan-08
Reader Level: Reader Level

I have used Thunderbird forever, it seems. We tried Microsoft Exchange Server and Outlook several years ago, But we could never get it to configure quite right with our firewall, and it was a pain to manage, and Outlook and Outlook Express were unreliable, to say the least. I was pretty happy with a simpler mail server and Thunderbird, until two things happened at just about the same time.

My company was expanding, and with that came a larger sales team. There had been requests for Outlook before, but the sales force presented the best argument for needing the features of Exchange server (which most people never realize is a requirement to get all of the fancier features of Outlook). They needed shared calendars and the ability to management meeting invitations, plus better access from multiple locations. Sure there are other products that will allow this, but it seemed like a good time to try Exchange again.

The ColdFusion and Exchange Server Series:
ColdFusion and Exchange Server - Part 1
ColdFusion and Exchange Server - Part 2: Creating Calendar Events
ColdFusion and Exchange Server - Part 3: Updating and Deleting Calendar Events


Using CFQUERY with Directories
by Tom Muck - 16-Jan-08
Reader Level: Reader Level

The CFQUERY tag is a versitile tag that is not only for database queries. You can run a CFQUERY query of queries on any valid query result. Results from CFFTP, CFPOP, and CFDIRECTORY, among other tags, are returned as query results. This makes it very easy to do filtering and searching on query results from these different tags. This article will show one use of of the query of queries on a local server directory.


Modifying Classic ColdFusion Debugging: Part 1
by Tom Muck - 09-Jan-08
Reader Level: Reader Level

If you have your own ColdFusion development box, you probably have ColdFusion debugging turned on. I have always used the Classic debugging mode because I find the popup window debugging mode takes too long and is too cumbersome to use. However, classic debugging has a few shortfalls. I addressed some with my article on Better Debugging for ColdFusion, however that article discussed a completely custom debugging file. The method discussed in this article will show you how to tweak the file used internally by ColdFusion to display debugging results.

The Modifying Classic ColdFusion Debugging Series:
Modifying Classic ColdFusion Debugging: Part 1
Modifying Classic ColdFusion Debugging: Part 2


Simple Server-Side Form Validation
by Adrian Senior - 02-Jan-08
Reader Level: Reader Level

Setting up a simple custom server-side form validation is a straightforward process and has the advantage over JavaScript in that it cannot be turned off by the user in order to override your validation.

In this tutorial, we will look at how we can use a combination of ColdFusion, JavaScript and CSS to provide an interactive form validating process. Although we do use a little JavaScript in this process it does not have a bearing on the validation process and is used only to enhance the messaging that is passed to the user.


SQL Group vs. CFOUTPUT GROUP
by Tom Muck - 17-Dec-07
Reader Level: Reader Level

There is a lot of confusion among some ColdFusion developers about the use of GROUP in a SQL statement and the use of the group attribute in a tag. This article will try to explain the differences and where you would use one or the other.


Creating a Redirected Login in ColdFusion
by Rob Williams - 20-Nov-07
Reader Level: Reader Level

Creating a transparent login system is one of the easiest things a developer can do to enhance an end user's experience on an access controlled site. In this article we're going to take the concepts that were introduced previously in the PHP version of Creating a redirected login and apply them to ColdFusion.


Blocking Bad Words in ColdFusion
by Tom Muck - 05-Nov-07
Reader Level: Reader Level

One of the biggest problems on the Internet these days is spam in the form of comment spam and contact form spam. Blogs are big these days, and many have implemented spam trapping features, however spammers are not all automated robots -- some of the most insidious are real people sitting behind their computer attacking you with their Viagra ads and other assorted garbage. Guestbooks attract spammers like flies. And even contact forms, meant only to go to the site owner, are under attack as well.

This article will show a simple administrative interface to maintain a "bad word" list, and a simple way to prevent the spam from reaching the intended recipient.


ColdFusion 8 and AJAX Series - Part 3: Pods
by Chaz Chumley - 31-Oct-07
Reader Level: Reader Level

Continuing on our ColdFusion 8 and AJAX series we will take a look at Pods. So what are Pods and why would I use them? Similar to layout areas within a tag, Pods provide us a standalone area of the browser window where we can display static and dynamic content. Follow along as we explore the tag.

The ColdFusion 8 and AJAX Series:
ColdFusion 8 and AJAX Series - Part 1a: Layouts
ColdFusion 8 and AJAX Series - Part 1b: Layouts
ColdFusion 8 and AJAX Series - Part 2: Tabbed Layouts
ColdFusion 8 and AJAX Series - Part 3: Pods
ColdFusion 8 and AJAX Series - Part 4: CFWindow


ColdFusion 8 and AJAX Series - Part 2: Tabbed Layouts
by Chaz Chumley - 17-Oct-07
Reader Level: Reader Level

Tabbed layouts seem to be a common occurrence around the web these days. Your choices for designing and developing tabbed layouts vary from CSS to Javascript to Ajax. Adobe first threw its hat into the tabular layout ring with the introduction of the Spry framework. Well they are back at it again, this time with ColdFusion 8 and the new tag.

The ColdFusion 8 and AJAX Series:
ColdFusion 8 and AJAX Series - Part 1a: Layouts
ColdFusion 8 and AJAX Series - Part 1b: Layouts
ColdFusion 8 and AJAX Series - Part 2: Tabbed Layouts
ColdFusion 8 and AJAX Series - Part 3: Pods
ColdFusion 8 and AJAX Series - Part 4: CFWindow


Tracking Most Recently Read Content
by Tom Muck - 09-Oct-07
Reader Level: Reader Level

Community MX has a feature that shows the most recent items you viewed. This is quite easy to do, but requires a few things to be in place. This article will show how we do this. The article will use ColdFusion, but the technique can be applied across the board to any server language, like PHP or ASP.NET. We'll assume for this article that you have a user login system and content management system already in place. We'll focus on the functionality to store the content id of the user reading the content.


Using Text Masks in ColdFusion
by Tom Muck - 05-Oct-07
Reader Level: Reader Level

Text masks can be used in web applications as placeholders for dynamic content. A mask is essentially a string of characters that can be later replaced, and not likely to be confused. Usually, you will use consecutive characters around a variable string, or simply consecutive characters. This article will show a few techniques using masks in ColdFusion.


ColdFusion 8 and AJAX Series - Part 1b: Layouts
by Chaz Chumley - 03-Oct-07
Reader Level: Reader Level

AJAX being all the buzz, Adobe introduced ColdFusion 8 with integration for a bunch of new rich interface features that make your introduction to AJAX a whole lot easier. Of these new features we began to take a look at the cflayout tag. Whether you're wanting to create a one, two or three-column layout or simply create an intranet portal, you will want to take a look at the cflayout tag.

We will continue our series by looking at a couple more attributes of the cflayout tag including the "source" attribute which allows you to populate a region from an external file, "closable" which allows the user to close a region of your layout, how to reference the ColdFusion JavaScript API to allow a user to re-open a region that was closed and some gotchas to look out for when using the cflayout tag.

The ColdFusion 8 and AJAX Series:
ColdFusion 8 and AJAX Series - Part 1a: Layouts
ColdFusion 8 and AJAX Series - Part 1b: Layouts
ColdFusion 8 and AJAX Series - Part 2: Tabbed Layouts
ColdFusion 8 and AJAX Series - Part 3: Pods
ColdFusion 8 and AJAX Series - Part 4: CFWindow


Creating a Master/Detail Pageset on One Page Using AJAX
by Tom Muck - 19-Sep-07
Reader Level: Reader Level

Dreamweaver's Master/Detail page set is a handy set of behaviors to use for a drill-down functionality -- display a list of records, and click on a link in the list to view the full record. Using the behaviors, however, you typically create two pages. If you create one page with both, the page will refresh each time you click on a link.

In this tutorial, I'll show how to create one master/detail page that uses some very simple JavaScript to load the details section of the page dynamically using AJAX. This tutorial will apply to PHP, ColdFusion, and ASP, with the concepts applicable to the other available server models that Dreamweaver now supports.


ColdFusion 8 and Ajax Series - Part 1a: Layouts
by Chaz Chumley - 18-Sep-07
Reader Level: Reader Level

When Adobe released ColdFusion 8 they introduced some new tags and functions related to Ajax development. Imagine being able to create Ajaxified web applications with little or no knowledge of how to build it from scratch. In this series we will be looking at all the wonderful Ajax functionality that you can start adding to your next web page with just a few tags.

Let's start off with some of the UI (user interface) Controls. especially that of layouts and layout areas using the new cflayout and cflayoutarea tags.

The ColdFusion 8 and AJAX Series:
ColdFusion 8 and AJAX Series - Part 1a: Layouts
ColdFusion 8 and AJAX Series - Part 1b: Layouts
ColdFusion 8 and AJAX Series - Part 2: Tabbed Layouts
ColdFusion 8 and AJAX Series - Part 3: Pods
ColdFusion 8 and AJAX Series - Part 4: CFWindow


CFPresentation - Adding Audio & Video
by Chaz Chumley - 14-Sep-07
Reader Level: Reader Level

Adobe ColdFusion 8 provides us with a laundry list of new tags, including the new tags that allow us to create dynamic presentations using existing HTML or CFM templates. Previously we took a look at creating our first presentation utilizing some of the basic features. This time we will look at how to spruce up our presentations by adding audio and video and some of the gotchas to look out for.

Download size: 1.8MB


Creating a Simple Database Web Search - Part 2: ColdFusion
by Tom Muck - 07-Sep-07
Reader Level: Reader Level

In the first part of this series, I showed how to create a Master/Detail page set using built in Dreamweaver tools, and then add a basic search form querying against one field in the database. What if you want more than that though? The Dreamweaver recordset dialog box allows one filter against one field. This is sometimes useful, but usually not. Typically you might also want to allow other HTML fields into the search. You will want to search allowing multiple search words. Finally, you might want to search multiple database fields. I will address all three situations in this article, which will be targeted to ColdFusion users only.

The Creating A Simple Database Web Search Series:
Creating a Simple Database Web Search - Part 1
Creating a Simple Database Web Search - Part 2: PHP
Creating a Simple Database Web Search - Part 2: ColdFusion


Installing ColdFusion 8 on Mac OS X
by Thomas Pletcher - 06-Sep-07
Reader Level: Reader Level

ColdFusion 8, the latest and greatest, is the first version to be released under Adobe's auspices, and that makes a difference -- installing CF on OS X is easier than ever.

Approximate download size: 952k


CFPresentation
by Chaz Chumley - 23-Aug-07
Reader Level: Reader Level

Creating slide presentations is a common task we have all found ourselves having to do at one time or another. However, the application you have used has probably either been Micorosft's Powerpoint or Apple's Keynote. With the introduction of ColdFusion 8 and the new tag, ColdFusion lets you create dynamic slide presentations from existing source files such as HTML or CFM templates or a mashup of the two. In fact you can even create a slide from an external web page just by specifying the absolute url. Regardless of how you decide to create your slides, the process is simple and we will walk you through creating your first presentation.


Database-Oriented Document Management
by Doug Boude - 21-Aug-07
Reader Level: Reader Level

Nearly every time the question of storing documents or images in a database comes up, the answer is almost always "don't do it", and for very good reasons. There are those times, however, when it's very much the appropriate thing to do. A clustered server environment can be one such scenario, where deployment of documents and/or images needs to be immediate and not subject to the cluster resynchronization schedule. In order to make an image or document immediately available, we need to utilize a central repository that can be updated in real time: the database.

This article was written by guest author Doug Boude. Having spent four years disarming bombs for the Air Force, Doug Boude is now a Senior Web Application Architect for Fiserv Health in San Antonio, TX. He has been developing with ColdFusion since version 4.0. Doug has written several ColdFusion articles for Fusion Authority.


ColdFusion and WMI Free!
by Brice Mason - 17-Aug-07
Reader Level: Reader Level

Microsoft calls their implementation of the Web-Based Enterprise Management (WBEM) industry initiative Windows Management Instrumentation (WMI). We call it the richest source of information containing everything you'd want to know about your Windows systems.

This article introduces the idea of connecting to WMI using ColdFusion, providing the developer endless opportunity to produce administrative and reporting applications guaranteed to take you out of the world of maintenance and in to the world of innovation.

Brice Mason is a husband and father from Albany, New York. He is also an independent software developer and freelance writer who regularly lets his curiousity get the best of him. As a developer working for diverse industry sectors such as healthcare, technology, and non-profit, Brice has consistently turned to ColdFusion to quickly solve his greatest challenges. He values the incredible flexibility it offers to produce highly creative and innovative solutions. Brice maintains a personal web site at http://www.skipslate.com.




Installing ColdFusion 8 Report Builder Free!
by Chaz Chumley - 09-Aug-07
Reader Level: Reader Level

With the release of ColdFusion 8 comes a new version of the ColdFusion Report Builder which was introduced back with version 7. There have been some great enhancements to the free reporting tool by Adobe. In future articles we will look at some examples, but for now lets take a look at how easy it is to install on Microsoft Windows Vista.


Installing ColdFusion 8 on Vista with Apache Free!
by Chaz Chumley - 30-Jul-07
Reader Level: Reader Level

ColdFusion 8 is the latest and greatest version of ColdFusion and as soon as it hit the Adobe Labs I hurried out to download it and install it. I noticed that there are a few new items that get installed with ColdFusion 8, like .NET integration and LiveCycle Data Services Express edition. So those familiar with installing ColdFusion 7, there are some new settings.

If you have had the pleasure, or pain, of running Windows Vista then you may know that simply installing applications is not really that simple. I will be taking you through installing ColdFusion 8 on Vista with Apache 2 as my web server.


Creating a Table-less Horizontal Looper in ColdFusion
by Tom Muck - 19-Jun-07
Reader Level: Reader Level

Dreamweaver has a Repeat Region server behavior that loops through your data and allows you to display it in a vertical or horizontal manner. If you want to display the data in a grid pattern, however, it requires a little more effort. Typically, a Horizontal Looper extension or code is used to create a table and put your individual data sections in a table cell. In this tutorial I'll show how to do that using <div> tags and CSS without tables.

This is a version of an article I did for PHP—but for ColdFusion instead. For this tutorial I'll assume you know how to use your database tools to create and manage databases, and how to create connections for ColdFusion.


Dynamic Navigation Page Marking
by Adrian Senior - 31-May-07
Reader Level: Reader Level

In this article we look at how we can deploy page marking in a dynamic navigation menu by using values returned from a query and matching them to a url variable in order to change the state of a tab with CSS.


FusionDebug 2.0 - Variables
by Chaz Chumley - 17-Apr-07
Reader Level: Reader Level

This is the final article in our series on FusionDebug 2.0, an interactive ColdFusion debugger. While we have looked at configuration, setting breakpoints within a template and stepping thru a CFC to examine the results of a query within the Variables panel, we have not looked at one of the most important functions of FusionDebug.

Variable Introspection is very powerful in that we don't have to use <cfdump> to see what various scoped variables contain. As well as with FusionDebug 2.0 we can also change the values contained within those variables which makes it a great way to test a ColdFusion application and change values during run-time to see how certain sections of code will work.

In this article we will look at a couple of examples on changing a variables value during run-time.

The FusionDebug Series
FusionDebug 2.0 - Configurations
FusionDebug 2.0 - Setting Breakpoints
FusionDebug 2.0 - Stepping Through a CFC
FusionDebug 2.0 - Variables


FusionDebug 2.0 - Stepping Through a CFC
by Chaz Chumley - 04-Apr-07
Reader Level: Reader Level

In our last article we took a look at setting breakpoints within ColdFusion templates using FusionDebug 2.0 an interactive debugger for ColdFusion. While we paused code execution on a single page to view the variables contained within the page, I would bet that we have all built more complex applications that involve the use of ColdFusion Components (CFCs). FusionDebug 2.0 is a great tool in that we can set a breakpoint on any page, including CFCs, UDFs (User Defined Functions) and even custom tags. Knowing this we will take a look at what happens when we set a breakpoint on a query contained with a CFC and how we can view the contents of the query prior to actually outputting the results to browser.

The FusionDebug Series
FusionDebug 2.0 - Configurations
FusionDebug 2.0 - Setting Breakpoints
FusionDebug 2.0 - Stepping Through a CFC
FusionDebug 2.0 - Variables


Using the Bell Character—Parsing Lists in ColdFusion
by Tom Muck - 27-Mar-07
Reader Level: Reader Level

What is the bell character, you might ask? In the old days of computing, before there was surround sound, you could "print" a character to the screen that made a "beep" sound. If you put a bell character (ASCII 7) in a string, it would beep to the screen. These days, the bell character is not used for much...if anything. As a ColdFusion programmer, you can make use of this not-often-used character for different situations. Some lists seem like they are unparseable using regular ColdFusion functions, and some strings might not even seem like lists. This article will show a couple ways to parse otherwise difficult lists.


FusionDebug 2.0 - Setting Breakpoints
by Chaz Chumley - 19-Mar-07
Reader Level: Reader Level

In this article we will take a look at how to set a breakpoint within FusionDebug 2.0, an interactive ColdFusion debugger by Fusion-Reactor. Breakpoints allow us to stop code execution at a predetermined location within our ColdFusion template, CFC (ColdFusion Component) or custom tag. This is a big plus over having to use to output variables to our page, in that we don't have to allow code execution to complete or unnecessarily abort our template. Once we have our code paused, so to speak, we can inspect all variables of various scope at that particular moment and then let our code finish processing.

The FusionDebug Series
FusionDebug 2.0 - Configurations
FusionDebug 2.0 - Setting Breakpoints
FusionDebug 2.0 - Stepping Through a CFC
FusionDebug 2.0 - Variables


Anti-Spam Measures for PHP and ColdFusion - Part 2
by Tom Muck - 14-Mar-07
Reader Level: Reader Level

Spam, spam, spam, spam. Spammers have taken over the Internet and made it a horrible place to maintain a web site. Spammers have gone beyond simply spamming your email account -- now they are spamming blogs and guestbooks, spamming trackbacks, and spamming signup forms. Even a child's home page with a guestbook for friends is not safe from links for cialis, porn, or web hosting. Obviously these spammers are getting some return from their criminal activity, because they keep doing it. Unfortunately, you can't reach through the computer screen and grab them by the throat to strangle the life out of them. All you can do is put in place some safeguards and try to minimize the attack. Part 2 in this series shows how you can record the IP address of the spammer and block access to your site to that computer in the future. Once again, I'll assume you have familiarity with PHP or ColdFusion basics (databases, inserting and displaying data) and HTML forms.

The Anti-Spam Measures for PHP and ColdFusion Series:
Anti-Spam Measures for PHP and ColdFusion - Part 1
Anti-Spam Measures for PHP and ColdFusion - Part 2


Getting ColdFusion MX 7.0.2 Running on Vista and IIS7 Free!
by Heidi Bautista - 05-Mar-07
Reader Level: Reader Level

This article takes you step-by-step through the process of installing ColdFusion MX 7.0.2 on a PC running the new Vista operating system and using Internet Information Services (IIS) 7.

There are points during the installation process that can and will give you trouble if you follow directions published prior to Vista's release. Therefore, special emphasis has been given to the information you'll need to get working with ColdFusion on Vista.

Who will benefit by reading this article?

ColdFusion programmers who develop and/or run CFM pages locally (including developing CFCs) on a Vista box and who use IIS7.


FusionDebug 2.0 - Configurations Free!
by Chaz Chumley - 02-Mar-07
Reader Level: Reader Level

Since our last look at installing and configuring FusionDebug, Fusion-Reactor has come out with version 2.0. So your asking "what's new in this version and why should I upgrade?" Well, how about a new standalone installer that gives you Eclipse 3.2, CFEclipse 1.3 and FusionDebug 2.0, all in one fail swoop. They have also included a Server Configuration Wizard that easily modifies the JVM.config (Java Virtual Machine) settings that we looked at in the previous article. Besides a performance improvement of about 10 times faster than before, the most noticable improvement is it's own debug perspective.

So before we go off learning how to set breakpoints and view and modify variables in our code let's take a look at how to quickly set up the new FusionDebug perspective. This is similar to setting up the Eclipse Debug environment that we looked at in our previous article with a lot less choices.

The FusionDebug Series
FusionDebug 2.0 - Configurations
FusionDebug 2.0 - Setting Breakpoints
FusionDebug 2.0 - Stepping Through a CFC
FusionDebug 2.0 - Variables


Anti-Spam Measures for PHP and ColdFusion - Part 1
by Tom Muck - 01-Mar-07
Reader Level: Reader Level

Spam, spam, spam, spam. Spammers have taken over the Internet and made it a horrible place to maintain a web site. Spammers have gone beyond simply spamming your email account -- now they are spamming blogs and guestbooks, spamming trackbacks, and spamming signup forms. Even a child's home page with a guestbook for friends is not safe from links for cialis, porn, or web hosting. Obviously these spammers are getting some return from their criminal activity, because they keep doing it. Unfortunately, you can't reach through the computer screen and grab them by the throat to strangle the life out of them. All you can do is put in place some safeguards and try to minimize the attack.

The Anti-Spam Measures for PHP and ColdFusion Series:
Anti-Spam Measures for PHP and ColdFusion - Part 1
Anti-Spam Measures for PHP and ColdFusion - Part 2


FusionDebug 1.0 - Configurations Free!
by Chaz Chumley - 12-Feb-07
Reader Level: Reader Level

If you have been doing ColdFusion development for awhile you have no doubt wished you had an easier way to debug your code instead of using the usual to spit out variables, structs, queries, etc. to a web page. Wouldn't it be nice to set a breakpoint on a line of code and then step thru the web page as it was being rendered? Well now you have just that option. FusionDebug is an interactive ColdFusion MX debugger that plugs into the Eclipse IDE which lets you do just that.

In this series of tutorials we will be looking at how you install the product and create a FusionDebug configuration, set breakpoints in your code that allow for stepping over and into templates, tags and components, change variable values, and watch expressions in the debugger, all in real time.


ColdFusion Report Builder - Part 3c: Input Parameters
by Chaz Chumley - 05-Feb-07
Reader Level: Reader Level

This is the last article in our three part series on using input parameters with ColdFusion Report Builder. If you have been following along we have created a simple report that took an input parameter to change the title of the report and to modify or filter the data being retrieved from our query. Finally we will be discussing showing or hiding a region of a report based on an input parameter.

The ColdFusion Report Builder Series:
ColdFusion Report Builder - Part 1: Exploring the IDE
ColdFusion Report Builder - Part 2: Building a Simple Report
ColdFusion Report Builder - Part 3a: Input Parameters
ColdFusion Report Builder - Part 3b: Input Parameters
ColdFusion Report Builder - Part 3c: Input Parameters


Shut Off Your Site -- ColdFusion Maintenance
by Tom Muck - 31-Jan-07
Reader Level: Reader Level

There is frequently a need for page maintenance or database maintenance, without turning off a server. If you are at a remote location, wouldn't it be nice to be able to shut down access to your pages without having to call someone or pull up a remote desktop? With a couple simple variables and the Application.cfc file (or Application.cfm), you can create the functionality to shut off access to your site and return a simple message to any user that happens across your site while the maintenance is underway.


ColdFusion Report Builder - Part 3b: Input Parameters
by Chaz Chumley - 23-Jan-07
Reader Level: Reader Level

If you have been following the series on ColdFusion Report Builder, we have previewed the IDE, built a simple report and utilized input parameters to dynamically change a report label at runtime. However input parameters are even more powerful and as promised from the last article, we will explore using input parameters inside a query to filter the data being returned.

The ColdFusion Report Builder Series:
ColdFusion Report Builder - Part 1: Exploring the IDE
ColdFusion Report Builder - Part 2: Building a Simple Report
ColdFusion Report Builder - Part 3a: Input Parameters
ColdFusion Report Builder - Part 3b: Input Parameters
ColdFusion Report Builder - Part 3c: Input Parameters


Implementing a Record Locking System in ColdFusion 7 - Part 2
by Tom Muck - 17-Jan-07
Reader Level: Reader Level

Most databases have some sort of row-level locking of database records, however when building a web application you need more than that. Picture a scenario where a database will have multiple users and each user could potentially be working on the same record. This can happen in an e-commerce site, where different departments have access to a given order for fulfillment, or in an Intranet site where various employees have access to a given record.

In this article I will show you how to implement a record locking system that relies on the Application.cfc file that was introduced in CF 7. This second part builds upon the files set up in part 1 and creates the record locking system.

The Implementing a Record Locking System in ColdFusion 7 Series:
Implementing a Record Locking System in ColdFusion 7 - Part 1
Implementing a Record Locking System in ColdFusion 7 - Part 2


ColdFusion Report Builder - Part 3a: Input Parameters
by Chaz Chumley - 10-Jan-07
Reader Level: Reader Level

In our last article we took a look at building a simple report using the ColdFusion Report Builder. In most cases you may only need a simple report but when it comes to customizing the report fields on the fly we need to consider using input parameters. We will be addressing input parameters in three parts. Our first article will look at adding an input parameter to our existing report's title and then passing that report title from a form. The Second article will look at using input parameters inside a query to filter the data being returned. The third will be using input parameters for conditional formatting, such as hiding or showing parts of a report.

The ColdFusion Report Builder Series:
ColdFusion Report Builder - Part 1: Exploring the IDE
ColdFusion Report Builder - Part 2: Building a Simple Report
ColdFusion Report Builder - Part 3a: Input Parameters
ColdFusion Report Builder - Part 3b: Input Parameters
ColdFusion Report Builder - Part 3c: Input Parameters


Implementing a Record Locking System in ColdFusion 7
by Tom Muck - 04-Jan-07
Reader Level: Reader Level

Most databases have some sort of row-level locking of database records, however when building a web application you need more than that. Picture a scenario where a database will have multiple users and each user could potentially be working on the same record. This can happen in an e-commerce site, where different departments have access to a given order for fulfillment, or in an Intranet site where various employees have access to a given record.

In this article I will show you how to implement a record locking system that relies on the Application.cfc file that was introduced in CF 7. Because of the extended setup to get to the locking portion, we'll run this tutorial in two parts. In this first part, we will set up the Application.cfc with a simple login system, and build the results, login, and update pages.


ColdFusion Report Builder - Part 2: Building a Simple Report
by Chaz Chumley - 22-Dec-06
Reader Level: Reader Level

In our last article we took a look at the ColdFusion Report Builder interface which hopefully got you familiar with the different sections of the editor. This time around we will look at using the ColdFusion Report Builder Setup Wizard to assist us with setting up the environment by configuring the RDS server and specifying the location of our web site that the reports will be built for, defining the query fields for our report, grouping, layout, style and theme.

The ColdFusion Report Builder Series:
ColdFusion Report Builder - Part 1: Exploring the IDE
ColdFusion Report Builder - Part 2: Building a Simple Report
ColdFusion Report Builder - Part 3a: Input Parameters
ColdFusion Report Builder - Part 3b: Input Parameters
ColdFusion Report Builder - Part 3c: Input Parameters


Using a CF Custom Tag for Multiple Tabs
by Tom Muck - 21-Dec-06
Reader Level: Reader Level

Tabs in a web page are an intuitive way for a user to navigate elements on a page. Using tabs, you can create pages of an article, multi-tab forms, multi-tab pages of links, or other types of pages where there is too much content to fit on one page. Using two ColdFusion custom tags -- one for the tab functionality and one for each individual tab -- you can create a simple way to add tabs to a ColdFusion page. The tab code shown in the article is simple, but can be used to expand on, or you can simply use the techniques shown with your own tab code.


Switching CSS with ColdFusion
by Chaz Chumley - 12-Dec-06
Reader Level: Reader Level

If you are concerned about giving your end user the ultimate control over changing the way your web site looks and feels—well not ultimate control, but the ability to change the CSS document attached to your site, then look no further. We will be taking a look at Gordon Mackay's tutorial "Switching CSS Based on Time of Day with PHP" and converting it to ColdFusion as well as a little added bonus of allowing the user to select from a link which CSS best suits them.


Favourite Extensions - Part 2: Massimo's CF Insert Bar Plus Free!
by Adrian Senior - 07-Dec-06
Reader Level: Reader Level

In this, the second look at extensions that can enhance your production time, we are going to look at Massimo Foti's CF Insert Bar Plus.

The extension enhances functionality that already exists within Dreamweaver by reducing cftry, cfoutput and cfdump to a single click.

The Favourite Extensions Series:
Favourite Extensions - Part 1: Tom Muck's Sniplets
Favourite Extensions - Part 2: Massimo's CF Insert Bar Plus
Favourite Extensions - Part 3: The TFM Progress Bar


Announcing My CF Photo Gallery Free!
by Sheri German - 21-Nov-06
Reader Level: Reader Level

It is the holiday season, and you will problaby be taking a lot of pictures. Need a way to easily manage and display your photo galleries online? Read all about the new CMX application: My CF Photo Gallery. With the CF Photo Gallery and a ColdFusion server, you or a client can upload and manage image galleries right from a browser window.


My CF Photo Gallery
by Adrian Senior - 21-Nov-06
Reader Level: Reader Level

My CF Photo Gallery is a ColdFusion image gallery application. It provides a logical step by step interface within a secure administration area enabling you to create new galleries and edit the content of existing galleries.


A Simple Multi-language ColdFusion Content Management System - Part 3
by Tom Muck - 10-Nov-06
Reader Level: Reader Level

There are various ways to create a data-driven multi-language site, but the method I have shown in this article series uses an underused technique involving ColdFusion custom tags. Basically, the technique will turn any simple, well-formed HTML or XHTML page into a content management system with only one tag required on the page.

The first part of this series showed the principles behind the custom tag technique. The second part implemented the database tables and custom ColdFusion functionality to turn HTML tags into database-driven dynamic tags. This third part will create a simple administrative interface to administer the system.

The Multi-Language ColdFusion Content Management System Series:
A Simple Multi-language ColdFusion Content Management System - Part 1
A Simple Multi-language ColdFusion Content Management System - Part 2
A Simple Multi-Language ColdFusion Content Management System - Part 3


Easy Nav for ColdFusion
by Ray West - 01-Nov-06
Reader Level: Reader Level

In this tutorial I will show you how to develop a navigation handler in ColdFusion that will do the following:




ColdFusion Report Builder - Part 1: Exploring the IDE Free!
by Chaz Chumley - 31-Oct-06
Reader Level: Reader Level

With the introduction of ColdFusion MX 7, Adobe gave developers the ability to create simple to advanced reports using a new tool called ColdFusion Report Builder. While you can still utilize tags such as to generate PDF and FlashPaper reports from existing XHTML content, there are times when your client needs something a little more.

In this series of articles we will be walking you through the interface, simple report layouts, and even advanced topics such as sub reports, parameterization and tips and tricks that every ColdFusion Report writer needs to know.

If you are not familiar with ColdFusion Report Builder then you are in the right place. A quick overview of the product, it is a tool for allowing the user to create banded reports similar to Microsoft Access reports but for ColdFusion. These reports contain definitions with built-in SQL queries, grouping and placement and custom functions and styling that result in a very professional looking report. These ColdFusion Reports are saved with .CFR extension and are then displayed by using the tag.

In Part 1 we will introduce the ColdFusion Report Builder interface to get you familiar where things are laid out.

The ColdFusion Report Builder Series:
ColdFusion Report Builder - Part 1: Exploring the IDE
ColdFusion Report Builder - Part 2: Building a Simple Report
ColdFusion Report Builder - Part 3a: Input Parameters
ColdFusion Report Builder - Part 3b: Input Parameters
ColdFusion Report Builder - Part 3c: Input Parameters


Let's Learn ColdFusion: Building a Simple Admin - Part 3
by Adrian Senior - 25-Oct-06
Reader Level: Reader Level

In this tutorial we will build on the administration area that we created earlier in the series, you will begin to build the functionality required for page creation and the construction of a central control area.

The Let's Learn ColdFusion: Building a Simple Admin Series:
Let's Learn ColdFusion: Building a Simple Admin - Part 1
Let's Learn ColdFusion: Building a Simple Admin - Part 2
Let's Learn ColdFusion: Building a Simple Admin - Part 3
Let's Learn ColdFusion: Building a Simple Admin - Part 4 Coming Soon


A Simple Multi-language ColdFusion Content Management System - Part 2
by Tom Muck - 24-Oct-06
Reader Level: Reader Level

There are various ways to create a data-driven multi-language site, but the method I will show in this article series uses an underused technique involving ColdFusion custom tags.

Basically, the technique shown will turn any simple, well-formed HTML or XHTML page into a content management system with only one tag required on the page. This first part of this series showed the principles behind the custom tag technique.

This part will implement the database tables and custom ColdFusion functionality to turn HTML tags into database-driven dynamic tags to implement the multi-language aspect.

The Multi-Language ColdFusion Content Management System Series:
A Simple Multi-language ColdFusion Content Management System - Part 1
A Simple Multi-language ColdFusion Content Management System - Part 2
A Simple Multi-Language ColdFusion Content Management System - Part 3


ColdFusion Code-Behind: Mimicking .NET's Page Directive
by Chaz Chumley - 19-Oct-06
Reader Level: Reader Level

Microsoft's ASP.NET has given the development community a nice object oriented programming model with its introduction of Code-Behind files. Simply spoken, these are C# or VB.NET files that contain the physical code for wiring up events or actions such as Page Load, button clicks, etc. that the ASP.NET template calls from the very first line of code called a Page Directive.

The power of separating the presentational layout from the actual framework allows developers and designers to work separately from one another. This is very useful in large development teams. Taking a page from this concept we can achieve the same flexibility in ColdFusion by using CFCs and invoking them from the ColdFusion template on every page request.

Join me as I take you through an explanation of how this concept works and hopefully bridge the gap between any Microsoft .NET developers wanting to learn ColdFusion in creating a ColdFusion Code-Behind.


A Simple Multi-language ColdFusion Content Management System - Part 1 Free!
by Tom Muck - 11-Oct-06
Reader Level: Reader Level

There are various ways to create a data-driven multi-language site, but the method I will show in this article series uses an underused technique involving ColdFusion custom tags. Basically, the technique shown will turn any simple, well-formed HTML or XHTML page into a content management system with only one tag required on the page.

This first part will show the principles behind the custom tag technique. The next part will show how to implement the multi-language aspect. The third part will create an administrative interface to administer the system.

The Multi-Language ColdFusion Content Management System Series:
A Simple Multi-language ColdFusion Content Management System - Part 1
A Simple Multi-language ColdFusion Content Management System - Part 2
A Simple Multi-Language ColdFusion Content Management System - Part 3


Combine Gets and Posts into the Request Scope
by Chaz Chumley - 06-Oct-06
Reader Level: Reader Level

Have you ever worked on a large ColdFusion application and had to review previous templates to see whether or not the variables you were trying to process or validate were coming from a FORM submission or from a Query string? We'll don't feel alone, this is a common challenge when developing larger applications. Fortunately we can take advantage of the onRequestStart method within the Application.cfc to eliminate the need to check templates as we explore using the REQUEST scope to process all variables from now on by combining Gets and Posts into the Request scope..


CFDirectory How To: Inserting Results into Database for Future Searches
by Chaz Chumley - 25-Sep-06
Reader Level: Reader Level

Using CFDirectory allows us to return directory contents, but what if you have a larger directory that doesn't change much or takes a long time to return results? Why not take the results and insert them into a database for optimized searching for a later time.


Creating Daily Stats Pages
by Tom Muck - 18-Sep-06
Reader Level: Reader Level

A stat page can be used for an e-store, blog, ad rotater, or any other type of application where you want to track a specific series of "things" that happen each day. For example, on a blog you might track blog hits. In an e-store, you might track daily sales. For an ad rotator you might track click-throughs.

This article will show how to write a query to group the daily activity in the first section, and how to display that as a graph using ColdFusion in the second section. The article will use SQL Server syntax, but could be adapted to any database. Also, the SQL code is applicable to any server model—not only ColdFusion. This is part 1 of 2.


Let's Learn ColdFusion: Building a Simple Admin - Part 2
by Adrian Senior - 15-Sep-06
Reader Level: Reader Level

In Part 1 of this series we looked at how to lay out the basic appearance of our administration area and set up some simple but effective security to allow our clients to easily access what will become our administration area's control panel.

To hold the information our clients create we will need to make use of a database. That is where we will begin Part 2. The database will be simple, though it will provide all the functionality we need in our first venture into developing a dynamic website.

The Let's Learn ColdFusion: Building a Simple Admin Series:
Let's Learn ColdFusion: Building a Simple Admin - Part 1
Let's Learn ColdFusion: Building a Simple Admin - Part 2
Let's Learn ColdFusion: Building a Simple Admin - Part 3
Let's Learn ColdFusion: Building a Simple Admin - Part 4 Coming Soon


CFEclipse How To: Creating Your First CFC
by Chaz Chumley - 01-Sep-06
Reader Level: Reader Level

We explored the CFEclipse interface earlier in our previous How To article on creating a simple ColdFusion page. This time around, we will expand on that project and convert our ColdFusion page to utilize a CFC (ColdFusion Component). This will open up some new CFEclipse panels and wizards for us to take a look at, all of which are very helpful in speeding up our development time. Particularly the CF Component Wizard, Methods View panel, Tasks or TODO Panel and the ability to add Snippets.

The CFEclipse How To Series
CFEclipse How To: Creating a Simple CFML Page
CFEclipse How To: Creating your first CFC


Let's Learn ColdFusion: Building a Simple Admin - Part 1 Free!
by Adrian Senior - 31-Aug-06
Reader Level: Reader Level

In this series you will build a simple administration area complete with a control panel that will allow you to manage the content of your website.

The system you will build is aimed at the small business website where one or two users will have total control of the website's content.

The Let's Learn ColdFusion: Building a Simple Admin Series:
Let's Learn ColdFusion: Building a Simple Admin - Part 1
Let's Learn ColdFusion: Building a Simple Admin - Part 2
Let's Learn ColdFusion: Building a Simple Admin - Part 3
Let's Learn ColdFusion: Building a Simple Admin - Part 4 Coming Soon


Fundamental Fusebox: Part 2 - A Fusebox 5 Follow-up
by Thomas Pletcher - 30-Aug-06
Reader Level: Reader Level

This follow-up to my introductory article on Fusebox 5 shows how to adapt a Fusebox 4 application to the Fusebox 5 architecture, and explores Fusebox 5's model-view-controller design pattern in more detail. See how easy it is to use the most popular ColdFusion web application framework!

The Fundamental Fusebox Series:
Fundamental fusebox: Part 1 - An Overview
Fundamental Fusebox: Part 2 - A Fusebox 5 Follow-up


Using the <cfsavecontent> Tag
by Tom Muck - 29-Aug-06
Reader Level: Reader Level

There are many ways to build a string in ColdFusion, but one often overlooked method involves using the <cfsavecontent> tag. This article will take a look at the standard ways that a ColdFusion developer might build a string, and compare it to using <cfsavecontent>.


CFEclipse How To: Creating a Simple CFML Page Free!
by Chaz Chumley - 22-Aug-06
Reader Level: Reader Level

This past year at Todcon, I happened to start a discussion with some of the Adobe team about the future of Dreamweaver and how it relates to ColdFusion development. To my surprise, there has been quite a bit of interest surrounding the open source Eclipse IDE and the ColdFusion plugin known as CFEclipse. Not to say that there are plans to discontinue ColdFusion support in future versions of Dreamweaver, but for the experienced developer there is a growing effort to put some research dollars into the CFEclipse product.

CFEclipse is easy to use and has some great features. We'll examine some of them in this first article in the How To series on CFEclipse.

The CFEclipse How To Series
CFEclipse How To: Creating a Simple CFML Page
CFEclipse How To: Creating your first CFC


Fundamental Fusebox: Part 1 - An Overview
by Thomas Pletcher - 18-Aug-06
Reader Level: Reader Level

Fusebox has long been the leading ColdFusion web application framework, noted for its use of the model-view-controller (MVC) architecture. Now Fusebox 5 has been released, and this introductory article provides an overview, including a review of changes from the previous version. The article also takes a look at the new "skeleton" application provided for Fusebox 5.

The Fundamental Fusebox Series:
Fundamental fusebox: Part 1 - An Overview
Fundamental Fusebox: Part 2 - A Fusebox 5 Follow-up


Creating Simple Printed Reports in ColdFusion: Part 5
by Ray West - 17-Aug-06
Reader Level: Reader Level

In this installment of the series, we will look at ways that you can incorporate dynamic elements into your documents. While there is certainly a wide range of things that might fall into the category of "dynamic elements", for this article I mean one of two things:

Member's Sign In

Remember Me

Retrieve Password

Current Articles
and Tutorials

3354

Most Recent JumpStarts

Newsletter

View the archive

CMX Suite

New every Tuesday!CMX Weekly Cartoon
View the archive

RSS Feed

Syndicate CMX

Our feeds