Changeset 13156

Timestamp:

2006-10-20T14:59:04+13:00 (18 years ago)

Author:

mdewsnip

Message:

Now sorts function and construction information by year.

File:

• trunk/cic-hcap/perllib/plugins/CICPlug.pm (modified) (2 diffs)

trunk/cic-hcap/perllib/plugins/CICPlug.pm

@@ -513 +513 @@
 
     # Prepare SQL statement for getting the Place construction dates
-    my $place_construction_dates_sql_statement = "SELECT Prefix,Date,Note,Architect_Name FROM tblConstruction_and_Dates WHERE Entry_ID=?";
+    my $place_construction_dates_sql_statement = "SELECT Prefix,Date,Note,Architect_Name FROM tblConstruction_and_Dates WHERE Entry_ID=? ORDER BY Date";
     my $place_construction_dates_sql_handle = $dbh->prepare($place_construction_dates_sql_statement);
 
@@ -532 +532 @@
 
     # Prepare SQL statement for getting the Place functions
-    my $place_functions_sql_statement = "SELECT Function,Year,Prefix FROM tblFunction_and_dates WHERE Entry_ID=?";
+    my $place_functions_sql_statement = "SELECT Function,Year,Prefix FROM tblFunction_and_dates WHERE Entry_ID=? ORDER BY Year";
     my $place_functions_sql_handle = $dbh->prepare($place_functions_sql_statement);
     $place_functions_sql_handle->{LongReadLen} = 65536;