Thanks, I'll try the various suggestions. I actually did the copy and paste in Koha. . . no text editor to blame. But there's the weirdness that goes on between a Mac and a PC (I use both on the same machine with VMware), and might possibly have copied from one to paste in the other. . . Sometimes I have so many windows open I forget where I am.
I'm sure the extra ExtractValue(b.marcxml didn't help! Cheers, E On Wed, May 21, 2014 at 4:15 PM, Paul A <[email protected]>wrote: > It could be just the way that my email client is formatting characters, > but you may have a problem with the " and ' (double and single quote > marks.) I read them below as “, †, and ’ > > Maybe you used a text editor that allows "curlies" rather than "straights"? > > Best -- Paul > > > At 05:57 PM 5/20/2014 +0100, Elaine Bradtke wrote: > >> I'll admit, I'm the queen of cut and paste. What I don't know about SQL >> would fill a book. >> >> Using a report I already have on hand: >> SELECT ExtractValue(b.marcxml, >> '//datafield[@tag="245"]/subfield[@code="a"]'), ExtractValue(b.marcxml, >> '//datafield[@tag="260"]/subfield[@code="a"]'),ExtractValue(b.marcxml, >> '//datafield[@tag="260"]/subfield[@code="c"]'), monthname(datecreated) AS >> month, year(datecreated) AS year, biblionumber AS biblionumber >> FROM biblio >> LEFT JOIN biblioitems b USING (biblionumber) >> WHERE datecreated BETWEEN <<Between (yyyy-mm-dd)>> AND <<and >> (yyyy-mm-dd)>> >> >> I tried to add some fields as per a request from one of our staff who >> would >> like a rather thorough list of items added to the catalogue within a time >> frame. >> >> SELECT ExtractValue(b.marcxml, >> '//datafield[@tag=“100†]/subfield[@code="a"]'), >> ExtractValue(b.marcxml, >> >> '//datafield[@tag="245"]/subfield[@code="a"]'), ExtractValue(b.marcxml, >> '//datafield[@tag="245"]/subfield[@code=“b†]’), >> ExtractValue(b.marcxml, >> '//datafield[@tag="245"]/subfield[@code=“c†]’), >> ExtractValue(b.marcxml, >> >> '//datafield[@tag="260"]/subfield[@code="a"]'), ExtractValue(b.marcxml, >> '//datafield[@tag=“773†]/subfield[@code=“t†]’), >> ExtractValue(b.marcxml, >> '//datafield[@tag=“773†]/subfield[@code=“g†]’), >> ExtractValue(b.marcxml, >> '//datafield[@tag="260"]/subfield[@code=“b†]’), >> ExtractValue(b.marcxml, >> >> '//datafield[@tag="260"]/subfield[@code="c"]'), ExtractValue(b.marcxml, >> '//datafield[@tag=“300†]/subfield[@code=“a†]’), >> ExtractValue(b.marcxml, >> '//datafield[@tag=“020†]/subfield[@code=“a†]’), >> ExtractValue(b.marcxml, >> '//datafield[@tag=“022†]/subfield[@code=“a†]’), >> ExtractValue(b.marcxml, >> >> monthname(datecreated) AS month, year(datecreated) AS year, biblionumber >> AS >> biblionumber >> FROM biblio >> LEFT JOIN biblioitems b USING (biblionumber) >> WHERE datecreated BETWEEN <<Between (yyyy-mm-dd)>> AND <<and >> (yyyy-mm-dd)>> >> >> >> The first report works. The second doesn't. I'm sure it's a syntax >> error, >> or something like that, but I'm blundering around in the dark. >> >> >> Her request was for the following info: 100 field = Author | 245 = Title >> proper (including subtitles and statement of responsibility) | 773(?) = >> Periodical title |260 = place, publisher, and date | 300 = Extent | 020 = >> ISBN / 022 = ISSN >> >> >> Can anyone help? >> >> -- >> Elaine Bradtke >> Data Wrangler >> VWML >> English Folk Dance and Song Society | http://www.efdss.org >> Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY >> Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance >> and >> Song Society in London, England. If you wish to phone me personally, send >> an e-mail first. I work off site) >> ------------------------------------------------------------ >> -------------- >> Registered Company No. 297142 >> Charity Registered in England and Wales No. 305999 >> ------------------------------------------------------------ >> --------------- >> "Writing about music is like dancing about architecture" >> --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) >> _______________________________________________ >> Koha mailing list http://koha-community.org >> [email protected] >> http://lists.katipo.co.nz/mailman/listinfo/koha >> > > --- > Maritime heritage and history, preservation and conservation, > research and education through the written word and the arts. > <http://NavalMarineArchive.com> and <http://UltraMarine.ca> > > > _______________________________________________ > Koha mailing list http://koha-community.org > [email protected] > http://lists.katipo.co.nz/mailman/listinfo/koha > -- Elaine Bradtke Data Wrangler VWML English Folk Dance and Song Society | http://www.efdss.org Cecil Sharp House, 2 Regent's Park Road, London NW1 7AY Tel +44 (0) 20 7485 2206 (This number is for the English Folk Dance and Song Society in London, England. If you wish to phone me personally, send an e-mail first. I work off site) -------------------------------------------------------------------------- Registered Company No. 297142 Charity Registered in England and Wales No. 305999 --------------------------------------------------------------------------- "Writing about music is like dancing about architecture" --Elvis Costello (Musician magazine No. 60 (October 1983), p. 52) _______________________________________________ Koha mailing list http://koha-community.org [email protected] http://lists.katipo.co.nz/mailman/listinfo/koha
