Hi Kathy -
I just checked and this report should run perfectly... Actually I just tested
it on your system.
When you see an error like that - usually that means there was a space in-front
of the 'SELECT'. That will throw that error.
I've added it to your system it's report id #1085.
-Brendan
On Jul 19, 2011, at 2:04 PM, Kathy Rippel wrote:
> I am trying to do a report of all items in a certain location that is NOT
> suppressed.
>
> I went to the SQL report library and found the report by Chris Hobbs called
> Bibs Suppressed in OPAC. I figure if I can get that to work I can probably
> tweak it for the rest.
>
> 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
>
> The following error was encountered:
> The database returned the following error:
> 1
> Please check the log for further details.
>
> I don't have access to the log, as far as I know.
>
> Here is the report, please let me know if there is something wrong with it.
> We are now using Community Koha.
>
>
> 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')
>
> Kathy
>
> Kathleen D. Rippel
> Dept. Head/Consultant--Resource Access and Sharing
> Central Kansas Library System
> 1409 Williams
> Great Bend, KS 67530
>
> (620-792-4865) phone
> (800-362-2642) toll-free, KS
> (620-792-5495) fax
>
> [email protected]
> ********************************************************************************************
> I'm currently reading: The game of kings, by Dorothy Dunnett.
> I'm currently listening to: The astonishing life of Octavian Nothing. Vol. 2,
> The kingdom on the waves, by M. T. Anderson.
> _______________________________________________
> Koha mailing list http://koha-community.org
> [email protected]
> http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________
Koha mailing list http://koha-community.org
[email protected]
http://lists.katipo.co.nz/mailman/listinfo/koha
