Lines 731-737
sub _parseletter_sth {
Link Here
|
731 |
($table eq 'biblio' ) ? "SELECT * FROM $table WHERE biblionumber = ?" : |
731 |
($table eq 'biblio' ) ? "SELECT * FROM $table WHERE biblionumber = ?" : |
732 |
($table eq 'biblioitems' ) ? "SELECT * FROM $table WHERE biblionumber = ?" : |
732 |
($table eq 'biblioitems' ) ? "SELECT * FROM $table WHERE biblionumber = ?" : |
733 |
($table eq 'items' ) ? "SELECT * FROM $table WHERE itemnumber = ?" : |
733 |
($table eq 'items' ) ? "SELECT * FROM $table WHERE itemnumber = ?" : |
734 |
($table eq 'issues' ) ? "SELECT * FROM $table WHERE itemnumber = ?" : |
734 |
($table eq 'issues' ) ? "SELECT *, CAST(date_due AS DATE) AS date_due_without_time FROM $table WHERE itemnumber = ?" : |
735 |
($table eq 'old_issues' ) ? "SELECT * FROM $table WHERE itemnumber = ? ORDER BY timestamp DESC LIMIT 1" : |
735 |
($table eq 'old_issues' ) ? "SELECT * FROM $table WHERE itemnumber = ? ORDER BY timestamp DESC LIMIT 1" : |
736 |
($table eq 'reserves' ) ? "SELECT * FROM $table WHERE borrowernumber = ? and biblionumber = ?" : |
736 |
($table eq 'reserves' ) ? "SELECT * FROM $table WHERE borrowernumber = ? and biblionumber = ?" : |
737 |
($table eq 'borrowers' ) ? "SELECT * FROM $table WHERE borrowernumber = ?" : |
737 |
($table eq 'borrowers' ) ? "SELECT * FROM $table WHERE borrowernumber = ?" : |
738 |
- |
|
|