[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Koha-devel] Re: [Koha] Re: Problems modifying a new record
From: |
Chris Cormack |
Subject: |
Re: [Koha-devel] Re: [Koha] Re: Problems modifying a new record |
Date: |
Wed Jan 15 12:17:10 2003 |
User-agent: |
Mutt/1.3.28i |
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
address@hidden www.katipo.co.nz