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
Koha@lists.katipo.co.nz
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
Koha@lists.katipo.co.nz
http://lists.katipo.co.nz/mailman/listinfo/koha