Q&A
| Q1: | Does my database software fully support all SQL commands? |
| A1: | In most cases, yes. ColdFusion uses the ANSI, or standard, set of SQL commands to maintain compatibility with most databases. In fact, your database software might even support special commands unique to that application. To use these extra commands, you'll need to make sure that you're using the correct ODBC driver for your database brand. Check your database app's documentation for details. |
| Q2: | Do SQL commands such as WHEREand SELECThave to be in all capital letters? |
| A2: | No, but it's not a bad idea to use this convention. When you're examining a query, the uppercase letters make it easy to distinguish between SQL commands and table fields, which use lowercase names. |
| Q3: | Is there ... |
Get Sams Teach Yourself ColdFusion® in 21 Days now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
