<div>thnaks for guidance,</div>
<div>&nbsp;</div>
<div>i will try out that.</div>
<div>thanks again.</div>
<div>&nbsp;</div>
<div>Lalitanand.<br><br>&nbsp;</div>
<div><span class="gmail_quote">On 8/2/06, <b class="gmail_sendername">Steven F. Baljkas</b> &lt;<a href="mailto:baljkas@mts.net">baljkas@mts.net</a>&gt; wrote:</span>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Wednesday, August 2, 2006&nbsp;&nbsp;&nbsp;&nbsp;01:11 CDT<br><br>Hi, Lalitanand,<br><br>Just one other thing I think Stephen Hedges missed mentioning, just in case someone else hasn't told you already ...
<br><br>*** When entering ISBNs for searches, you do NOT want to include the hyphens. ISBNs are encoded hyphenless in the 020 field. ***<br><br>Some systems seem to be able to cope with hyphens being included in search strings, but LC, in my experience, definitely does not. Probably won't matter in the specific case of the book you are referencing since no similar ISBN seems to occur in any of the probable match records in LC.
<br><br>HTH.<br><br>Cheers,<br>Steven F. Baljkas<br>library tech at large<br>Koha neophyte<br>Winnipeg, MB, Canada<br><br><br>============================================================<br>From: &quot;lalitanand dandge&quot; &lt;
<a href="mailto:dandgelb@gmail.com">dandgelb@gmail.com</a>&gt;<br>Date: 2006/08/01 Tue PM 11:37:28 CDT<br>To: &quot;Stephen Hedges&quot; &lt;<a href="mailto:st.hedges@gmail.com">st.hedges@gmail.com</a>&gt;<br>CC: <a href="mailto:koha@lists.katipo.co.nz">
koha@lists.katipo.co.nz</a><br>Subject: Re: [Koha] Z39.50<br><br>Hi<br>thanks..<br>I started Z3950 daemon,<br>and i am using,<br>mysql&nbsp;&nbsp;Ver 14.7 Distrib 4.1.15, for pc-linux-gnu (i386) using readline 4.3<br><br>thanks and regards,
<br><br>Lalitanand.<br><br>On 8/1/06, Stephen Hedges &lt;<a href="mailto:st.hedges@gmail.com">st.hedges@gmail.com</a>&gt; wrote:<br>&gt;<br>&gt; I'm guessing that:<br>&gt; 1) you have not started the Z3950 daemon<br>&gt; 2) you are using MySQL 5
<br>&gt;<br>&gt; Stephen<br>&gt;<br>&gt; On 8/1/06, lalitanand dandge &lt;<a href="mailto:dandgelb@gmail.com">dandgelb@gmail.com</a>&gt; wrote:<br>&gt; &gt; Hi<br>&gt; &gt; I installed Koha2.2.5 on my debian system.<br>&gt; &gt; I want to import the marc tags from the Library of Congress or other
<br>&gt; z39.50<br>&gt; &gt; server,<br>&gt; &gt; I added the Z3950 server: the entries I added are:<br>&gt; &gt; hostname: <a href="http://z3950.loc.gov">z3950.loc.gov</a><br>&gt; &gt; Port No: 7090<br>&gt; &gt; and Database name: voyager
<br>&gt; &gt; but the problem i am facing is:<br>&gt; &gt; when i do search on particular ISBN no. like 0-07-049543 (Java Complete<br>&gt; &gt; Reference)<br>&gt; &gt; then the result i get is: Nothing found:<br>&gt; &gt; (the url shows
<br>&gt; &gt; &quot;<br>&gt; <a href="http://localhost:8080/cgi-bin/koha/z3950/search.pl?bibid=&amp;isbn=0-07-049543">http://localhost:8080/cgi-bin/koha/z3950/search.pl?bibid=&amp;isbn=0-07-049543</a><br>&gt; &quot;<br>&gt; &gt; and then changes to &quot;
<br>&gt; &gt;<br>&gt; <a href="http://localhost:8080/cgi-bin/koha/z3950/search.pl?bibid=&amp;random=249094171.290384">http://localhost:8080/cgi-bin/koha/z3950/search.pl?bibid=&amp;random=249094171.290384</a><br>&gt; &quot;)
<br>&gt; &gt; please tell me how to configure and check my koha system with z3950<br>&gt; support.<br>&gt; &gt;<br>&gt; &gt; another problem I am getting is,<br>&gt; &gt; when i search for patrons it gives the list of members page
<br>&gt; &gt; &quot;<a href="http://localhost:8080/cgi-bin/koha/members/member.pl">http://localhost:8080/cgi-bin/koha/members/member.pl</a> &quot;<br>&gt; &gt; then after clicking issue: i get<br>&gt; &gt; &quot;<a href="http://localhost:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1">
http://localhost:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1</a>&quot;<br>&gt; &gt; page<br>&gt; &gt;&nbsp;&nbsp;there is link &quot;details&quot; of the borrower, i get<br>&gt; &gt; &quot;<br>&gt; <a href="http://localhost:8080/cgi-bin/koha/members/moremember.pl?borrowernumber=1">
http://localhost:8080/cgi-bin/koha/members/moremember.pl?borrowernumber=1</a><br>&gt; &gt; &quot;<br>&gt; &gt; this page, but the borrower details fields are blank (it does not show<br>&gt; name<br>&gt; &gt; and other things)
<br>&gt; &gt; the error i get while doing these steps in the koha-error_log is<br>&gt; &gt;<br>&gt; &gt; [Tue Aug 01 12:38:42 2006] [error] [client localhost] 2007-07-19 at<br>&gt; &gt; /usr/local/koha/intranet/cgi-bin/circ/circulation.pl line
<br>&gt; &gt; 127., referer:<br>&gt; &gt; <a href="http://202.141.152.81:8080/cgi-bin/koha/members/member.pl">http://202.141.152.81:8080/cgi-bin/koha/members/member.pl</a><br>&gt; &gt;<br>&gt; &gt; [Tue Aug 01 12:39:02 2006] [error] [client localhost] 2007-07-19 at
<br>&gt; &gt; /usr/local/koha/intranet/cgi-bin/circ/circulation.pl line<br>&gt; &gt; 127., referer:<br>&gt; &gt; <a href="http://202.141.152.81:8080/cgi-bin/koha/members/member.pl">http://202.141.152.81:8080/cgi-bin/koha/members/member.pl
</a><br>&gt; &gt;<br>&gt; &gt; [Tue Aug 01 12:40:56 2006] [error] [client localhost] DBD::mysql::st<br>&gt; execute<br>&gt; &gt; failed: You have an error in your SQL syntax; check the manual that<br>&gt; &gt; corresponds to your MySQL server version for the right syntax to use
<br>&gt; near<br>&gt; &gt; 'and reserves.borrowernumber&nbsp;&nbsp;= borrowers.borrowernumber, referer:<br>&gt; &gt; <a href="http://localhost:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1">http://localhost:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1
</a><br>&gt; &gt;<br>&gt; &gt;&nbsp;&nbsp;[Tue Aug 01 12:40:56 2006] [error] [client localhost] \t\t\t\t\tand<br>&gt; &gt; reserves.biblio' at line 2 at<br>&gt; &gt; /usr/local/koha/intranet/modules/C4/Reserves2.pm line 147.,<br>&gt; &gt; referer:
<br>&gt; &gt;<br>&gt; <a href="http://202.141.152.81:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1">http://202.141.152.81:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1</a><br>&gt; &gt;<br>&gt; &gt; [Tue Aug 01 12:40:56 2006] [error] [client localhost] DBD::mysql::st
<br>&gt; &gt; fetchrow_hashref failed: fetch() without execute() at<br>&gt; &gt; /usr/local/koha/intranet/modules/C4/Reserves2.pm line 149.,<br>&gt; &gt; referer:<br>&gt; &gt;<br>&gt; <a href="http://202.141.152.81:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1">
http://202.141.152.81:8080/cgi-bin/koha/circ/circulation.pl?findborrower=1</a><br>&gt; &gt;<br>&gt; &gt; So please help me in this regard,<br>&gt; &gt; How to configure my koha system to enable the marc record search using
<br>&gt; z3950<br>&gt; &gt; and how to get the above mentioned errors sorted out.<br>&gt; &gt;<br>&gt; &gt; thanks<br>&gt; &gt;<br>&gt; &gt; lalitanand.<br>&gt; &gt;<br>&gt; &gt;<br>&gt; &gt;<br>&gt; &gt; --<br>&gt; &gt; &quot;Talk is cheap. Show me the code. Think Open, use Open Source!&quot;
<br>&gt; &gt; Visit &amp; Register at <a href="http://www.ossrc.org.in">http://www.ossrc.org.in</a><br>&gt; &gt; _______________________________________________<br>&gt; &gt; Koha mailing list<br>&gt; &gt; <a href="mailto:Koha@lists.katipo.co.nz">
Koha@lists.katipo.co.nz</a><br>&gt; &gt; <a href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>&gt; &gt;<br>&gt; &gt;<br>&gt; &gt;<br>&gt;<br><br><br><br>--<br>&quot;Talk is cheap. Show me the code. Think Open, use Open Source!&quot;
<br>Visit &amp; Register at <a href="http://www.ossrc.org.in">http://www.ossrc.org.in</a><br><br>============================================================<br><br><br><br>_______________________________________________<br>
Koha mailing list<br><a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br><a href="http://lists.katipo.co.nz/mailman/listinfo/koha">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br><br><br><br></blockquote>
</div><br><br clear="all"><br>-- <br>&quot;Talk is cheap. Show me the code. Think Open, use Open Source!&quot;<br>Visit &amp; Register at <a href="http://www.ossrc.org.in">http://www.ossrc.org.in</a>