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?
Chris -- Chris Hobbs Director, Technology New Haven Unified School District 2011/7/19 Kathy Rippel <[email protected]> > 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
