Thanks to all the responses - 

Jon, I will go back and double check my SQL as I was a bit surprised as well. The query doesn't "break" as such, but takes as long as it does when using a subquery (which I want to avoid, because on our moderately spec'd system the subquery takes seconds to return, while the join comes back quick). But certainly there is something amiss when column specification buggers things up.

Everybody else, I guess that Voyager is (ab)used in so many different ways by so many institutions that just about any usage scenario is possible. I guess I was interested if other people would be interested in displaying this information in the holdings tab. From what I'm hearing, the answer is no, so I won't bother submitting a patch.

Steve

On 27/11/2007, at 2:49 AM, Doran, Michael D wrote:

> While I doubt many (any?) Voyager libraries have their whole catalog
> without item records (since I don't think you wouldn't be able to
> circulate them via Voyager),

I believe that there may be some union/national catalog implementations of Voyager that are totally sans item records.  Not the norm, to be sure.

-- Michael

# Michael Doran, Systems Librarian
# University of Texas at Arlington
# 817-272-5326 office
# 817-688-1926 cell
# doran@uta.edu
# http://rocky.uta.edu/doran/



-----Original Message-----
From: vufind-general-bounces@lists.sourceforge.net on behalf of Edward Corrado
Sent: Mon 11/26/2007 8:56 AM
To: Steven McPhillips
Cc: vufind-general@lists.sourceforge.net
Subject: Re: [VuFind-General] items and mfhds in Voyager



Steven McPhillips said the following on 11/25/2007 11:33 PM:
> Hi list,
>
> I've been informed that in my institution it is permissible for 
> mfhd's to exist without attached item records but still display on 
> the OPAC. I've got a librarian's explanation in my inbox somewhere, 
> but the reasoning behind this doesn't matter so much.
>
> What I am interested in is whether this is totally different from 
> other Voyager sites.
Steven,

While I doubt many (any?) Voyager libraries have their whole catalog
without item records (since I don't think you wouldn't be able to
circulate them via Voyager), it is probably not as uncommon for Voyager
libraries as one would think to have Holdings without Items. I have
heard of this sometimes with reference and other non-circulating
books/gov docs, but more often this is done for holdings without a
physical item. For example, e-journals, databases, Web sites, e-books, etc.

Edward



--
Edward M. Corrado
http://www.tcnj.edu/~corrado/
Systems Librarian
The College of New Jersey
403E TCNJ Library
PO Box 7718 Ewing, NJ 08628-0718
Tel: 609.771.3337  Fax: 609.637.5177
Email: corrado@tcnj.edu


-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
VuFind-General mailing list
VuFind-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/vufind-general




-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/_______________________________________________
VuFind-General mailing list
VuFind-General@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/vufind-general




----
Steven McPhillips <smcphillips@nla.gov.au>
IT Business Systems
National Library of Australia