The ColdFusion CGI.HTTP_USER_AGENT variable contains a client identification string - text submitted by the web browser (or any other client). You may inspect this variable to determine what browser is being used (Netscape, Internet Explorer, etc.) and even non Web browsers (for example, WAP...
Working with large files? You can place bookmarks in strategic locations in the code to facilitate rapid return to those locations. To set a bookmark (or to remove one) click Ctrl-K, to jump between bookmarks click Ctrl-Shift-K. (There are also menu options for these under Edit). (Applies to:...
Unless ColdFusion add-on components (like CFX tags) are multi-thread safe, concurrent access to them should be prevented. This can be accomplished using , ensuring that all calls to the components use the same lock name. (Applies to: ColdFusion 4 (or later))
By default, ColdFusion Studio lists all Web files in the File tab. To change the filter (to include just documents, just images, or all files) right click in the File window, and select Filter. (Applies to: ColdFusion Studio All)
Non-printable characters in your code could cause problems - generating strange error codes that can be difficult to track down. ColdFusion Studio can help you find these extraneous characters. Simple click the Show Hidden Characters button (in the Editor Toolbar) to display all characters, even...
If you are processing or comparing numbers, make sure that they really are just numbers - with no leading 0's or spaces. One simple way to do this is to pass the value to Val() which returns the numeric value at the start of a string. (Applies to: ColdFusion All)
There is often more than one way to perform SQL operations, particularly more complex operations. And there is rarely a definitive right or wrong way. Performance can be affected by the type of operation, the DBMS being used, the amount of data in the tables, whether or not indexes and keys are...
Want to delete all data in a table? You can use DELETE FROM TABLE, but that is slow because changes are logged. A faster solution is to issue a TRUNCATE TABLE command which is faster because no logging occurs (and if really intent to delete all the data in a table, logging is probably not that...
Good DBMS's support the use of triggers (blocks of SQL code that execute when an event occurs), and constraints (rules associated with datatypes or columns). Both can (and should) be used to enforce data integrity and consistency, but as a rule, constraints execute quicker than triggers. (Applies...
Need to export or import data from one database table to another? Two SQL statements can be used to simplify these operations. Use SELECT INTO to export data, and use INSER SELECT to import data. (Applies to: ColdFusion All)