MACROMEDIA ColdFusion MX, Develop Manual

Page: 417 / 860

Using SQL 417
Case sensitivity with databases
ColdFusion MX is a case-insensitive programming environment. Case insensitivity means the
following statements are equivalent:
<cfset foo="bar">
<CFSET FOO="BAR">
<CfSet FOO="bar">
However, many databases, especially UNIX databases, are case-sensitive. Case sensitivity means
that you must match exactly the case of all column and table names in SQL queries.
For example, the following queries are not equivalent in a case-sensitive database:
SELECT LastName FROM EMPLOYEES
SELECT LASTNAME FROM employees
In a case-sensitive database, employees and EMPLOYEES are two different tables.
For information on how your database handles case, see the product documentation.
SQL notes and considerations
When writing SQL in ColdFusion, keep the following guidelines in mind:
•
There is a lot more to SQL than what is covered here. It is a good idea to purchase one or
several SQL guides for reference.
•
The data source, columns, and tables that you reference must exist in order to perform a
successful query.
•
Some DBMS vendors use nonstandard SQL syntax (known as a dialect) in their products.
ColdFusion does not validate the SQL; it is passed on to the database for validation, so you are
free to use any syntax that is supported by your database. Check your DBMS documentation
for nonstandard SQL usage.
<> Not equal to
< Less than
> Greater than
<= Less than or equal to
>= Greater than or equal to
+ Addition
- Subtraction
/ Division
* Multiplication
Operator Description