Applications: New DVD Functionality

March
10
2008
10:49 AM
I've made some improvements to the DVD Management application I recently completed. I noticed that most trilogy or series-based DVDs weren't displayed in chronological order by release date, and were instead listed alphabetically.

To remedy this, I split the title column into title and subtitle, and also added a year column to the database for each entry. The DVD titles are now sorted on a concatenation of DVD title, year, and subtitle so that all DVDs are listed in the correct order.

I also expanded the search functionality so that you can enter in years and return all movies for that year.