Another cool feature of <cfselect> is that you have the "selected" attribute. This allows you to choose what the default value is in the <cfselect> box, which can be very useful when returning numerous results from your query. For example, if you have a list of Countries in alphabetical order and you didn't want the user to have to scroll to the bottom of the list for "United States", you could specify it as your "selected" and it would be the default country in your list.
Let's say this query pulls the records "Abb" (abbreviation) and "Country" from a database. For the sake of this example, we will say that the abbreviation for United States is "US".
<cfquery datasource="#data# name="get_countries"> SELECT Abb, Country FROM Countries ORDER BY Abb </cfquery>
Then, use your <cfselect> tag to display all items returned from the query.