HI,
how can i parse a custom string into a procedure?
following does not work. (Unknown column reference: "klz")
select 'dbr.editable', 'xklz', 'sp_DBR_update_retailers', 'in_retailer_id=[rid]', 'in_column="klz"';
select
znr,
klz as 'klz[xklz]'
retailer_id as 'id[rid]'
from pst_germany.retailers
where exp_date is null
order by znr;
to save the value...
CREATE PROCEDURE sp_DBR_update_retailers
(
IN in_retailer_id INT,
IN in_column VARCHAR(100),
IN in_value VARCHAR(100))
BEGIN
SET @s = CONCAT('update pst_germany.retailers set ',in_column, '="', in_value, '" where retailer_id = ', in_retailer_id );
PREPARE stmt FROM @s;
EXECUTE stmt;
END
thanks
chris