Unique Country Search

Our guests come from the following countries:

Notice that you never see the name of a country listed more than once, regardless of how many records contain that name. To see how this works, load the dbdisplay component into the RADpage window and study the source code. Notice that we have used two new tags: the dbselectfield tag specifies which field to use as the search field, and the dbdistinct tag further refines the search by stating that we are only interested in records with "distinct" or "unique" properties. This can be very useful when you want to limit the number of data records returned in a search.

As an exercise, try deleting the dbdistinct tag from the source code to see how it affects the search. Then re-insert the tag into its former place in the code to restore this page's original appearance.

As always, we encourage you to examine each of the component handles on this page to familiarize yourself with their operation before moving on to the next page.

Next