ColdFusion's Verity support can be used to perform sophisticated full text searching. And while simple text searches (equality or substring searches) are the most frequent search types, more sophisticated searching using expressions and wildcards can also be performed, even searches involving text...
Using with a LDAP 3 server? If so, you can obtain the directory schema (data definitions and layout) dynamically so that you can walk the tree or write truly dynamic interfaces. To access the schema you need to query for the "subschemasubentry" attribute which can then be used to obtain specific...
Want to test your application on one computer with and without debugging turned on? You can, and you don't need to keep changing your settings in the CF Administrator. Here's how. The computer you use can always be accessed via two IP addresses - the actual address, and the localhost address...
When ColdFusion Custom Tags are used as tag pairs (with a begin and end tag) the tag code itself is called twice. ThisTag.ExecutionMode will be "start" when the tag is first called and "end" when called the second time. As a rule, all output generation and processing should occur in "end"...
Developers often embed debug output in their code during development, and then find themselves removing it (to see the results without extraneous output) and then reinserting it (to perform further testing). If you've ever found yourself doing this then you should take a look at the IsDebugMode()...
Single quotes are used to delimit SQL strings, and so single quotes within SQL statements must therefore be escaped. Fortunately ColdFusion escapes single quotes for you when needed (for example, when a variable passed to contains a string containing a quote). But what when you don't want text...
ColdFusion Studio, like many Windows applications (and even Windows itself) keeps a list of recently used files for rapid reopening. But one often overlooked feature is the ability to clean up that list so that it only contains valid (still existing) files. To use this feature select File, Recent...
ColdFusion Studio comes with templates that can be used to jump-start page creation. These are accessed via the File, New option. Studio also allows you to create your own templates which are automatically added to the New Document dialog. To do this, simple open a new document, enter the code, and...
The SQL AS clause is used to provide aliases for columns or expressions. While primarily used to name calculated columns there is another important use - renaming illegally named table columns. To do this enclose the bad column name within single quotes, like this: SELECT 'user login' AS UserLogin....
HTML comments are formatted as , CFML comments are formatted as . The difference? The extra hyphen before and after the comment text. But what if you mismatched the comments (two hyphens on one side and three on the other)? You'll not throw an error, but code will not function properly - and...