Q&A
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 ... |
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.