[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Koha-devel] [Bug 299] Modifying a currency results in a new one being a
From: |
bugzilla-daemon |
Subject: |
[Koha-devel] [Bug 299] Modifying a currency results in a new one being added |
Date: |
Wed Apr 9 21:06:03 2003 |
http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=299
address@hidden changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |RESOLVED
Resolution| |FIXED
------- Additional Comments From address@hidden 2003-04-10 16:04 -------
I looked at currency.pl and saw that it was using MySQL's replace statement. I
changed it into two SQL queries. The first is to check if there is an existing
row with the same name (currency). If there is, the I prepare and execute at
SQL UPDATE statement; otherwise, I prepare and execute a SQL INSERT statement.
This fixed the problem and also removes our dependence on MySQL (since replace
is a MySQL-specific command). We should probably go through and do this for all
of the scripts that use 'replace'.
------- You are receiving this mail because: -------
You are the QA contact for the bug, or are watching the QA contact.
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Koha-devel] [Bug 299] Modifying a currency results in a new one being added,
bugzilla-daemon <=