Changeset 13156
- Timestamp:
- 2006-10-20T14:59:04+13:00 (18 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/cic-hcap/perllib/plugins/CICPlug.pm
r13152 r13156 513 513 514 514 # Prepare SQL statement for getting the Place construction dates 515 my $place_construction_dates_sql_statement = "SELECT Prefix,Date,Note,Architect_Name FROM tblConstruction_and_Dates WHERE Entry_ID=? ";515 my $place_construction_dates_sql_statement = "SELECT Prefix,Date,Note,Architect_Name FROM tblConstruction_and_Dates WHERE Entry_ID=? ORDER BY Date"; 516 516 my $place_construction_dates_sql_handle = $dbh->prepare($place_construction_dates_sql_statement); 517 517 … … 532 532 533 533 # Prepare SQL statement for getting the Place functions 534 my $place_functions_sql_statement = "SELECT Function,Year,Prefix FROM tblFunction_and_dates WHERE Entry_ID=? ";534 my $place_functions_sql_statement = "SELECT Function,Year,Prefix FROM tblFunction_and_dates WHERE Entry_ID=? ORDER BY Year"; 535 535 my $place_functions_sql_handle = $dbh->prepare($place_functions_sql_statement); 536 536 $place_functions_sql_handle->{LongReadLen} = 65536;
Note:
See TracChangeset
for help on using the changeset viewer.