ColdFusion
Cartweaver Admin Hints and Mods - Part 10: Creating a Taxes Collected Report Using ColdFusion
by Tom Muck - 21-Oct-09
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:
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:
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:
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
by Ray West - 11-Sep-09
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:
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:
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:
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:
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
by Tom Muck - 03-Jun-09
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:
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:
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:
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:
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:
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:
- Streamline our error handling and error message display
- Simplify installation and customization options with easy-to-configure scoped variables
- Add custom client-side validation using the jQuery JavaScript library
...all in one simple bundle of files that you can insert into any page!
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:
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:
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:
- Building dynamic buttons
- Processing payment success information 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 2
by Arman Danesh - 27-Oct-08
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
by Arman Danesh - 21-Oct-08
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
...all in one simple 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:
by Michael Evangelista - 21-Oct-08
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
To process the form contents, we set up two dynamic
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:
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:
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
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:
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
by Michael Evangelista - 17-Sep-08
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 :
- Submit a simple html form with any fields you like via email from any ColdFusion page
- Double-validate submitted info with <cfform> and server-side checking
- Create an automatic custom-formatted mail message
- Send the user a custom-formatted auto-responder 'thanks' message
- Hide your email address from spambots
- Send email so that replying goes to the sender, not back to the web site
...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:
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:
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
by Keith Dodd - 28-Aug-08
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:
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
by Ray West - 30-Jul-08
Reader Level:
ColdFusion's
Validating an Imported Excel File
by Ray West - 25-Jul-08
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:
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:
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
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
Quick Shot - Validating Imported Dates in ColdFusion
by Ray West - 10-Jul-08
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.
Reading Excel Files in ColdFusion
by Ray West - 26-Jun-08
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
by Tom Muck - 26-Jun-08
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
Using Cookies to Log In A User
by Ray West - 18-Jun-08
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:
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
by Ray West - 05-Jun-08
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
by Ray West - 02-May-08
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!
by Doug Boude - 24-Apr-08
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.
Quickshot - Detecting a Mobile Device in ColdFusion
by Ray West - 09-Apr-08
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.
Quick Shot - Securing Your ColdFusion Session Information
by Ray West - 20-Mar-08
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.
ColdFusion and Exchange Server - Part 3: Updating and Deleting Calendar Events
by Ray West - 14-Mar-08
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:
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:
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
by Bill Betournay - 07-Mar-08
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
by Ray West - 04-Mar-08
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:
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:
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.
Using Multiple Application.cfc Files - Part 1
by Tom Muck - 08-Feb-08
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
Quick Shot - Using ColdFusion List Functions to Manipulate Text
by Ray West - 07-Feb-08
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
by Ray West - 06-Feb-08
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:
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:
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:
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.
Simple Server-Side Form Validation
by Adrian Senior - 02-Jan-08
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.
ColdFusion 8 and AJAX Series - Part 3: Pods
by Chaz Chumley - 31-Oct-07
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
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:
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
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 1b: Layouts
by Chaz Chumley - 03-Oct-07
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:
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:
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
Creating a Simple Database Web Search - Part 2: ColdFusion
by Tom Muck - 07-Sep-07
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:
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:
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
Database-Oriented Document Management
by Doug Boude - 21-Aug-07
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
by Brice Mason - 17-Aug-07
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
by Chaz Chumley - 09-Aug-07
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
by Chaz Chumley - 30-Jul-07
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:
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:
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.
Anti-Spam Measures for PHP and ColdFusion - Part 2
by Tom Muck - 14-Mar-07
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
by Heidi Bautista - 05-Mar-07
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
by Chaz Chumley - 02-Mar-07
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:
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
by Chaz Chumley - 12-Feb-07
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
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:
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
Implementing a Record Locking System in ColdFusion 7
by Tom Muck - 04-Jan-07
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.
Switching CSS with ColdFusion
by Chaz Chumley - 12-Dec-06
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.
Easy Nav for ColdFusion
by Ray West - 01-Nov-06
Reader Level:
In this tutorial I will show you how to develop a navigation handler in ColdFusion that will do the following:
- The navigation would be made up of a CSS styled unordered list, <ul>
- Each list item, <li>, within the <ul> would be a link to a page within the site
- Each <li> would contain an anchor (a) with an href to the target page.
- Whichever page the visitor was on at the moment should not show up as a link in the nav, rather it should just show <strong> so as to indicate the current location and avoid self-referencing links
- It should be self updating as the navigation changes so that no manual changes are necessary to the code to 'code-around' the links on each target page
Let's Learn ColdFusion: Building a Simple Admin - Part 3
by Adrian Senior - 25-Oct-06
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:
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
A Simple Multi-language ColdFusion Content Management System - Part 1
by Tom Muck - 11-Oct-06
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
CFDirectory How To: Inserting Results into Database for Future Searches
by Chaz Chumley - 25-Sep-06
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.
Let's Learn ColdFusion: Building a Simple Admin - Part 2
by Adrian Senior - 15-Sep-06
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:
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
by Adrian Senior - 31-Aug-06
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
CFEclipse How To: Creating a Simple CFML Page
by Chaz Chumley - 22-Aug-06
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
Creating Simple Printed Reports in ColdFusion: Part 5
by Ray West - 17-Aug-06
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:
- The insertion of dynamic text (such as names and addresses) into the text of your document.
- The inclusion or exclusion of entire sections of a document based on your user’s input.
- Creating a Simple Blog: Part 1 22-Mar-04
- Creating a Simple Blog: Part 2 30-Mar-04
- Creating a Simple Blog: Part 3 14-Apr-04
- Creating a Simple Blog: Part 4 25-May-04
- Creating a Simple Blog: Part 5 26-Apr-05
The Creating Simple Printed Reports in ColdFusion Series:
Creating Simple Printed Reports in ColdFusion: Part 1
Creating Simple Printed Reports in ColdFusion: Part 2
Creating Simple Printed Reports in ColdFusion: Part 3
Creating Simple Printed Reports in ColdFusion: Part 4
Creating Simple Printed Reports in ColdFusion: Part 5
Creating Simple Printed Reports in ColdFusion: Part 4
by Ray West - 04-Aug-06
Reader Level:
In Part 2 of this series, we looked at the filename attribute of the cfdocument tag and discussed how it will allow you to save a generated document rather than streaming it directly to the browser. It this installment, we will look at how you can take advantage of that functionality to save and email a document to your user.
The Creating Simple Printed Reports in ColdFusion Series:
Creating Simple Printed Reports in ColdFusion: Part 1
Creating Simple Printed Reports in ColdFusion: Part 2
Creating Simple Printed Reports in ColdFusion: Part 3
Creating Simple Printed Reports in ColdFusion: Part 4
Creating Simple Printed Reports in ColdFusion: Part 5 Coming Soon
Let's Learn ColdFusion: Part 5 - Working with cfincludes
by Adrian Senior - 28-Jul-06
Reader Level:
In this lesson we will look at code reuse within your web site design. Specifically you will learn about the cfinclude tag and how you can put this tag to good use with what you have learned in the previous lessons. To work through this lesson we will be using the North Pole JumpStart.
The Let's Learn ColdFusion Series:
Let's Learn ColdFusion: Part 1 - Installation and the Testing Server
Let's Learn ColdFusion: Part 2 - The URL Scope, Variable Names and Values
Let's Learn ColdFusion: Part 3 - Adding Simple Logic and Error Checking
Let's Learn ColdFusion: Part 4a - Creating a Datasource
Let's Learn ColdFusion: Part 4b - Building a Dynamic List Menu
Let's Learn ColdFusion: Part 4c - Filtering Your Queries and the cfqueryparam Tag
Let's Learn ColdFusion: Part 4d - Error Checking Your ColdFusion Queries
Let's Learn ColdFusion: Part 5 - Working with cfincludes
Creating Simple Printed Reports in ColdFusion: Part 3
by Ray West - 27-Jul-06
Reader Level:
In this installment of this series, we are going to look at some of the additional ColdFusion tags that can be used within the
The Creating Simple Printed Reports in ColdFusion Series:
Creating Simple Printed Reports in ColdFusion: Part 1
Creating Simple Printed Reports in ColdFusion: Part 2
Creating Simple Printed Reports in ColdFusion: Part 3
Creating Simple Printed Reports in ColdFusion: Part 4
Creating Simple Printed Reports in ColdFusion: Part 5 Coming Soon
Using the cfstoredproc Tag
by Chaz Chumley - 26-Jul-06
Reader Level:
If you have been using ColdFusion for a while you have undoubtedly needed to interact with a database in one way or another. Whether it is Microsoft Access, MySql or Microsoft SQL Server, a client has asked you to develop an application to create, retrieve, update or delete data. Until now you have probably been using the cfquery tag to accomplish this.
Let’s kick it up a notch and discuss the advantages of using stored procedures and in general how to utilize the cfstoredproc tag in this edition of our HOW TO series.
Let's Learn ColdFusion: Part 4d - Error Checking Your ColdFusion Queries
by Adrian Senior - 21-Jul-06
Reader Level:
In this the final lesson in Part 4 you will learn how to negate errors that may occur when you are running queries. You will learn about the cftry, cfcatch and cfcatch variables that can indicate the problem to aid in debugging.
The Let's Learn ColdFusion Series:
Let's Learn ColdFusion: Part 1 - Installation and the Testing Server
Let's Learn ColdFusion: Part 2 - The URL Scope, Variable Names and Values
Let's Learn ColdFusion: Part 3 - Adding Simple Logic and Error Checking
Let's Learn ColdFusion: Part 4a - Creating a Datasource
Let's Learn ColdFusion: Part 4b - Building a Dynamic List Menu
Let's Learn ColdFusion: Part 4c - Filtering Your Queries and the cfqueryparam Tag
Let's Learn ColdFusion: Part 4d - Error Checking Your ColdFusion Queries
Sending an Email Blast with ColdFusion: Part 3
by Tom Muck - 20-Jul-06
Reader Level:
ColdFusion makes it very easy to send emails to mulitple recipients from a database using very little code. Part 1 of this series went over some basics, and Part 2 showed a very basic newsletter delivery system, similar to the system we use at Community MX to send our weekly newsletters.
Part 3 will show two different scenarios to include line items within the email body—generic line items and recipient-specific line items.
Let's Learn ColdFusion: Part 4c - Filtering Your Queries and the cfqueryparam Tag
by Adrian Senior - 19-Jul-06
Reader Level:
In this tutorial you will learned how to filter a database table by using the WHERE clause. We will also look at using the cfqueryparam tag and its attributes to speed up execution times and provide enhanced security for your database. You will also look at preventing errors in your ColdFusion pages by making good use of the cfparam tag.
The Let's Learn ColdFusion Series:
Let's Learn ColdFusion: Part 1 - Installation and the Testing Server
Let's Learn ColdFusion: Part 2 - The URL Scope, Variable Names and Values
Let's Learn ColdFusion: Part 3 - Adding Simple Logic and Error Checking
Let's Learn ColdFusion: Part 4a - Creating a Datasource
Let's Learn ColdFusion: Part 4b - Building a Dynamic List Menu
Let's Learn ColdFusion: Part 4c - Filtering Your Queries and the cfqueryparam Tag
Let's Learn ColdFusion: Part 4d - Error Checking Your ColdFusion Queries Coming Soon
Creating Simple Printed Reports in ColdFusion: Part 2
by Ray West - 18-Jul-06
Reader Level:
For those of us building what are known as Web Applications (web sites that are intended to provide advanced application functionality that often replace desktop programs) there have always been a number of limitation in the web server and browser platform that affect the user experience compared to traditional applications. Modern platforms like Flash (and even DHTML) are answering some of those issues on the client side. On the server side, one of the problems has been generating true banded reporting and creating printable reports from what is displayed on screen.
In the last article,
we looked at the most basic use of the cfdocument tag
to create PDF and FlashPaper documents out of rendered HTML. Without rehashing
the product documentation, let’s look at some of the other attributes
of the cfdocument tag that affect how your document is presented.
The Creating Simple Printed Reports in ColdFusion Series:
Creating Simple Printed Reports in ColdFusion: Part 1
Creating Simple Printed Reports in ColdFusion: Part 2
Creating Simple Printed Reports in ColdFusion: Part 3
Creating Simple Printed Reports in ColdFusion: Part 4
Creating Simple Printed Reports in ColdFusion: Part 5 Coming Soon
Let's Learn ColdFusion: Part 4b - Building a Dynamic List Menu
by Adrian Senior - 12-Jul-06
Reader Level:
In Part 4 you created a dsn - Data Source Name - and we discussed how a dsn allowed you to connect to a database. The second key in this process is passing information to the database in order to get the information you want back from the database.
It is this concept that we will learn in this lesson and to complete the lesson you will build a dynamic list menu as a proof of concept.
The Let's Learn ColdFusion Series:
Let's Learn ColdFusion: Part 1 - Installation and the Testing Server
Let's Learn ColdFusion: Part 2 - The URL Scope, Variable Names and Values
Let's Learn ColdFusion: Part 3 - Adding Simple Logic and Error Checking
Let's Learn ColdFusion: Part 4a - Creating a Datasource
Let's Learn ColdFusion: Part 4b - Building a Dynamic List Menu
Let's Learn ColdFusion: Part 4c - Filtering Your Queries and the cfqueryparam Tag
Let's Learn ColdFusion: Part 4d - Error Checking Your ColdFusion Queries Coming Soon
ColdFusion Mapping
by Chaz Chumley - 07-Jul-06
Reader Level:
If you've been developing for awhile you may have created some code that you've wanted to reuse and, if you're like me, you've created a folder for CFCs (ColdFusion Components), UDFs (user defined functions) or even a generalized site header and footer. This is great and easily accessible using a cfinclude, cfmodule or invoking a component using cfinvoke or cfobject, until you need to move your folders outside of your web root for whatever reason. This is when everything breaks. Until now...
The ColdFusion "How To" Series:
ColdFusion Mapping
cfstoredproc Tag Coming Soon
Let's Learn ColdFusion: Part 4a - Creating a Datasource
by Adrian Senior - 05-Jul-06
Reader Level:
The whole concept of server-side coding is aimed at automation, this is everything from generating the URL variables value to providing content for your web pages.
The Let's Learn ColdFusion Series:
Let's Learn ColdFusion: Part 1 - Installation and the Testing Server
Let's Learn ColdFusion: Part 2 - The URL Scope, Variable Names and Values
Let's Learn ColdFusion: Part 3 - Adding Simple Logic and Error Checking
Let's Learn ColdFusion: Part 4a - Creating a Datasource
Let's Learn ColdFusion: Part 4b - Building a Dynamic List Menu
Let's Learn ColdFusion: Part 4c - Filtering Your Queries and the cfqueryparam Tag
Let's Learn ColdFusion: Part 4d - Error Checking Your ColdFusion Queries Coming Soon
Let's Learn ColdFusion: Part 3 - Adding Simple Logic and Error Checking
by Adrian Senior - 29-Jun-06
Reader Level:
In Part 3 you will learn how to apply simple logic to your pages and look at preventing errors from missing variables.
The Let's Learn ColdFusion Series:
Let's Learn ColdFusion: Part 1 - Installation and the Testing Server
Let's Learn ColdFusion: Part 2 - The URL Scope, Variable Names and Values
Let's Learn ColdFusion: Part 3 - Adding Simple Logic and Error Checking
Let's Learn ColdFusion: Part 4a - Creating a Datasource
Let's Learn ColdFusion: Part 4b - Building a Dynamic List Menu
Let's Learn ColdFusion: Part 4c - Filtering Your Queries and the cfqueryparam Tag
Let's Learn ColdFusion: Part 4d - Error Checking Your ColdFusion Queries Coming Soon
Creating Simple Printed Reports in ColdFusion - Part 1
by Ray West - 27-Jun-06
Reader Level:
For those of us building what are known as Web Applications (web sites that are intended to provide advanced application functionality that often replace desktop programs) there have always been a number of limitation in the web server and browser platform that affect the user experience compared to traditional applications. Modern platforms like Flash (and even DHTML) are answering some of those issues on the client side. On the server side, one of the problems has been generating true banded reporting and creating printable reports from what is displayed on screen.
Sure, there was always Crystal Reports or some third-party program that could help out. But they were always problematic, in my experience. I wanted something built into my language that allowed those very important features to be executed natively. ColdFusion now allows exactly that with a number of new capabilities to provide instant PDF and FlashPaper documents and intricate banded business reporting. In this article, we will look at creating simple printed reports from generated HTML using the cfdocument tag.
The Creating Simple Printed Reports in ColdFusion Series:
Creating Simple Printed Reports in ColdFusion: Part 1
Creating Simple Printed Reports in ColdFusion: Part 2
Creating Simple Printed Reports in ColdFusion: Part 3
Creating Simple Printed Reports in ColdFusion: Part 4
Creating Simple Printed Reports in ColdFusion: Part 5 Coming Soon
Let's Learn ColdFusion: Part 2 - The URL Scope, Variable Names and Values
by Adrian Senior - 26-Jun-06
Reader Level:
Start to learn and understand the ColdFusion language, step by step. In this tutorial you will begin to work with URL variables and understand how the receiving page interacts with this information.
The Let's Learn ColdFusion Series:
Let's Learn ColdFusion: Part 1 - Installation and the Testing Server
Let's Learn ColdFusion: Part 2 - The URL Scope, Variable Names and Values
Let's Learn ColdFusion: Part 3 - Adding Simple Logic and Error Checking
Let's Learn ColdFusion: Part 4a - Creating a Datasource
Let's Learn ColdFusion: Part 4b - Building a Dynamic List Menu
Let's Learn ColdFusion: Part 4c - Filtering Your Queries and the cfqueryparam Tag
Let's Learn ColdFusion: Part 4d - Error Checking Your ColdFusion Queries Coming Soon
Using GUIDs to Verify Registration in ColdFusion: Part 2
by Ray West - 23-Jun-06
Reader Level:
This is Part Two of this article and it explains the use of the verification page to accept a GUID and verify a users account. In the previous article, we created a registration page that accepted a registrants name and email address, generated a strong password, and created and emailed a GUID used to verify that the email address is valid and the person intended to register at your site.
Using GUIDs to Verify Registration in ColdFusion: Part 1
by Ray West - 23-Jun-06
Reader Level:
In a previous article, we talked about Globally Unique IDs (GUIDS) and their use in uniquely identifying records across disconnected databases. Another useful aspect of GUIDs is that they are sufficiently complex enough that they are not easily guessable and care be used for processes like verifying that the information (especially the email address) you received in a user registration is valid. In this article, we will take a look at some code that done just that... plus a little more.
Let's Learn ColdFusion: Part 1 - Installation and the Testing Server
by Adrian Senior - 19-Jun-06
Reader Level:
Welcome to the first in a series of articles aimed at providing an extensive overview of the ColdFusion language to newcomers to server-side development.
The series will start at the beginnning with a look at the make-up of the language and progress to basic server-side development allowing you to build on your knowledge with each new addition to the series.
The Let's Learn ColdFusion Series:
Let's Learn ColdFusion: Part 1 - Installation and the Testing Server
Let's Learn ColdFusion: Part 2 - The URL Scope, Variable Names and Values
Let's Learn ColdFusion: Part 3 - Adding Simple Logic and Error Checking
Let's Learn ColdFusion: Part 4a - Creating a Datasource
Let's Learn ColdFusion: Part 4b - Building a Dynamic List Menu
Let's Learn ColdFusion: Part 4c - Filtering Your Queries and the cfqueryparam Tag
Let's Learn ColdFusion: Part 4d - Error Checking Your ColdFusion Queries Coming Soon
Creating a Registration Page: Part 2
by Tom Muck - 07-Jun-06
Reader Level:
Dreamweaver contains many built-in tools to aid in quickly building dynamic sites. Part 1 of this series showed how to use the Record Insertion Form Wizard to set up a simple user registration form on a web site. The registration form allows a user to register for a site.
Part 2 will show validation and the user agreement, using more built-in tools of Dreamweaver and a little rudimentary JavaScript. The tutorial will apply equally to PHP, ASP, ColdFusion, and JSP using built in tools.
Part 3 will show how to pass registration details to PayPal or other payment processor for a paid membership-type of site.
The Creating a Registration Page Series:
Creating a Registration Page: Part 1
Creating a Registration Page: Part 2
Creating a Registration Page: Part 3
Creating a Registration Page: Part 1
by Tom Muck - 23-May-06
Reader Level:
Dreamweaver contains many built-in tools to aid in quickly building dynamic sites. One such tool is the Record Insertion Form Wizard. Using this tool, I'll show how to set up a simple user registration form on a web site. The registration form will allow a user to register for a site (free site or membership site), and include a way for the user to agree to a user agreement and also opt-in/opt-out of a newsletter. The tutorial will apply equally to PHP, ASP, ColdFusion, and JSP using built in tools. This is the first part in a series.
Part 2 will show validation and the user agreement, and Part 3 will show how to pass registration details to Paypal or other payment processor for a paid membership-type of site.
The Creating a Registration Page Series:
Creating a Registration Page: Part 1
Creating a Registration Page: Part 2
Creating a Registration Page: Part 3
Manipulating ID3 Tags - The Updated Version: Part 2
by Arman Danesh - 10-Apr-06
Reader Level:
In this second article on working with ID3 tags in MP3 files from within ColdFusion, you will learn how to set and update the values stored in ID3 tags.
This article is an update of an earlier article which used the jd3lib library which has changed considerably and no longer retains its original functionality. This article replaces the jd3lib with jid3lib.
The Updated Manipulating ID3 Tags Series:
Manipulating ID3 Tags - The Updated Version: Part 1
Manipulating ID3 Tags - The Updated Version: Part 2
Protecting Sections of a Control Panel by Using Access Levels
by Adrian Senior - 10-Apr-06
Reader Level:
When building administration areas it is often necessary to create multi-level access to the control panel. Often users are re-directed to a page that matches their particular administration rights.
In this tutorial we will look at how we can streamline this process by setting the administration level and implementing the required logic directly in the Application.cfm template. Once this is in place you can then show and hide sections of the control panel to specific users.
Manipulating ID3 Tags - The Updated Version: Part 1
by Arman Danesh - 07-Apr-06
Reader Level:
This is the first of two articles on manipulating ID3 tags from within ColdFusion. ID3 tags provide meta information about MP3 and other music files. This article outlines how to install the necessary Java classes and then outlines the basics of reading ID3 tags.
This article is a revision of an earlier Community MX article. That article used an older version of jd3lib, a Java library for manipulating MP3 files. However, that original version has been discontinued and cannot be downloaded and the new Alpha version has seriously limited functionality which makes it hard to use for the purposes of this article. This update is rewritten to use a newer, more robust Java library.
The Updated Manipulating ID3 Tags Series:
Manipulating ID3 Tags - The Updated Version: Part 1
Manipulating ID3 Tags - The Updated Version: Part 2
Making Full Use of Bindings
by Tom Muck - 31-Mar-06
Reader Level:
The Dreamweaver bindings panel has a lot of uses beyond a place to build recordsets and stored procedures. Many people don't realize that when you add session, request, and application variables to the panel manually, you get some visual advantages — the ability to drag items to the page into design view, the ability to use variables as filters, and the ability to add formatting functions to design view.
This article will explore the bindings panel and its advantages. Because we are discussing core Dreamweaver functionality, the article will apply equally to all server models in Dreamweaver, although some server models have better bindings panel support than others.
Using a ColdFusion Custom Tag as a Site Template: Part 4 - JumpStarts
by Tom Muck - 15-Mar-06
Reader Level:
I wrote a series of three articles on how you can use a ColdFusion custom tag to supply the design of every page in your site. Since that time, Community MX has released several JumpStarts — page designs using the latest HTML and CSS techniques to create starting points for your own designs. A JumpStart is also a perfect fit for the use of a ColdFusion custom tag. Heidi Bautista wrote an article about using JumpStarts with ASP.NET master pages — Convert an Existing Site to Use ASP.NET Master Pages and Themes. The ASP.NET master page is very similar in concept to the technique I presented in my series on CF, so this tutorial will cover the same ground for ColdFusion users, using the free North Pole JumpStart.
Creating a ColdFusion Custom Tag for US States
by Tom Muck - 28-Feb-06
Reader Level:
ColdFusion custom tags are exceptionally useful, as they allow you to put presentation functionality into a file, similar to an include, only more powerful. This article shows how a simple custom tag listing US states and Canadian provinces can be built and used.
Dynamic & Accessible Navigation with ColdFusion
by Adrian Senior - 21-Feb-06
Reader Level:
In this tutorial we are going to be looking at creating a dynamic and accessible navigation system. To do this we will be using cfoutput queries and the group attribute to gather in the information for both our top level and our sub level navigation options.
Getting Started with Eclipse - Part 2
by Michelle Kempner - 02-Feb-06
Reader Level:
In the second article of this series, you'll learn how to install Eclipse plug-ins for ColdFusion, PHP, and ActionScript.
The Getting Started with Eclipse Series:
Getting Started with Eclipse - Part 1
Getting Started with Eclipse - Part 2
Getting Started with Eclipse - Part 3
Re-running a Google Search on Your Web Site
by Adrian Senior - 20-Jan-06
Reader Level:
In this tutorial we will learn how we can access the search data a user entered on Google. We will then use that information to re-run a search on our web site to provide the user with more specific information about the item(s) they originally searched for on Google.
All About GUIDs
by Ray West - 12-Jan-06
Reader Level:
If you are familiar with databases you have probably used an autonumber field in Access or an Identity column in SQL Server to have the database assign a unique numerical ID to each record that gets inserted into a table. That works great when there is one table in one database responsible for keeping track of those records. But what if you are eBay or Amazon with database servers strewn across the world to increase reliability and availability? What if you need to take records collected by several databases and merge them back into one dataset and still maintain a unique identifier for each record?
Calculating Age In ColdFusion
by Ray West - 06-Jan-06
Reader Level:
Calculating a person’s age from their date of birth seems like a fairly straightforward proposition; subtract the date of birth year from the current year and bam, there is the age. But it is can be trickier than that, especially if your application requires accuracy in the person’s age. Which month they were born in becomes important, as does those pesky little leap years.
Lots of Sites, Lots of URLS: One Configuration
by Arman Danesh - 05-Jan-06
Reader Level:
Do you need to be able to deploy lots of sites with different URLs in the same domain, all running the same application but without any unique Apache or DNS configuration? Learn how.
Creating a Simple Blog: Part 6
by Tom Muck - 22-Dec-05
Reader Level:
There have been five parts in the series on creating a simple blog. The first five parts focused on creating basic functionality to get a basic blog up and running using simple Dreamweaver design tools. This part will show how to incorporate the functionality into a more complex design — specifically, the latest CMX Jumpstart — Inverness. This tutorial will be equally applicable to ColdFusion, ASP, PHP, ASP.NET, or JSP because we will be using standard Dreamweaver server behaviors to create
the blog. In the course of merging the dynamic blog into the design, you'll learn the following about merging content with design in general — how to find repeating items and make them dynamic, how to separate parts of an existing design into a module.
Checking For Strong Passwords in ColdFusion
by Ray West - 16-Dec-05
Reader Level:
Most applications allow users to change their password. It does not do much good to assign a strong password if your user can just change it to ‘fluffy’ at their first opportunity. The function in this article will allow you to check a submitted password to see if it qualifies as strong before allowing it to be saved in the user’s profile.
Generating Strong Passwords in ColdFusion
by Ray West - 15-Dec-05
Reader Level:
If users of your site get their information stolen because they used weak passwords and left themselves open to attack, they will still blame you for the breach. Because of this, you need to seriously consider requiring the use of strong passwords if your site deals with any kind of sensitive information.
This article will show you how to generate strong passwords for your users to protect them and you.
Code is shown in ColdFusion.
Redirecting Users When Logging In
by Danilo Celic - 12-Dec-05
Reader Level:
While the article Show and Hide Content Based on User Access Level discusses allowing content for multiple access levels (or user groups) to be held on the same page and showing portions of content based upon the user's group, sometimes you need each user group to get sent to different pages (perhaps within different folders). This article discusses how to enhance the existing Log In User Dreamweaver Server Behavior to allow redirecting users to specific pages based upon their access level when they log in.
ColdFusion Tag Clouds
by Joel Martinez - 05-Dec-05
Reader Level:
Wikipedia says about Tag Clouds:
A tag cloud (more traditionally known as a weighted list in the field of visual design) is a visual depiction of content tags used on a website. Often, more frequently used tags are depicted in a larger font or otherwise emphasized, while the displayed order is generally alphabetical. Thus both finding a tag by alphabet and by popularity is possible. Selecting a single tag within a tag cloud will generally lead to a collection of items that are associated with that tag.
The first tag cloud appeared on Flickr, the photo sharing site. That implementation was based on Jim Flanagan's Search Referral Zeitgeist, a visualization of web site referrers. Tag clouds have also been popularised by Technorati, among others.
Jeffrey Zeldman has some thoughts on the subject. Although he's not exactly the biggest proponent of the technique, my purpose here is to simply show you how to create your own. After all, if your client wants a tag cloud, who are you to deny them of it?
Sample code is provided using ColdFusion.
Maintaining Multi-page Forms in the Session Scope
by Adrian Senior - 30-Nov-05
Reader Level:
In this tutorial we will look at how we can maintain our form data over multiple pages using the session scope. Using the session scope is a more secure way of passing data from page to page and it is very simple to do, as we will see.
ColdFusion 7 on OS X: Finally, It's Official
by Thomas Pletcher - 19-Oct-05
Reader Level:
With the 7.01 release of ColdFusion, Macromedia (or perhaps Adobe) has seen the light and officially designated OS X Tiger as a supported platform. There is a slick new Mac installer to go with the new designation, and this tutorial will walk you through the process of installing the latest, greatest, officially supported version of ColdFusion on your Mac.
Using CFCs as Sources of Data for Queries in Dreamweaver 8
by Danilo Celic - 14-Oct-05
Reader Level:
ColdFusion MX added the possibility to create objects through ColdFusion Components ( CFCs ) that could be easily reused throughout your site. Reuse of is good, as it allows you make changes in one place and have the update available everywhere it is used. Dreamweaver 8 (and Dreamweaver MX 2004 with the ColdFusion MX 7 Extensions installed) allows you to create queries within components (CFCs) that can be used as data suppliers to queries visually within the editing environment.
Loading Database Tables Into a Query Dynamically
by Adrian Senior - 30-Sep-05
Reader Level:
In this tutorial we will look at how we can query a database to discover the names of the tables it contains. Once we have gleaned that information we'll loop through the tables and extract the ones that we need to include in our search facility.
Building Application.cfc
by Adrian Senior - 22-Sep-05
Reader Level:
In this tutorial we will build an Application component for use with ColdFusionMX 7 and later.
Within the component we will look at error handling and implementing a debugging session that you can easily switch on and off on a live site without showing the information to your users. We'll also implement a user count function so you can see how many active users you have on your site at any time.
Building a Receipt on World Pay's Secure Server
by Adrian Senior - 20-Sep-05
Reader Level:
In this tutorial we will look at how we can present our shopping cart customers with a nicely formatted receipt after they have paid. In this instance we will be doing it the World Pay way. Once you have created an account with World Pay you are presented with your own CMS on the World Pay site. From here you can set many parameters, not the least of which allows you to customise the paid and error pages that you will present to your customers once they have completed their transactions.
What's with the Question Marks? Or: Where are my Curly Quotes?
by Arman Danesh - 14-Sep-05
Reader Level:
If you work with ColdFusion and popular databases such as MySQL you my find yourself geting strange results. Even if you don't use non-Roman scripts such as Chinese or Arabic you may find curly quotes or other extended characters magically becoming question marks. This article discusses techniques you can use to resolve this common problem.
Using CFFLUSH
by Arman Danesh - 28-Jul-05
Reader Level:
Why, and when, would you want to use the CFFLUSH tag? This tag is not used by many developers and most ColdFusion developer's don't understand how, when or why to use it. This article provides an overview of the tag and how to use it.
Testing ColdFusion Forms
by Paul Newman - 16-May-05
Reader Level:
One of the most frequent problems that arises when developing ColdFusion applications is form processing. Often, forms don't work because they don't return the expected results. In this article, you'll learn how to create a form tester page that you can use to view the results of forms submitted via GET and POST. These can be regular HTML forms, or forms created using the cfform tag. You can even test Flash forms in ColdFusion MX 7.
Creating a Simple Blog - Part 5
by Tom Muck - 26-Apr-05
Reader Level:
One of the frequent questions in the forums is "How do I create a blog?". There are many commercial blog systems out there, and many full-featured blog providers, like Blogger, but you can also create a simple blog using the standard tools of Dreamweaver. This tutorial will be equally applicable to ColdFusion, ASP, PHP, ASP.NET, or JSP because we will be using standard Dreamweaver server behaviors to create the blog. This fifth part of the series will describe how to add a design to the blog, including a sidebar with category, blogroll, and RSS modules.
Simple Security with ColdFusion: No Database - No Problem
by Adrian Senior - 20-Apr-05
Reader Level:
In this tutorial we will use ColdFusion to look at how we can implement a simple but secure method of authentication without the need for a database.
ColdFusion 7: Using ActionScript in Flash Forms
by Paul Newman - 13-Apr-05
Reader Level:
Recently, some of our subscribers have asked how they can manipulate Flash forms — a new feature of ColdFusion MX 7 — using ActionScript. At first glance, support for ActionScript in Flash forms seems limited. However, Flash forms are generated on ColdFusion 7 using a modified version of Flex Server, so if you know a little about Flex and ActionScript, you can get your Flash forms to perform some amazing tricks.
In this article, we're going to use ActionScript to resolve two issues posted on the Community MX Forums: how to create interdependent combo boxes using <cfselect>, and how to set focus to text fields (<cfinput>) in an accordion control.
Building an XML Configuration File For Your ColdFusion 7 Application
by Danny Patterson - 06-Apr-05
Reader Level:
Most ColdFusion applications put the configuration variables in the application.cfm page. The problem with this is that you need to be a ColdFusion developer in order to modify those settings.
This article will show how to put your application's configuration information into an XML file. This tutorial will also introduce a new ColdFusion 7 feature that allows us to validate an XML document against an XML Schema file to insure it is properly formated. I will also utilize the Application.cfc architecture as a replacement to the old Application.cfm technique. To read more about this new feature, read my article titled Using Application.cfc in ColdFusion MX 7.
ColdFusion MX 7 on Macintosh OS X: Part 2
by Thomas Pletcher - 25-Mar-05
Reader Level:
Part 2 in our CF 7/Panther series shows you how to install the latest version of ColdFusion with JRun 4 in a number of different scenarios: as a new version, as an upgrade from an earlier version, or as a parallel installation with your existing version of ColdFusion.
Discovering ColdFusion MX 7: An Introduction To The SMS Gateway
by Adrian Senior - 18-Mar-05
Reader Level:
One of the exciting new features in ColdFusion MX 7 is the introduction of SMS - Short Message Services. It is perhaps better known as text messaging, certainly in the UK; if not elsewhere. We will be looking at how you can enable and test ColdFusion MX 7 for SMS messaging.
While you can use your developer edition of CFMX 7 to work along with this tutorial, in a real world scenario you will need the enterprise edition.
Once we have the SMS application running we will see how we can test the system in two ways, by using the simulator that comes with CFMX 7.
1. Send and receive via the simulator
2. Send from a web form and receive via the simulator
ColdFusion MX 7 on Macintosh OS X: Part 1
by Thomas Pletcher - 11-Mar-05
Reader Level:
Want to run the latest version of ColdFusion on OS X Panther? Part 1 of this tutorial will walk you through an installation of CF 7 that will work even if you're already running CF 6.1 on your Mac. Part 2 will show you how to upgrade an earlier ColdFusion installation to ColdFusion MX 7.
Discovering CFMX 7: Flash Forms - Part 2
by Adrian Senior - 07-Mar-05
Reader Level:
In this tutorial, we will be looking at how we can create a more compact flash form by using the accordion interface. We will look at setting up required fields and how we can then validate them using ColdFusion.
We will also investigate the use of the datefield control. This control adds an icon to your form that when clicked allows a user to select a date from a scrollable flash calendar.
Discovering CFMX 7: Flash Forms - Part 1
by Adrian Senior - 25-Feb-05
Reader Level:
In this tutorial, we will be looking at how ColdFusion MX 7 makes it very easy for us to use and create flash forms in our work.
We will be looking at how to set up the forms and we'll investigate tabbed navigation and paging. Breaking our forms down into manageable chunks can be very helpful for our users, particularly on large forms. CFMX 7 makes it very easy for us to do this.
Finally we will look at skinning our flash forms and the skins that are natively available on the CFMX 7 server.
Discovering CFMX 7: Charting
by Adrian Senior - 23-Feb-05
Reader Level:
In this tutorial, we will be taking a look at charting in ColdFusion MX 7. We will see how very easy it is to create and display dynamic data in the form of flash, JPG and PNG charts within our web pages.
Using Java and ColdFusion to Read the Metadata in JPEG Files
by Danny Patterson - 10-Feb-05
Reader Level:
Most ColdFusion developers know that ColdFusion is built on Java and that there is a vast amount of Java classes available on the internet. However, not many ColdFusion developers know how to use those Java classes in their ColdFusion applications. In this article, we will use a set of Java classes written by Drew Noakes to examine the metadata in JPEG images.
CMX JumpStart: Liverpool
by Adrian Senior - 20-Jan-05
Reader Level:
The Liverpool JumpStart is a little different than what has gone before. It includes a dynamic ColdFusion login application built with Dreamweaver's User Authentication server behaviours. This allows you to quickly and easily edit the login if you need to do so. The login also supports dual access levels and provides default pages for each level to view, along with a logout page to kill the sessions when your users have completed whatever it was they logged in to do.
Also included are login application pages for .NET, PHP and ASP server models.
This JumpsStart contains 12 tutorials, including video lessons on creating a relational database in Access, using Dreamweaver's User Authentication server behavoiurs and setting a datasource via the ColdFusion administrator.
If you prefer not to use server side code, within the download files you will find a static version of the Liverpool JumpStart.
If you'd like a more detailed description of Liverpool, including screenshots, check out the free article Announcing a New CMX JumpStart: Liverpool.
Dreamweaver Piece by Piece Part 5: Creating and Processing Basic Forms Part 2
by Sheri German - 17-Dec-04
Reader Level:
In the first part of our basic forms series, we learned how to configure Dreamweaver form preferences, set up the form with the proper actions and method, and use many of the different kinds of form objects such as text field, textarea, radio groups, and checkboxes.
In this second article in the series, we'll look at the menu/list form object, add our submit and reset buttons, use the validate form behavior, learn to set file permissions, and configure our PHP form processor. Also included in this article are both a ColdFusion and an ASP form processor for those who do not have PHP available on their servers.
ColdFusion on OS X
by Thomas Pletcher - 29-Nov-04
Reader Level:
ColdFusion, Macromedia's powerful server-side scripting language, is not just for Windows developers. You can harness the power of ColdFusion and Java on your Mac by installing the free CF Developer Edition, which provides the same functionality as the top-of-the-line ColdFusion MX Enterprise. This tutorial will walk you through the installaton step-by-step, show you how to install the latest updaters for both JRun and ColdFusion, discuss your database options for ColdFusion on the Mac and show you how to write a shell script to start JRun and ColdFusion automatically upon login.
File Management with cfdirectory and cffile: Part One - Batch Delete
by Adrian Senior - 26-Nov-04
Reader Level:
In this tutorial, we will use cfdirectory and cffile to delete files on the server based on the age of any given file.
We will look at date masks and the use of variables to provide test parameters prior to carrying out the batch delete on the server.
Previous and Next Links for Details Page Stored Procedure
by Tom Muck - 24-Nov-04
Reader Level:
If you have used Dreamweaver to create dynamic pages, you are probably familiar with the Repeat Region and the concept of Next/Previous records. You are probably familiar with the Master/Detail pageset concept -- the Master page contains a table listing your records with links that allow you to drill down into a Details page. The Details page gives you the details about a particular record. Unfortunately, the Details page does not allow you to create the Previous/Next links easily. This is often desirable in a site, such as in a photo album, real estate listing, or other type of list where the user might want to remain on a Detail page and simply cycle through the records rather than go back to the Master page again. This tutorial will show how to create a SQL stored procedure that will supply Previous/Next links to any ColdFusion or ASP page.
Pseudo DSN-less Connections in ColdFusion MX
by Danilo Celic - 23-Jul-04
Reader Level:
ColdFusion MX was a great leap forward in many respects, however, one thing that many feel is a step backwards, is that DSN-less connections are no longer allowed. If your client's process was to add their new products in bulk to the shopping cart system by uploading an Access database that contained a table with all the new products in it, or if they collected business cards at their industry convention and needed to upload their Excel spread sheet that stores all the email addresses to add to their eNewsletter, this change in the ColdFusion MX release probably upset your cart a little.
The new functionality can basically stop you from connecting to an arbitrary databases, such as the uploaded files in the examples above. However, all is not lost if you are working with Access databases, or Excel files as a source for your data, then you may be able to use what is commonly called a pass through database to connect to your uploaded files.
This tutorial will show you how to create pages that upload MDB and XLS files and then output data from those files, all without having a DSN created specifically for the files.
Manipulating ID3 Tags: Part 2
by Arman Danesh - 13-Jul-04
Reader Level:
In this second article on working with ID3 tags in MP3 files from within ColdFusion, you will learn how to set and update the values stored in ID3 tags.
Manipulating ID3 Tags: Part 1
by Arman Danesh - 02-Jul-04
Reader Level:
This is the first of two articles on manipulating ID3 tags from within ColdFusion; ID3 tags provide meta information about MP3 and other music files. This article outlines how to install the necessary Java classes and then outlines the basics of reading ID3 tags.
**This article has been updated. The earlier article used the jd3lib library which has changed considerably and no longer retains its original functionality. The updated article replaces the jd3lib with jid3lib.
Creating a Login System
by Joey Lott - 01-Jul-04
Reader Level:
Learn how to use built-in ColdFusion MX security to require a login and password for your applications. You'll also get a chance to learn how to grant access to specific sections of the application based on the user's roles.
Better Error Messages for CF and Flash Remoting
by Tom Muck - 24-Jun-04
Reader Level:
There are many times while developing ColdFusion or (especially) Flash Remoting applications that the default log files and error messages supplied by ColdFusion and/or the NetConnection debugger don't give you enough information. For those situations, the technique shown in this article will show more than the typical amount of error info.
CFC Log In System
by Adrian Senior - 28-May-04
Reader Level:
Creating a CFC log in system incorporating structured role levels. We will look at instantiating a CFC and passing arguments into it from the form scope to trigger access to our application. The access is continually monitored, and will automatically present the log in form on any page where a user's session expires, or on any page that a user attempts to access the log in system from.
Creating a Simple Blog Part 4
by Tom Muck - 25-May-04
Reader Level:
One of the frequent questions in the forums is "How do I create a blog?". There are many commercial blog systems out there, and many full-featured blog providers, like Blogger, but you can also create a simple blog using the standard tools of Dreamweaver. This tutorial will be equally applicable to ColdFusion, ASP, PHP, ASP.NET, or JSP because we will be using standard Dreamweaver server behaviors to create the blog. This fourth part of the series will describe how to add categories to the blog by modifying the pages you've already created and also how to display the number of comments on each item.
Limiting Upload File Size in CF
by Bill Horvath - 28-Apr-04
Reader Level:
Even if you're standing right behind someone saying "OK, your upload size is limited to 10 kilobytes", chances are they'll try and upload something larger than that.
This tutorial will outline how to prevent a user from uploading a file that exceeds your predetermined file size limitation. We'll also give the user a message explaining what the file size limit is - if they exceed it, and a "File Uploaded" message if they do not.
A Simple Banner Application: Part 2
by Bryan Ashcraft - 09-Apr-04
Reader Level:
In Part 1, we covered the creation of the database, the application.cfm file, and a basic page to display our banners. This, the final installment, will take you through monitoring the number of times an ad is shown and counting each click-through a banner receives.
Creating a Guestbook - Part I
by Bill Horvath - 06-Apr-04
Reader Level:
Guestbooks are a way for people to leave comments on your website for other folks to see. In this series, we'll build a guestbook from the ground up. Part I will cover the very basics and at the end we will have a functional guestbook. Part II will cover a couple of advanced concepts to add more functionality to the guestbook, like disallowing "bad" words and supplying "Next" and "Previous" navigation links.
A Simple Banner Application: Part 1
by Bryan Ashcraft - 02-Apr-04
Reader Level:
In this, the first of a two-part series, we will create a simple banner ad rotator that will randomly display an ad and monitor the number of times it is seen by our visitors, as well as, track our visitor's click-thrus. The application will ensure that every visitor will not see the same ad twice (unless, of course, they view enough pages to see every ad we have to display).
CF Fundamentals: Variable Basics
by Arman Danesh - 01-Apr-04
Reader Level:
In this installment of the ColdFusion fundamentals series, the basic concept of variables is introduced including how to name variables and assign values to them.
Creating a Simple Blog Part 2
by Tom Muck - 30-Mar-04
Reader Level:
One of the frequent questions in the forums is "How do I create a blog?". There are many commercial blog systems out there, and many full-featured blog providers, like Blogger, but you can also create a simple blog using the standard tools of Dreamweaver. This tutorial will be equally applicable to ColdFusion, ASP, PHP, ASP.NET, or JSP because we will be using standard Dreamweaver server behaviors to create the blog. Part 1 of the tutorial can be found at http://www.communitymx.com/abstract.cfm?cid=7CC52. Part 2 will focus on adding more features to the blog, such as a system for adding and viewing comments, and more administration options.
ColdFusion Variables Part One: The form and variables Scopes
by Adrian Senior - 29-Mar-04
Reader Level:
In this series, we will look at the various scopes that exist within ColdFusion and how we can access them.
We will look at how we can avoid name collisions and debug ColdFusion error messages. To begin the series, we will start with a look at the vaiables and form scopes. We will look at the problems that sloppy code can cause in our application and how we can ensure that our code produces the results we expect.
Our First CFC: Part 3
by Adrian Senior - 23-Mar-04
Reader Level:
In this, the final part of the series, we will look at building on our CFC to make it a complete resource for working with our database information.
We will build upon the functionality we have already completed and create update and delete functions. We will also discover how we can populate a select list directly from our CFC and pass its values to a different template and invoke a second function from within our CFC.
Creating a Simple Blog Part 1
by Tom Muck - 22-Mar-04
Reader Level:
Many people ask "how can I build my own blog?" This tutorial will show how to create a simple blog using point-and-click features of Dreamweaver. For that reason, this tutorial can be followed for any server model that Dreamweaver supports.
Our First CFC: Part Two
by Adrian Senior - 16-Mar-04
Reader Level:
In this, the second tutorial in the series, we will look at reducing the overhead created by cfinvoke and making our CFC available on an application wide basis.
We will extend our CFC to incorporate a second function that handles a database insert, and ensure that our arguments are only passed into our CFC when we are ready for the component to be executed.
A Quick Approach to Home-Brewed Content Caching in ColdFusion - Part 3: In-Memory Caching
by Arman Danesh - 15-Mar-04
Reader Level:
Caching is a technique which can dramatically improve the performance of some Web applications. This article extends the file-based caching technique outlined in the previous articles and offers an in-memory caching technique.
The Home-Brewed Content Caching Series:
A Quick Approach to Home-Brewed Content Caching in ColdFusion - Part 1: The Theory
A Quick Approach to Home-Brewed Content Caching in ColdFusion - Part 2: The CFC
A Quick Approach to Home-Brewed Content Caching in ColdFusion - Part 3: In-Memory Caching
Export Recordsets to Excel - Part 3
by Bryan Ashcraft - 10-Mar-04
Reader Level:
In Parts 1 and 2, Bill showed you how to create Excel files on the fly and email them to your clients, yourself, etc. Well, what if your client just wants to be able to click a link and download it directly from the server? That's exactly what I'll show you how to do in this installment. I do recommend you read at least the first installment as the topics covered there will not be rehashed in this one.
Resending Undeliverable Mail in ColdFusion
by Tom Muck - 09-Mar-04
Reader Level:
ColdFusion is capable of high-output mail delivery. One problem with the ColdFusion server that is not addressed by any built-in functionality is what happens when an email cannot be delivered. This article will address one possible way to handle undeliverable messages. This method only works in instances where you control your own server, however, as the central spool folders for emails in ColdFusion are server-wide rather than site-wide.
Our First CFC: Part One
by Adrian Senior - 08-Mar-04
Reader Level:
In this tutorial, we will look at creating our first ColdFusion component and how we can interact with it.
We will look at the cfargument, cffunction and cfreturn tags, and explore how we can interact with our component using cfinvoke and cfinvokeargument.
Searching xml Documents with ColdFusion
by Adrian Senior - 19-Feb-04
Reader Level:
In this tutorial, we will investigate how we can search an xml document.
We will be looking at creating a dynamic table and populating it from our xml data. We will then look at how we can search that data and return the information we need. Along the way we will also be looking at query of queries, and investigating the XmlParse function.
Using UUIDs for Database Record IDs
by Arman Danesh - 04-Feb-04
Reader Level:
Auto-incrementing numeric fields are a useful way to create unique IDs for records in a database table, but they have their limits. UUIDs provide a powerful alternative that is scalable, transportable and easy-to-implement.
Using the Hash Function
by Arman Danesh - 26-Jan-04
Reader Level:
The Hash function is a handy tool for many purposes. You can use it to protect passwords in databases, or track changes to files.
This article introduces how to use the function and shows some practical examples.
Dynamic Web Development - The Basics: Creating Dynamic List Menus
by Adrian Senior - 22-Jan-04
Reader Level:
In this tutorial, we will look at how we can create an inline dynamic list menu, complete with a tabindex.
We will also look at how we can filter page content based on a url variable.
This tutorial contains video demos.
Dynamic Web Development - The Basics: Creating a ColdFusion Datasource
by Adrian Senior - 16-Jan-04
Reader Level:
In this tutorial, we will look at how we can set up a datasource in the ColdFusion administrator and access it in Dreamweaver. This tutorial contains video demos.
Dynamic Web Development - The Basics: Creating a Join and Log In Application.
by Adrian Senior - 14-Jan-04
Reader Level:
In this tutorial we will use the native Dreamweaver behaviours to create a join and log in application for our users.
We will design the database tables, and the insert and log in pages. As this tutorial only uses the native Dreamweaver behaviours the server-side language you use is irrelevant. We will let Dreamweaver insert all the code that is required and of course that code will be defined by your site definition. This tutorial contains video demos.
Dynamic Web Development - The Basics: The Application.cfm Template
by Adrian Senior - 02-Jan-04
Reader Level:
In this tutorial, we will explore how to use the ColdFusion Application.cfm template to make our lives so much easier.
We will also explore the
Using the Log In Server Behavior
by Adrian Senior - 29-Dec-03
Reader Level:
In this tutorial we will be learning about the standard Log In Server Behavior that ships with Dreamweaver.
We will be looking at this Server Behavior in its basic form, in a language independent way.
This tutorial is aimed at beginners who are new to Server side development and looking to to be able to show unique content on a user group by user group basis. Tutorial contains video demos.
Structures Part Two: Nesting Structures
by Adrian Senior - 22-Dec-03
Reader Level:
In this, the second part of our series on structures, we will look at how we can create nested structures. We will look at how we can populate them, and we will also investigate the use of dot notation.
Part One: An Introduction to ColdFusion Structures
by Adrian Senior - 15-Dec-03
Reader Level:
In this tutorial we will have a gentle introduction to the ColdFusion structure. We will look at how structures are created and the basics of what they are.
In the coming articles in this series we will look at the ways in which we can put structures to work in our applications.
Export Recordsets to Excel - Part 2
by Bill Horvath - 09-Dec-03
Reader Level:
In Part 1 of this tutorial, we learned how to export the contents of a recordset to an Excel spreadsheet, and then email that report to a specific email address. In Part 2, we'll look at ways to adjust our query in ColdFusion so that we can build customized reports that can then be exported to Excel.
We'll also go over how to email the report to any email address you like, rather than just the one email address we used in Part 1 of the tutorial.
ColdFusion Arrays - Part Three: User Interaction
by Adrian Senior - 02-Dec-03
Reader Level:
In this, the third tutorial in this series, we will look at how we can allow our users to create and interact with our arrays.
We will do this by allowing our users to select 5 songs from a select list. We will perform error checking to ensure our users do not select more, or less, than that number.
When we have the correct information we will insert the array that was populated by our user into a database table.
Making the Log In User Server Behavior Case-Sensitive
by Bill Horvath - 27-Nov-03
Reader Level:
The Log In User Server Behavior is handy, for sure. But it does not deal with case-sensitivity with regard to passwords. This tutorial will will cover how to add three lines of simple code to the Server Behavior to achieve case-sensitive passwords.
Find out how easy it can be to modify Macromedia's "stock" server behaviors and make them do what you want them to.
Arrays in ColdFusion - Part 2: 2-Dimensional Arrays
by Adrian Senior - 26-Nov-03
Reader Level:
In this tutorial we will look at the two-dimensional ColdFusion array. We'll look at their structure, and how we can populate them from a query.
Part One: Creating and Manipulating Arrays
by Adrian Senior - 21-Nov-03
Reader Level:
In this tutorial we will look at the basics of arrays in ColdFusion. We will explore how we can create an array, and how to populate it with data.
Once we have created and populated the array, we will look at how we can manipulate the data within that array by using the ArrayAppend, ArrayPrepend and ArrayInsertAt functions.
Check New Username Server Behavior
by Bill Horvath - 19-Nov-03
Reader Level:
A lot of people in the Dreamweaver forums ask "How can I make sure when someone registers on my website that their username is not the same as someone else's?"
Server behaviors can save you time, sweat, energy and frustration. The Check New Username server behavior is one of those behaviors that has been a part of Dreamweaver since UltraDev, but folks glance by it somehow.
In a few simple steps, you'll learn how to use this server behavior, and also how to modify it a bit to offer greater flexibility.
Using the cfsavecontent Tag with UDFs
by Adrian Senior - 18-Nov-03
Reader Level:
In this tutorial we will build on the earlier UDF tutorials.
We will look at using a query within the UDF and returning structured content from the UDF for display in the calling template.
Counting Users In Our Application
by Adrian Senior - 11-Nov-03
Reader Level:
In this tutorial we will look at how we can count users that are accessing our application.
As each new user visits the site we will create a new key for them and add them into the structure. By using the DateDiff function we will also see how we can remove users that have left our application.
We will also discuss how we can use the cfdump tag to view the function in operation.
Part Four: Building a UDF Library
by Adrian Senior - 06-Nov-03
Reader Level:
In this tutorial we will look at building on our discount UDF, and grouping it with similar UDFs, to create a library of user-defined functions.
We will also look at adding a UDF to perform our vat calculations.
Part Three: Utilising UDFs in a Shopping Cart Scenario
by Adrian Senior - 04-Nov-03
Reader Level:
In this tutorial we will explore how we can make UDFs work for us in a shopping cart scenario of buy one item, get a % reduction if you buy the second added extra item.
We will explore how we can use required, and not required, arguments and look at supplying default variables for arguments that aren't required.
Part Two: Interacting With Our UDFs
by Adrian Senior - 03-Nov-03
Reader Level:
In this tutorial we will pick up from where we left off in Part One.
We'll explore how we can allow our users to interact with the UDF by using variables in the url scope to return specific data from a query.
We will also explore using a dynamically populated unordered list to provide the necessary information to the UDF.
User Defined Functions: The basics
by Adrian Senior - 30-Oct-03
Reader Level:
This tutorial will examine how to extend ColdFusion with tag-based User Defined Functions (UDFs).
We will start at the beginning and see how we can construct a simple UDF and what the basic requirements of the UDF are.
Export Recordsets to Excel - Part 1
by Bill Horvath - 28-Oct-03
Reader Level:
I have a client that lives and dies by Excel data. He uses Excel as a database in his office, and wants his website stats, and online sales data, emailed to him in Excel format.
ColdFusion makes this task very simple. In this tutorial, we'll learn how to create an Excel file on your server through ColdFusion, append data to it, and even email it automatically to your customer.
Dissecting the Login User Server Behavior
by Bill Horvath - 21-Oct-03
Reader Level:
Dreamweaver MX makes it very easy to create a page where your users can log in to your website. In this tutorial, you'll find out how one simple server behavior can not only provide this functionality, but can also restrict access to certain pages based on the user's predefined access level.
Grouping with cfoutput
by Bryan Ashcraft - 13-Oct-03
Reader Level:
Have you ever needed to group the results of a database query into related chunks? For example, a listing of employees by department, where the department name is only shown once, then each employee is shown under the corresponding department. Well there is an attribute of the cfoutput tag that will allow you to do just that. And this tutorial shows you how.
Exploring the cflock Tag
by Adrian Senior - 30-Sep-03
Reader Level:
In this article we will look at the cflock tag and its attributes. We will look at how we can deploy the cflock and how we can use its attributes to ensure we get the protection we want for our code.
Manipulating Images with Jimg (Part 2)
by Paul Newman - 25-Sep-03
Reader Level:
In Part 2 of this tutorial, we use Jimg, the ColdFusion component from DRK 4, to create a photo gallery application. You'll learn to employ CFFILE to upload the file, and Jimg to generate a thumbnail image with a border and caption. In addition, you'll learn to dynamically display the contents of image folders using ColdFusion's CFDIRECTORY tag.
Page Based Dynamic Images in an Included File: Method 2
by Bryan Ashcraft - 24-Sep-03
Reader Level:
In the first installment of this series we looked at a simple, but manual way to determine what image to display in an included file based on what master page was being called. In this installment we will look a completely dynamic approach to accomplish the same result.
Creating a custom CF log In application
by Adrian Senior - 18-Sep-03
Reader Level:
In this tutorial we will look at creating a log in application that is a little leaner than the dreamweaver one and allows code reuse through the use of the Application.cfm template.
Manipulating Images with Jimg (Part 1)
by Paul Newman - 16-Sep-03
Reader Level:
One of the hidden gems in Macromedia's DevNet Resource Kit Volume 4 (DRK 4) is Jimg. At its core, Jimg is a series of Java classes that give ColdFusion developers access to the Java Advanced Imaging API (JAI). Practically speaking, this means that you can use Jimg to resize an image, obtain its size and dimensions, draw borders and text, rotate, crop, and much more. In Part 1 of this tutorial, we'll employ Jimg to generate thumbnail images.
Upload An Image and Insert Its Name Into The Database
by Adrian Senior - 15-Sep-03
Reader Level:
In this tutorial we will look at how we can transfer an image from the user's hard drive to the server and then insert the image's name into our database for use on any necessary pages.
Eliminating Extra White Space in Your HTML
by Arman Danesh - 12-Sep-03
Reader Level:
Typically, ColdFusion-generated HTML code has plenty of extra white space. It's easy to get rid of this extra white space. Here's how.
Using Authorize.net with ColdFusionMX
by Bill Horvath - 05-Sep-03
Reader Level:
Do you need to accept credit card payments on your website? Although this can seem like a daunting task, it's not difficult using Coldfusion, and a handy custom tag made specifically for use with Authorize.net's payment gateway.
Porting Pollster to SQL Server
by Paul Newman - 04-Sep-03
Reader Level:
One of the most popular widgets in Macromedia's DevNet Resource Kit Volume 4 (DRK 4) is Pollster. This tutorial includes everything you need to migrate Pollster to SQL Server, including a SQL script and instructions on revising the application's ColdFusion components.
Using ColdFusion Locales
by Arman Danesh - 18-Aug-03
Reader Level:
ColdFusion MX has done a lot to make internationalized applications easier to build. Aside from it's built-in Unicode support, ColdFusion MX supports the use of Locales to make it easy to generate the output of dates, times and other data in a language and culturally-appropriate fashion. This quick tutorial shows you how to use these locales in your applications.
Unicode and International Character Sets in Coldfusion MX: Part 1
by Arman Danesh - 14-Aug-03
Reader Level:
ColdFusion MX is fully Unicode compliant but making everything work properly for international character sets from the browser through to the back end database requires a firm understanding of Unicode and how to use it in ColdFusion MX. This article is the first in a series of three articles that show you how to work with Unicode and international characters sets in ColdFusion.
The Unicode & International Character Sets Series:
Unicode and International Character Sets in Coldfusion MX: Part 1
Unicode and International Character Sets in Coldfusion MX: Part 2
Unicode and International Character Sets in Coldfusion MX: Part 3
Email a Forgotten Password in ColdFusion
by Bill Horvath - 11-Aug-03
Reader Level:
You've done it... I've done it. We've all signed up at a website and had to create a username and a password for ourselves, only to forget them months or perhaps even minutes later. Most sites allow you to have your password emailed to you automatically. That's what this tutorial will go over: emailing a user their password using some very simple ColdFusion code. All of the action will take place on the log-in page, so your user never has to leave the log-in page.
Page Based Dynamic Images in an Included File: Method 1
by Bryan Ashcraft - 08-Aug-03
Reader Level:
So you want to leverage the ability to use include files to ease site maintenance, but need to be able to show a different image based on the page being viewed. Not to worry, there are a couple of methods you can use with ColdFusion to achieve that goal. We will look at both methods in this two part series.
Xsl transformation: Weaving magic on the server.
by Adrian Senior - 30-Jul-03
Reader Level:
In this tutorial we take our xml file and transform it with xsl on the server using ColdFusion, the resulting transformation is held in a variable and then streamed into the browser as xhtml.
Using a ColdFusion Custom Tag as a Site Template Part 3
by Tom Muck - 08-Jul-03
Reader Level:
ColdFusion custom tags allow you to build a flexible template for your site
that will feed every page on the site. Part 1 of this series showed the basic
concepts of the custom tag and how to use one as a site template. The tutorial
addressed the setup and implementation of a custom tag, and showed how to supply
a title to the document dynamically. Part 2 showed you how to add other
features to this template, such as JavaScript, CSS, and meta tags. Part 3 will show how
to incorporate a table layout or a div layout in setting up your template.
Creating XML Documents with ColdFusion
by Adrian Senior - 01-Jul-03
Reader Level:
Learn how to create an xml file by passing a cfquery over your data, see how it can be easily exported and written to your machine and then reimported back into access to create a database table.
Using a ColdFusion Custom Tag as a Site Template Part 2
by Tom Muck - 30-Jun-03
Reader Level:
ColdFusion custom tags allow you to build a flexible template for your site
that will feed every page on the site. Part 1 of this series showed the basic concepts of the custom tag and how to use one as a site template. The tutorial addressed the setup and implementation of a custom tag, and showed how to supply a title to the document dynamically. Part 2 will show you how to add other features to this template, such as JavaScript, CSS, and meta tags.
Using a ColdFusion Custom Tag as a Site Template Part 1
by Tom Muck - 20-Jun-03
Reader Level:
ColdFusion developers have had Custom Tags in their arsenal of tricks since the early days of ColdFusion. With CFMX, the
Check for duplicate database entries
by Bill Horvath - 17-Jun-03
Reader Level:
You may have a database in which you have duplicate entries in a particular column. This may be by design, or possibly by accident. If you've inherited the site from someone else, you may not be aware of this duplicate data. Or perhaps you are aware, but you'd like to see what or where this data is. This tutorial will allow you to build a page that lists only duplicate entries from a column in your database.
Preventing duplicate database entries in ColdFusion
by Arman Danesh - 11-Jun-03
Reader Level:
If you need a Username to be unique when a user registers on your website, this article shows two simple ways to insure that they cannot select a name that is already being used. These techniques can be used to prevent the creation of duplicate database entries in any database.
Populating a select list using cfdirectory
by Adrian Senior - 06-Jun-03
Reader Level:
Have you ever need to pull the contents of a directory within your site and make it available to you visitor via a select list? Well, ColdFusion provides an easy way to do it using the <cfdirectory> tag.
Using CFDirectory to Get Multiple File Types
by Bryan Ashcraft - 06-Jun-03
Reader Level:
While the cfdirectory is a very powerful and helpful tag, it does have one flaw. You can only filter the files gathered with the tag by a single file type. So if you have a folder containing both .jpg and .gif files there is no way to get them all at once. Well, with a little help from ColdFusion's query of queries feature we can overcome this problem.
Emailing file attachments with ColdFusions cfmail and cfmailparam tags
by Adrian Senior - 05-Jun-03
Reader Level:
Learn how to allow your viewers to send you file attachments through your web site forms. Shows you how to upload the file and create a variable for storing the file until it's called for forwarding it on to its destination.
ColdFusion - CFML Basics - Part 3
by Bryan Ashcraft - 28-May-03
Reader Level:
Part 3 in a series of articles that will take you through the basic tags used in the CFML language. Providing you with an explanation of the tag along with examples. This installment will compare the <cfquery> tag to ColdFusion's 'shorthand' methods of inserting and updating records; the <cfinsert> and <cfupdate> tags.
The CFML Basics Series:
ColdFusion - CFML Basics - Part 1
ColdFusion - CFML Basics - Part 2
ColdFusion - CFML Basics - Part 3
Using a database to display images dynamically
by Bill Horvath - 21-May-03
Reader Level:
Let's say you have a repeat region and you want to display a unique picture with each record. There's really no way you can do that without using your database to hold information about the image you want to use. In this tutorial, you'll learn how to use your database and a repeat region to dynamically display your images. We'll even go over how to display an alternate image if there is no reference to it in your database.
ColdFusion - CFML Basics - Part 2
by Bryan Ashcraft - 20-May-03
Reader Level:
Part 2 in a series of articles that will take you through the basic tags used in the CFML language. Providing you with an explanation of the tag along with examples. This installment covers the <cfquery> tag.
The CFML Basics Series:
ColdFusion - CFML Basics - Part 1
ColdFusion - CFML Basics - Part 2
ColdFusion - CFML Basics - Part 3
Using the Google API from ColdFusion
by Arman Danesh - 13-May-03
Reader Level:
Learn to build Google searches right into your own ColdFusion applications using the Google Web Service API.
CFFILE: Uploading files to your server with ColdFusion
by Adrian Senior - 09-May-03
Reader Level:
Learn how to to use multipart/formdata in your forms for transferring files from your hard drive to your server.
This tutorial shows how you can use ColdFusion to transfer varying types of files and how you can set permissions to restrict the types of files that are uploaded.
Defining a Site in DreamweaverMX - The Advanced Tab
by Laurie Casolino - 09-May-03
Reader Level:
In the first part of this tutorial we covered setting up a static site in DWMX using the Basics Tab in the Site Definition window. In this second part, we will be setting up, step by step, a fictitious ColdFusion site using the Advanced Tab.
Displaying Alternate Text if Recordset is Empty
by Bill Horvath - 08-May-03
Reader Level:
If you've got an empty recordset, rather than have a big blank spot on your page where data should be, you can show whatever text you like, or even an image. Using CFIF statements and a recordcount variable, it's a nice cool breeze.
Adding a Horizontal Loop to DWMX's Repeat Region with ColdFusion
by Bryan Ashcraft - 30-Apr-03
Reader Level:
Dreamweaver provides a way to list multiple results from a recordset. Unfortunately it only enables a vertical or horizontal display of these results. Many times you may want, or need, to display your results in a horizontal and vertical manner. This tutorial will take you through the process of creating just such a page by building upon the built-in "Repeat Region" server behavior.
Updating Multiple Records without CFGrid
by Bryan Ashcraft - 24-Apr-03
Reader Level:
Have you wanted to be able to update multiple records in a table in one fell swoop, but either didn't want, or know how, to use CFGrid? Well this tutorial will take you step by step through the process. I think you'll be surprised at how easy it is using ColdFusion.
Consuming the CMX Web Service with ColdFusion
by Tom Muck - 22-Apr-03
Reader Level:
Community MX publishes a web service that will display information about the latest content available from the site. This service can be used by anyone who knows how to consume a web service. The Community MX web service utilizes a standard .wsdl file that can be consumed by any technology that can consume a web service. The web service is located at http://www.communitymx.com/services/cmxfeed.wsdl. The web service exposes 3 methods:
getContent: grabs the latest content descriptions available from Community MX.
searchContent: search the content at Community MX for relevant content
getContentTypes: the latest content types are available as a list for your applications as well (articles, extensions, etc).
Create/Email a tab-delimited text file from a web page
by Bill Horvath - 21-Apr-03
Reader Level:
Many programs require that you import data via a tab or comma-delimited text file. Now you can create one right from your web page and email it at the same time.
Email the Contents of a Form Using ColdFusion
by Bill Horvath - 16-Apr-03
Reader Level:
Sending the results of a simple form from your web page using some simple ColdFusion code is much easier than you might imagine.
Setting upload permissions
by Adrian Senior - 14-Apr-03
Reader Level:
Setting your local CFMX development server permissions so you can test image uploading prior to moving your site to yor production server.
Creating a Multi-Page Form
by Bill Horvath - 10-Apr-03
Reader Level:
Create a form that carries over several pages. This is useful for loan applications, lengthy registration pages, etc.
ColdFusion - CFML Basics - Part 1
by Bryan Ashcraft - 09-Apr-03
Reader Level:
Part 1 in a series of articles that will take you through the basic tags used in the CFML language. Providing you with an explanation of the tag along with examples. This installment covers the <CFSET>, <CFPARAM> and <CFOUTPUT> tags, along with an explanation of the importance of the "#" sign.
The CFML Basics Series:
ColdFusion - CFML Basics - Part 1
ColdFusion - CFML Basics - Part 2
ColdFusion - CFML Basics - Part 3
CFInsert & CFUpdate code reuse
by Adrian Senior - 30-Mar-03
Reader Level:
Learn to minimize the code necessary to insert and update records in ColdFusion. Code reuse makes your applications more efficient than they could otherwise be. It reduces development time by
half as you only need to create your form and insert\update pages once, ColdFusion can do the rest for you simply by creating some conditional code that allows
ColdFusion to apply some logic to your requirements.



