On Wed, Aug 10, 2011 at 07:12:56AM -0400, Armen wrote: > I am from the Fundamental Scientific Library of Armenia. We use > Evergreen 2.0.5 and now we need to import a database of bibliographic > records from an older version of Ervergreen, namely 1.6.0.6. I have > clearly followed the instructions available at this address > http://docs.evergreen-ils.org/1.6/draft/html/exportingbibrecordsintoMARC.html. > However, after the command > > " SELECT DISTINCT bre.id FROM biblio.record_entry AS bre JOIN > asset.call_number AS acn ON acn.record-bre.id WHERE > bre.deleted='false' and ownling_lib=101 \g /home/opensrf/records.txt; > " > > the system pops out an error, namely this > > "argument of JOIN/ON must be type boolean, not type bigint". > > Please help me with this problem.
Try this: ... WHERE NOT bre.deleted AND ... > Thanks in advance > > Armen Paul. -- Paul Hoffman <p...@flo.org> Systems Librarian Fenway Libraries Online c/o Wentworth Institute of Technology 550 Huntington Ave. Boston, MA 02115 (617) 445-2914 (617) 442-2384 (FLO main number)