[Koha-bugs] [Bug 11867] Multi transport types: Manage *_PHONE notices

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=11867

--- Comment #17 from M. de Rooy <m.de.rooy at rijksmuseum.nl> ---
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.