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


Q1:When I create a column alias, is it saved anywhere?
A1: No. Column aliases are relative to the template file in which they're created. To save a column alias so that it can be referenced throughout your applications, use a table view.
Q2:Why do I get SQL errors when I use aggregate functions?
A2: Some aggregate functions will work only with the number data type and will return errors if they encounter a text field. Check your data types carefully before using aggregate functions.
Q3:When I use a table join, why don't I have to use the table prefixes in my <CFOUTPUT>section?
A3: Because the join does this for you. orders.name becomes name, and so on. ColdFusion returns the results of a join exactly as it would the results from any standard SQL query.
Q4:How many tables can I join in a single query?
A4: In theory, some applications will let you join data from up to 23 tables. In practice, however, more than three or four joins on medium-to-large sized tables will start to tax your server's processor.
Q5:After I've created a view, can I use SQL's UPDATEand INSERTcommands to change data that appears in the view?
A5: Yes, but remember that you are only changing the records selected by the view, not all the records in the original table.
Q6:Stored procedures sound pretty cool. Where can I learn more?
A6: Check your database software's docs for details on defining and testing stored procedures. In ColdFusion's documentation, look for the discussion of the <CFSTOREDPROC> tag.



Not a subscriber?

Start A Free Trial

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