• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

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 a limit on the length of SQL query statements?
A3: Longer query statements require more processing time from ColdFusion, but there's no limit on length. The queries illustrated in this chapter are very short; more sophisticated ColdFusion apps will use queries that might cover 20 or more lines of code.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint