http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11867
--- Comment #17 from M. de Rooy <[email protected]> --- The sql construct name=(SELECT name FROM ( SELECT name FROM letter WHERE code= ... LIMIT 1) AS t) does probably not win beauty prices :) You could try something with joining letter in the update statement. But on the other hand why would you? You do not need to change the name for the Phone notices. That name should be fine. Note that the SELECT .. LIMIT 1 will not always provide the best choice; you are not even sure which one he picks. Is it an idea to remove name from the UPDATE? -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list [email protected] http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/
