I just did a quick install of mysql 5 to have a play with this one. Without changing/adding quotes you can just add the table name to the column name to create the a table with return . In your case when creating the issues table just change return char(4) default NULL to issues.return char(4) default NULL The select will fail if use select return from issues; but select * from issues; and select issues.return from issues; work. If you are lucky maybe no perl code change is required, need to ask a Koha expert/have a look at the code. Regards, Simon On 08/12/05, Thomas D <koha@alinto.com> wrote:
Please see my earlier reply to this thread. There should be no need to change a perfectly appropriate column name. Use ANSI compliant quoting of the column name instead.
Thomas D
Quoting Paul POULAIN <paul.poulain@free.fr> :
---------------- Beginning of the original message ------------------
[snip]
It's probably a reserved word for stored procs. that's a shame & should be cleaned for 3.0, even if we don't use mySQL immediatly.
-- Paul POULAIN Consultant indépendant en logiciels libres responsable francophone de koha (SIGB libre http://www.koha-fr.org)
_______________________________________________ Koha-devel mailing list Koha-devel@nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel
------------------- End of the original message ---------------------
--------------------------------------------- Protect your mails from viruses thanks to Alinto Premium services http://www.alinto.com
_______________________________________________ Koha-devel mailing list Koha-devel@nongnu.org http://lists.nongnu.org/mailman/listinfo/koha-devel