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 > > k...@ckls.org > ******************************************************************************************** > 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 > Koha@lists.katipo.co.nz > http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha