For rapid access to specific query rows and columns, access them as if they were structures and arrays. You can refer to a specific column of a specific row as #query.column[row]#. For example, if you wanted the "price" column for the fifth row of a query named "products" you could use the...
ColdFusion Studio 4.5 introduced a feature that allows to you collapse and expand code blocks so as to save editor window space, but this feature is also a great debugging tool. To quickly check for mismatched tags click on any tag, right-click, and then select "Collapse Tag" to collapse all the...
Having a rough time getting Studio's debugger to work? More often than not the problem is one of mappings - for the debugger to work you must specify three mappings (one for each of ColdFusion, your Web server, and your Web browser). If those are not correct the debugger will not be able to...
ColdFusion is usually used to generate content for use within Web browsers, but that's not all you can do. In fact, ColdFusion is entirely client independent - you can generate content for any client including wireless devices (for example, WAP, iMode, and Palm) and other applications (for example...
Visit the Developer's Exchange at www.allaire.com regularly. There are hundreds of great tags and code examples there for you to download, and most in source code form. Before you write it yourself, check to see if someone else has already done it for you. (And of course, contribute your own...
ColdFusion Studio's design mode has gotten a rather bad reputation, and one it really does not deserve. Design mode works well as long as it's intent and limitations are understood. Design mode was never intended for use on existing CFM pages, it was intended to be used primarily for initial page...
The less hardcoded your application is, the easier it'll be to reuse, maintain, and deploy. For example, never specify an actual ODBC datasource name in the DATASOURCE attribute - instead define a variable (perhaps in APPLICATION.CFM) which contains the datasource name, and pass that variable to...
Every page on your site should be dynamically generated, but you probably have many pages that change infrequently and would be served quicker if they did not include run-time CF processing. In situations like this consider using the tag which can cache dynamically generated output and serve it...
Using native database drivers? Then you probably have already discovered that you cannot use the ODBC date functions (like CreateODBCDate() and CreateODBCDateTime()). To format dates for native database driver use you must use the DateFormat() and TimeFormat() functions to manually format the date...
ColdFusion features a "trusted cache" mode whereby cached p-code pages are assumed to always be current and checks for newer CFM files are not made. Turning on this option can improve performance slightly, but there is an even more important benefit - with trusted cache enabled developers will not...