If you are using Verity's new K2 full text searching engine you may use one of several new functions available in ColdFusion 5: GetK2ServerCollections() returns a comma delimited list of collections, GetK2ServerDocCount() returns the total number of available documents, GetK2ServerDocLimit()...
Individual data sources may be temporarily disabled using the ColdFusion Administrator. You may also perform this programmatically using the undocumented CFusion_Disable_DBConnections() function. This function takes two parameter, the first is the name of the data source, and the second is a TRUE...
ColdFusion pools database connections to improve performance. Data source connections may be dropped as needed using the ColdFusion Administrator (this process also unlocks any locked files, for example, Microsoft Access MDB files), but you can also do this programmatically using the undocumented...
Want to check that a data source has been defined and is useable? You could just try to use it and catch any generated errors. Or you could use the undocumented CF_IsColdFusionDataSource() function which takes the name of a data source as a parameter (within quotes) and returns TRUE if it is...
Want to check that an SMTP server is accessible before using it to send mail? Use the undocumented CFusion_VerifyMail() function which takes three parameters - the server to be checked (IP address or DNS name), the port, and a timeout interval. CFusion_VerifyMail() returns a string that may be...
When using Regular Expressions to match a block of text containing repeated characters (or sets of characters), remember the following rules: an expression followed by + matches one or more occurrences of that expression, an expression followed by * matches zero or more occurrences of that...
When using Regular Expressions characters match themselves unless they are special characters (ones that have special meanings within the expression). In CFML Regular Expressions these are + * ? . [ ^ $ ( ) { | and . To refer to any of these characters as themselves you must escape them by...
When working with Regular Expressions you may want to know the exact positions of all matched subexpressions. Both REFind() and REFindNoCase() support an optional fourth attribute - a flag specifying whether or not to return this information. Set this parameter to TRUE to force ColdFusion to return...
CFML supports the use of backreferences in Regular Expression operations. Using backreferences it is possible to refer to matched expressions in both search and replace operations. When using backreferences you must enclose the string in parentheses (within regular double quotes) or ColdFusion will...
The CFML RegEx function (REFind(), REReplace(), etc.) should not be used with text more than about 20K in size. If you need to manipulate extremely large blocks of data you should break the text into smaller pieces, apply the regular expressions to them, and then concatenate the results when done....