SELECT qry.* FROM qry WHERE qry.group=#group# AND qry.active=1 ORDER BY qry.id ASC; SELECT qry_answer.* FROM qry_answer WHERE qry_answer.partcp_id=#cookie_id# AND qry_answer.active=1;
Block #group#
#text# bgcolor=orange> #i# #i#
#GetToken(GetToken(error,ListContains(error,qryvar,"|"),"|"),2,":")#
UPDATE qry_answer SET qry_answer.active=0 WHERE qry_answer.qry_id IN (#ReReplaceNoCase(ValueList(Get.id),",{1,20}",",","ALL")#) AND qry_answer.partcp_id=#cookie_id#; INSERT INTO qry_answer (qry_id,partcp_id,response,active,date_entry) VALUES (#id#,#cookie_id#,'#Evaluate("FORM.#qryvar#")#',1,'#ACTIME#'); done