DECLARE ret VARCHAR(64);
DECLARE v_id INTEGER;
SET ret = '';
- SET id = 0;
SELECT id, lval INTO v_id, ret FROM i18n
WHERE ltype=in_ltype AND lkey=in_lkey and inlang=in_inlang LIMIT 1;
- IF id > 0 THEN
+ IF v_id > 0 THEN
RETURN ret;
END IF;
SELECT id, lval INTO v_id, ret FROM i18n
WHERE ltype=in_ltype AND lkey=in_lkey and inlang='en' LIMIT 1;
- IF id > 0 THEN
+ IF v_id > 0 THEN
RETURN ret;
END IF;