Re: Sorting data returned from DBI ...

"Now I want to sort the table so that it is ordered by city, last name, first name instead of just by city."

So, just modify your SQL query to do exactly that....

my $sql ='SELECT city, last_name, first_name FROM employees ORDER BY c
+ity, last_name, first_name';
[download]

Simple ;)

Comment on Re: Sorting data returned from DBI ... Download Code

Replies are listed 'Best First'.
Re^2: Sorting data returned from DBI ... by chinamox (Scribe) on Dec 10, 2006 at 07:13 UTC
I have learned that Perlmonks is an excellent resource for situations where I catch myself thinking "there has got to be a better way to do this..." Thank you for the help, no matter how simple it might have been ;) -mox	[reply]
Re^3: Sorting data returned from DBI ... by Devanchya (Beadle) on Dec 10, 2006 at 14:31 UTC
chinamox, If you really want to delve deeper, and school projects are always great for this if you have the time, look at your program and decide a feature you would like to improve. Looking at the code, rewrite it using the fetchrow_hashref and fetchrow_hasharray DBI option. You can see how they act different from the bind statement, and how Hashref in this case will make easier to work with your data. Right now if you want to add a column to your table, you have to update the binding. What if you add a column to your data, and it just appears in teh hashref automattically. note there is some danger here in making a huge hashref with only 2 varibles you are going to use. If you do this though, need ot check out the actual SQL statement... This is a CGI program, you may want to look at Javascript to allow it to be sorted dynamically on the site. Or you can also look at CGI::AJAX, which are a set of commands to refresh data with out refreshing the whole page. My main point is: Just because the book or professor showed you how to do it one way, does not mean that is the best way.. -- Even smart people are dumb in most things...	[reply]