Bugzilla – Attachment 3129 Details for
Bug 5230
MARC export by call number range results in a zero byte file
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
patch
bug5230.patch (text/plain), 1.99 KB, created by
Nicole C. Engard
on 2011-02-11 13:35:05 UTC
(
hide
)
Description:
patch
Filename:
MIME Type:
Creator:
Nicole C. Engard
Created:
2011-02-11 13:35:05 UTC
Size:
1.99 KB
patch
obsolete
>From: D Ruth Bavousett <ruth@bywatersolutions.com> >To: dev@bywatersolutions.com >Cc: D Ruth Bavousett <ruth@bywatersolutions.com> >Subject: [PATCH] Bug 5230: Call number ranges in export don't give expected results. >Date: Thu, 10 Feb 2011 21:01:14 -0500 >Message-Id: <1297389674-2671-1-git-send-email-ruth@bywatersolutions.com> >X-Mailer: git-send-email 1.5.6.5 >X-Original-Sender: ruth@bywatersolutions.com >X-Original-Authentication-Results: mx.google.com; spf=neutral (google.com: > 72.96.176.230 is neither permitted nor denied by best guess record for domain > of dev01@drb) smtp.mail=dev01@drb >Precedence: list >Mailing-list: list dev@bywatersolutions.com; contact dev+owners@bywatersolutions.com >List-ID: <dev.bywatersolutions.com> >List-Help: <http://www.google.com/support/a/bywatersolutions.com/bin/static.py?hl=en_US&page=groups.cs>, > <mailto:dev+help@bywatersolutions.com> > >If you entered low number and high number, you got only items that *exactly* matched either entry (if any). >If you enter only a low number, you got everying *lower* than that. >If you enter only a high number, you get everything *higher* than that. > >This was a greater-than-less-than problem. >--- > tools/export.pl | 4 ++-- > 1 files changed, 2 insertions(+), 2 deletions(-) > >diff --git a/tools/export.pl b/tools/export.pl >index a1e9a22..4d23d08 100755 >--- a/tools/export.pl >+++ b/tools/export.pl >@@ -101,12 +101,12 @@ if ($op eq "export") { > } > > if ( $start_callnumber ) { >- $query .= " AND biblioitems.biblionumber = items.biblionumber AND itemcallnumber <= ? "; >+ $query .= " AND biblioitems.biblionumber = items.biblionumber AND itemcallnumber >= ? "; > push @sql_params, $start_callnumber; > } > > if ( $end_callnumber ) { >- $query .= " AND biblioitems.biblionumber = items.biblionumber AND itemcallnumber >= ? "; >+ $query .= " AND biblioitems.biblionumber = items.biblionumber AND itemcallnumber <= ? "; > push @sql_params, $end_callnumber; > } > if ( $start_accession ) { >-- >1.5.6.5 >
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 5230
: 3129