#CreateODBCDate(Now())# - Put current date into Database (ODBC format)

Do not use reserved words as database column names (e.g. 'Text', 'Date') as this will confuse SQL.

Using tags to convert to all uppercase or all lowercase are slow.

Use <CFTRANSACTION> tags to prevent database modifiction on a botched query.

Use the pipe (|) as a delimiter for lists as it cannot be submitted in a form.

Using a <CFLOCATION> causes CFCOOKIE functions within the template not to be commited (EX: Clearing cookies in template may not happen if followed by CFLOCATION).

Query Attributes:

• QueryName.RecordCount - Returns the number of records returned from a query.
• QueryName.ColumnList - Reurns a comma delimited list of the column names in a query.
• QueryName.CurrentRow - Returns the order number of the current record when looping through a query using CFLOOP or CFOUTPUT.

Inserting the pipe character (|) into a MS Access database. MS Access uses pipes to process experssions embedded in data strings. This feature will cause an error if you try to insert a string that contains a pipe into the database. Here is the work-around:

<CFSET NewFieldValue=Replace (#StringWithVerticalBars#,"|","|Chr$(124)|","ALL")>

This will prep the string so that it will insert successfully.

Configuring CF 3.0 - 4.0: In the Control Panel - Services, go into the startup options for the CF application service. Make sure that the Interact with desktop checkbox is off.

ListQualify (CF 4.0.1) - Qualifies lists