March 12, 2001
All ColdFusion developers know that CF variables may be used in SQL statements, and most have used them in WHERE clauses as well as in INSERT and UPDATE statements. But what many developers do not know is that any part of the SQL string may be created using variables, in fact, the entire SQL...
March 11, 2001
Looking for a way for force a refresh of cached queries? Here's an undocumented CFML tag that may help - . Call this tag and every cached query (in all applications and for all datasources) will be cleared forcing them to be refreshed when next used. But, as this is an undocumented tag, it could...
March 10, 2001
WAP content may not contain dollar signs ($) as this character has special meaning within WML code - it is used to prefix WML variables. To escape dollar signs properly within your ColdFusion code use the Replace() statement like this: Replace(var, "$", "$$", "ALL"). (Applies to: ColdFusion All)
March 9, 2001
ColdFusion supports the creation of Custom Tag families - parent and child tags that together form a complete tag set. CFML includes tags and functions that are used to bridge the gap between these tags so that data can be shared (or published) as needed. But one behavior that baffles most...
March 8, 2001
allows you to send e-mail formatted as HTML. Many developers find this feature to be very compelling as it allows for sophisticated formatting and layout, and even embedded forms. However, as a rule, do not generate HTML e-mail unless you know that the recipient's mail client can support it (many...
March 7, 2001
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...
March 6, 2001
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...
March 5, 2001
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...
March 4, 2001
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"...
March 3, 2001
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()...