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


Q1:What other programs use ODBC? What are the advantages of these programs?
A1: ColdFusion is only one example of an ODBC-compatible application. Others include word processors, spreadsheet programs, address books, and mail programs. The advantages these programs have over their non-ODBC counterparts is that, as with ColdFusion, you can use them to generate documents from a database. For example, consider a mail program: With ODBC, you can link your mailer to a database and create an instant form mail to every name and address listed in a table.
Q2:Where are ColdFusion template files stored on my Web server?
A2: Older versions of CF required you to define a directory to hold your template files, but from version 3.0 on, you could place them anywhere in your Web directory structure—just as with standard HTML pages. As long as your templates use the cfm file extension, ColdFusion will recognize them.
Q3:Can multiple queries be used in a single ColdFusion template file?
A3: Yes, and in later sessions, I'll discuss specific advantages to doing this. In fact, queries can even be used to generate search parameters for other queries in the same template.
Q4:What happens when I place text and HTML markup outside a ColdFusion output section?
A4: It displays normally, just as it would in a standard HTML file. ColdFusion essentially ignores anything not appearing in a <CF> and simply returns it to the user's browser verbatim.
Q5:What happens if a ColdFusion query doesn't match with any records in a table?
A5: The template page displays normally, but the text within the <CFOUTPUT> tags doesn't appear. This has both advantages and disadvantages that I'll cover in later sections.



Not a subscriber?

Start A Free Trial

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