<html><head></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; ">Hi Kathy -<div><br></div><div>I just checked and this report should run perfectly... Actually I just tested it on your system.</div><div><br></div><div>When you see an error like that - usually that means there was a space in-front of the 'SELECT'. That will throw that error.</div><div><br></div><div>I've added it to your system it's report id #1085.</div><div><br></div><div>-Brendan</div><div><br><div><div>On Jul 19, 2011, at 2:04 PM, Kathy Rippel wrote:</div><br class="Apple-interchange-newline"><blockquote type="cite"><div>
<font size="3">I am trying to do a report of all items in a certain
location that is NOT suppressed.<br><br>
I went to the SQL report library and found the report by Chris Hobbs
called </font><h4><b>Bibs Suppressed in OPAC</b>. I figure if I can get
that to work I can probably tweak it for the
rest.</h4><font size="3">However, I can't get this report to run, as is.
I've tried some minor changes, but I keep getting an error message that
says<br><br>
<b>The following error was encountered:<br>
</b>The database returned the following error: <br>
1<br>
Please check the log for further details. <br><br>
I don't have access to the log, as far as I know.<br><br>
Here is the report, please let me know if there is something wrong with
it. We are now using Community Koha.<br><br>
<br>
</font><pre> SELECT concat( '<a
href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=',
biblio.biblionumber, '">', biblio.title, '</a>' ) AS title,
biblio.author
FROM biblioitems
JOIN biblio ON ( biblioitems.biblionumber = biblio.biblionumber )
WHERE ExtractValue( marcxml,
'//datafield[@tag="942"]/subfield[@code="n"]' )
IN ('Y', '1')
</pre><font size="3">Kathy<br>
</font></div>
<br>
<div>
<font face="Garamond" size="4">Kathleen D. Rippel<br>
Dept. Head/Consultant--Resource Access and Sharing<br>
Central Kansas Library System<br>
1409 Williams<br>
Great Bend, KS 67530<br><br>
(620-792-4865) phone<br>
(800-362-2642) toll-free, KS<br>
(620-792-5495) fax<br><br>
<a href="mailto:kdr@ckls.org">kdr@ckls.org</a><br>
</font><font size="3">
********************************************************************************************<br>
</font><font face="Garamond" size="4">I'm currently reading: The game of
kings, by Dorothy Dunnett.<br>
I'm currently listening to: The astonishing life of Octavian Nothing.
Vol. 2, The kingdom on the waves, by M. T. Anderson.</font><font size="3">
</font></div>
_______________________________________________<br>Koha mailing list <a href="http://koha-community.org">http://koha-community.org</a><br><a href="mailto:Koha@lists.katipo.co.nz">Koha@lists.katipo.co.nz</a><br>http://lists.katipo.co.nz/mailman/listinfo/koha<br></blockquote></div><br></div></body></html>