[Koha-devel] [Bug 299] Modifying a currency results in a new one being added

[bugzilla-daemon at wilbur.katipo.co.nz]

http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=299

mwhansen at hmc.edu changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEW                         |RESOLVED
         Resolution|                            |FIXED



------- Additional Comments From mwhansen at hmc.edu  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.