[OPEN-ILS-GENERAL] Problems with export

[Bill Ott]

acn.record-bre.id

Unless that's a typo only in email and not a copy/paste, you need an = not -.




On 08/10/2011 07:12 AM, Armen wrote:
>
> Dear Evergreen staff
>
> I am from the Fundamental Scientific Library of Armenia. We use Evergreen 2.0.5  and now we need toimport 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 addresshttp://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.
>   
> Thanks in advance
> Armen
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://libmail.georgialibraries.org/pipermail/open-ils-general/attachments/20110810/33b51a31/attachment.htm>