• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Day 19. Using Advanced SQL Techniques > Understanding Column Aliases

Understanding Column Aliases

In the introduction to SQL in Day 5, you learned that when you use <CFQUERY> to select records from a datasource, the selected records are returned as variable values corresponding to the field names in your table. Take a look at a sample Microsoft Access table in Figure 19.1.

Figure 19.1. A sample database table in Microsoft Access, designed and named with ColdFusion in mind.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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