The GROUP attribute is used to group database output so that rows may be grouped as needed. To use this attribute correctly your database query must be sorted properly using the same sort sequence as the one used for grouping. And be sure to use the SQL ORDER BY clause (although it is named GROUP...
and can greatly simplify implementing client side form field validation by generating frequently used JavaScript validation code for you. But what if you want to extend the built in validation to perform validation not supported by the generated code? You can do this using the tag's ONSUBMIT...
ColdFusion is very flexible and accommodating when it comes to working with dates, and almost any date format you can imagine will be interpreted and processed correctly. This is even true in the case when two digit years are provided - ColdFusion will usually process the date correctly (assuming...
ColdFusion supports arrays of 1, 2, and 3 dimensions. Need an array of more than 3 dimensions? You can't create one using the ArrayNew() function but you can achieve the same result by nesting arrays yourself. (Applies to: ColdFusion All)
Everyone is familiar with the clipboard feature found in most Windows applications - this is what facilitates cut-and-paste or copy-and-paste functionality. But you might not be familiar with Studio's enhanced clipboard which lets you save multiple items and then paste them individually or all at...
Are there search strings that you find yourself having to use over and over while working on your code? Then take a look at Studio's Extended Find and Extended Replace features. The button next to the Find What box lets you save search text and load previously saved searches. And the selections...
Experienced Web developers know that not all colors are safe to use within Web pages - and not all colors are supported properly by all browsers on all platforms. ColdFusion Studio takes the guesswork out of picking colors by letting you pick them from specified palettes - including a palette named...
Multi-language sites are becoming common place (and expected too). ColdFusion is an ideal platform on which to build multi-language sites, but there is one important design consideration that you must pay attention to. Unless you want to end up with multiple copies of pages and sites (no, you don't...
HTML tables are an extremely important part of the language, and one Web developers use extensively (as they provide the only real way to control exact placement of objects relative to each other). But there is a big downside to using tables, a downside so significant that they should not be...
ColdFusion is very good at providing line numbers when errors occur - this way you can quickly find the exact line of code that caused the problem. But instead of scrolling up and down in Studio (looking at the status bar) to find the line you need, turn on the "Show line numbers in gutter" option....