When I create a checkbox parameter, the values selected are passed to my string as a comma-delimited list. I am following the documentation and I take that list and make a temp table out of it, to join to my query. This works fine when the values selected are integers, because the values get placed into a line like this:
set @vSQL = concat('insert into tmp_status select id,name from db.status where id in (', status, ')');
However, this doesn't work when the parameter values passed are non-integer. In this case, we'd need to put single quotes around each item in the list. However, mydbr doesn't do that. Is there any way to have it quote the parameters that are passed, or some way to parse the string and put quotes around each one in my stored procedure? Thanks