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

Day 10. Enhancing Output with Tables and... > Using SQL's DISTINCT to Create Dynam...

Using SQL's DISTINCT to Create Dynamic Index Links

To add index links dynamically, we can use the DISTINCT command in our template's SQL statement. Recall from Listing 5.20 in Day 5 that DISTINCT tells ColdFusion to get only one item of each type. For example, this query

SELECT DISTINCT condition FROM 8tracks


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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