Re: Problems modifying a new record
In article <3E2474B4.E05D744B@bittware.com>, Jim Thomas <jthomas@bittware.com> wrote:
I used the marc lookup and imported the file for Charlie Horse/Mrs. White's Secret Sock. I modified the data before saving. It set up the ^ biblio for the book, plus my item number 5658.
The book title has an apostrophe; this looks like Bug 148. Bug 148 is listed as affecting Koha 1.2.3, so 1.2.2 will be affected as well. -- Ambrose Li <a.c.li@ieee.org> http://ada.dhs.org/~acli/cmcc/ http://www.cccgt.org/ DRM is theft - We are the stakeholders
"acli@ada.dhs.org via news-to-mail gateway" wrote:
In article <3E2474B4.E05D744B@bittware.com>, Jim Thomas <jthomas@bittware.com> wrote:
I used the marc lookup and imported the file for Charlie Horse/Mrs. White's Secret Sock. I modified the data before saving. It set up the ^ biblio for the book, plus my item number 5658.
The book title has an apostrophe; this looks like Bug 148. Bug 148 is listed as affecting Koha 1.2.3, so 1.2.2 will be affected as well.
That sounds like it then. Now that I know about it, we can avoid apostrophe's in the future, or we can fix the bug (is there a patch?). Is there a way to clean up the mess it made? Thinking that apostophes are not that uncommon in book titles led me to try this: select title from biblio where title LIKE "%'%"; Which returned 112 rows. Do I need to do something to fix them, or will a patch address this? -- Jim Thomas Principal Applications Engineer Bittware, Inc jthomas@bittware.com http://www.bittware.com (703) 779-7770 A pessimist is an optimist with experience
On Wed, Jan 15, 2003 at 01:04:10PM -0500, Jim Thomas said:
The book title has an apostrophe; this looks like Bug 148. Bug 148 is listed as affecting Koha 1.2.3, so 1.2.2 will be affected as well.
That sounds like it then. Now that I know about it, we can avoid apostrophe's in the future, or we can fix the bug (is there a patch?).
1.2.3 will fix this bug when its released, i can work on a patch for 1.2.2 if youd like, but 1.2.3 isnt to far away.
Is there a way to clean up the mess it made?
Thinking that apostophes are not that uncommon in book titles led me to try this: select title from biblio where title LIKE "%'%";
Which returned 112 rows. Do I need to do something to fix them, or will a patch address this?
A patch will address it, it will be a simple case of the ' not being escaped in the sql statement. Ill take a look after work tonight. Chris -- Chris Cormack Programmer 025 500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz
participants (3)
-
acli＠ada.dhs.org via news-to-mail gateway -
Chris Cormack -
Jim Thomas