Have you ever come across a column or a table that uses a reserved keyword. ColdFusion has a list of reserved keywords, which are typically part of the SQL language and are not normally used for names of columns or tables. To escape a reserved keyword for a column name or table name, enclose it in brackets.

ColdFusion supports the following SELECT statement examples:

SELECT [from] FROM parts;
SELECT [group].firstname FROM [group];
SELECT [group].[from] FROM [group];
ColdFusion does not support nested escapes, such as in the following example:
SELECT [[from]] FROM T;
The following table lists ColdFusion reserved keywords:

Escaping Reserved Keywords

 

This entry was posted on December 13, 2006 at 1:06 AM and has received 1009 views. Comments 0 | Print this entry.