From 2e1677d53b428bbf0d99d0090c919ef89adce547 Mon Sep 17 00:00:00 2001 From: Ben Ostrowsky Date: Tue, 24 Jan 2012 17:30:40 +0000 Subject: [PATCH] Added ContentReserve to the list of providers in insert_856_9 --- sql/base/base.sql | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/sql/base/base.sql b/sql/base/base.sql index 656015e..c4a409b 100644 --- a/sql/base/base.sql +++ b/sql/base/base.sql @@ -1078,7 +1078,7 @@ CREATE OR REPLACE FUNCTION migration_tools.insert_856_9 (TEXT, TEXT) RETURNS TEX my $marc = MARC::Record->new_from_xml($marcxml, 'UTF-8'); foreach my $field ( $marc->field('856') ) { - if ( scalar(grep( /(netlibrary|overdrive)\.com/i, $field->subfield('u'))) > 0 && + if ( scalar(grep( /(contentreserve|netlibrary|overdrive)\.com/i, $field->subfield('u'))) > 0 && ! ( $field->as_string('9') =~ m/$shortname/ ) ) { $field->add_subfields( '9' => $shortname ); $field->update( ind2 => '0'); -- 1.7.2.5