The SQL UPDATE and DELETE statements take WHERE clauses to restrict the data being updated or deleted. Failing to provide a WHERE clause causes the update or deletion of all rows in a table, and providing an incorrect WHERE clause could cause the updating and deleting of the wrong rows in a table....
The ColdFusion default page timeout value is specified in the ColdFusion Administrator. But that value can be overridden for specific pages using the "RequestTimeout" parameter which allows you to specify a timeout value in seconds. To do this, simply append RequestTimeout=value to the URL (just...
Data retrieved from a database is usually returned (to ColdFusion and any other database client) one row at a time. You can control the number of rows sent per request using the tag's BLOCKFACTOR attribute - the default is 1 and you can specify any number from 1 to 100. For example, if you retrieve...
Ever named a form field something like "order_date"? Don't. ColdFusion looks for specific field name suffixes to tell it to perform validation, and _date is one of those. Others to avoid are _eurodate, _integer, _float, _range, and _time. If your database column is named this way you'll...
The names of any database related entities (like databases, tables, columns, view, stored procedures) should be plain text and not contain any spaces or special characters (for example, hyphens and periods). Using these characters will create endless difficulties for client applications (like...
Need help with CFML function syntax? ColdFusion Studio 4 introduced a new feature called "function insight". To use this feature simple type the name of a function followed by the first ( and then wait a second - ColdFusion Studio will pop up an inline tip with the exact syntax and options for that...
Example applications and documentation do not belong on production sites (which is why they are an install option). As a rule, the less you have running on a server the less vulnerable it is. If you do need the CFDOCS directory installed for some reason, secure it (at the OS or Web server). The...
is used for file system management, as well as for processing uploaded files. File paths may be relative for some operations, but not for specifying the destination path when ACTION="UPLOAD". So how can you use relative paths? Simple pass the relative path to the ExpandPath() function and...
Need to authenticate users (forcing them to login and validating their password)? If you are using NT (or Win2K) and IIS, and your users have network accounts, then here's a really easy (and safe) way to perform authentication. Simply prevent anonymous access to the files or directory structure to...
ColdFusion 4.5 introduced a new Administrator option (on the Logging page) called "Log Slow Pages". This option lets you specify the expected request processing time for your site and any requests that take longer than this will be written to a log file. By default this option is not enabled, but...