Re: [Koha] Need some SQL help

Thanks Galen, that did it. Seems so obvious now. :) Doug -Original Message- From: Galen Charlton [mailto:g...@esilibrary.com] Sent: Friday, April 19, 2013 12:10 PM To: Doug Dearden Cc: koha@lists.katipo.co.nz Subject: Re: [Koha] Need some SQL help Hi, On Fri, Apr 19, 2013 at 10:54 AM

Re: [Koha] Need some SQL help

Hi, On Fri, Apr 19, 2013 at 10:54 AM, Doug Dearden wrote: > So what would the SQL/Xpath syntax be to get the info out of ind2 ? Here's the XPath: //datafield[@tag="245"]/@ind2 Regards, Galen -- Galen Charlton Manager of Implementation Equinox Software, Inc. / The Open Source Experts email: g

[Koha] Need some SQL help

Hello all, I find myself once again confounded by an SQL problem. I am trying to extract the value from field 245, ind2 . I have used a variety of select statements without success, i.e. SELECT EXTRACTVALUE(marcxml,'//datafield[@tag="245"][ind2]') as "SkipArticle" or SELECT EXTRACTVALUE(marcx