Contents > Developing ColdFusion MX Applications > Introduction to Databases and SQL > Using SQL > Basic SQL syntax elements SQL notes and considerations

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.

Contents > Developing ColdFusion MX Applications > Introduction to Databases and SQL > Using SQL > Basic SQL syntax elements SQL notes and considerations

ColdFusion 9 | ColdFusion 8 | ColdFusion MX 7 | ColdFusion MX 6.1 | ColdFusion MX | Forums | Developer Center | Bug Reporting

Version 6.1

Comments are no longer accepted for ColdFusion MX 6.1. ColdFusion 8 is the current version.