ColdFusion developers use the CreateODBCDate(), CreateODBCTime(), and CreateODBCDateTime() extensively when working with dates and times in SQL statements - but those functions may not work if you are using native database drivers because those drivers may not understand the ODBC date format. If...
Having trouble getting ColdFusion to access files and directories on other servers on your network? It is likely a rights related problem. When ColdFusion is installed on NT (or Windows 2000) it is installed with standard system service access - this allows ColdFusion to access the server it is on,...
Trying to check tag sets to verify that they match correctly? Simply place your cursor in any tag and press Ctrl-M (for match). Studio will jump to the matching tag, and will jump back again if you press it again. If there is no match, or you end up on the wrong tag, you'll have found a coding...
and can often be used interchangeably. But if you find yourself writing long lists of statements, you might want to use might not be worth it), but as that list grows can be as much as 7 times faster than . (Applies to: ColdFusion 4 (or later))
Prior to ColdFusion 4.5 there was no simple way to send multiple e-mail attachments using the tag. In CF 4.5 that tags MIMEATTACH attribute still only supports a single attachment, but you can use multiple tags to attach multiple attachments. (Applies to: ColdFusion 4.5 (or later))
As of ColdFusion 4.5, ColdFusion Administrator settings are cached to improve performance. This is a good thing, unless you ever manipulated the Administrator settings directly (as my tag does). If you do manipulate these settings you'll need to force ColdFusion to reread the settings using the...
CLIENT and SESSION variables are different. SESSION variables supports complex data types (like arrays and structures), but they are limited to a single machine. CLIENT variables can be shared in a clustered environment, but they do not support complex data types. So how do you get the best of both...
Any time you perform an assignment or pass an attribute in ColdFusion you use NAME=VALUE pairs. ColdFusion allows spaces before or after the = sign, but other languages (most notably XML) do not. While there is nothing wrong with having spaces before or after the equals sign, it's best to get used...
ColdFusion lists are simple to use, but they are not as fast as arrays. In fact, array access is as much as three times faster than list access. So, while lists are simple to use, don't overuse them. (Applies to: ColdFusion 2 (or later))
When you define your data sources for use with ColdFusion, don't ever use the database administrator's login ("sa" on SQL Server for example). With administrative access you greatly increase the chance of someone executing rogue SQL statements (like DROP table). Give the data source just the access...