Do you know which version of mysql you are using? ExtractValue requires a minimum of mysql 5.1.5 to be used. I wonder if this is what is causing the error?<br><br>Chris<br><br clear="all"><span style="color:rgb(51, 102, 255)"><span style="color:rgb(0, 0, 0)">-- </span><br>
Chris Hobbs</span><br>Director, Technology<br>New Haven Unified School District<br><br>
<br><br><div class="gmail_quote">2011/7/19 Kathy Rippel <span dir="ltr"><<a href="mailto:kdr@ckls.org">kdr@ckls.org</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
<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/<a href="http://detail.pl?biblionumber=" target="_blank">detail.pl?biblionumber=</a>',
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>
<a href="tel:%28620-792-4865" value="+16207924865" target="_blank">(620-792-4865</a>) phone<br>
<a href="tel:%28800-362-2642" value="+18003622642" target="_blank">(800-362-2642</a>) toll-free, KS<br>
<a href="tel:%28620-792-5495" value="+16207925495" target="_blank">(620-792-5495</a>) fax<br><br>
<a href="mailto:kdr@ckls.org" target="_blank">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>_______________________________________________<br>
Koha mailing list <a href="http://koha-community.org" target="_blank">http://koha-community.org</a><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" target="_blank">http://lists.katipo.co.nz/mailman/listinfo/koha</a><br>
<br></blockquote></div><br>