0419
类没有及时部署进去.修改一下类,保存.svn update不成功,可能新加了包的层次.从新加的包开始更新.
db2 value()在第一个参数为null的时候返回第二个参数的值
SELECT value((SELECT u.receive_frequency
FROM e2exlation.user_mail_config u
WHEREu.user_id = 224
AND u.group_code = dmc.group_code),
dmc.receive_frequency) receive_frequency
FROM e2exlation.default_mail_config dmc
WHEREdmc.group_code = (SELECT value((SELECT umc.group_code
FROM e2exlation.user_message_code umc
WHEREumc.user_id= 224
AND umc.message_code='PRO_CLOSE'), mc.group_code) group_code
FROM e2exlation.message_code mc
WHEREmc.message_code = 'PRO_CLOSE')
页:
[1]