[Bug 299] Modifying a currency results in a new one being added
http://bugs.koha.org/cgi-bin/bugzilla/show_bug.cgi?id=299 mwhansen@hmc.edu changed: What |Removed |Added ---------------------------------------------------------------------------- Status|NEW |RESOLVED Resolution| |FIXED ------- Additional Comments From mwhansen@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.
participants (1)
-
bugzilla-daemon@wilbur.katipo.co.nz