select * from #Request.prefix_db_lookup#.TestQuestions where Step = '#form.role#' ORDER BY Question_ID ASC SELECT * From #Request.prefix_db_lookup#.Test_Answer WHERE Employee_ID = #url.eid# AND TestQuestion_ID = #Test_Question_ID# UPDATE IGNORE #Request.prefix_db_lookup#.Test_Answer SET Step = '#Get_Questions.Step#', Answer = '#Test_Question_answer#', Date = '#DateFormat(Now(),"yyyy-mm-dd")#', Role = '#Get_Questions.Role#' ,Comment = '#form.Comment#' WHERE Employee_ID = #url.eid# AND TestQuestion_ID = #Test_Question_ID# INSERT INTO #Request.prefix_db_lookup#.Test_Answer(Employee_ID,Step,Role,TestQuestion_ID,Answer,Date,Comment) VALUES (#url.eid#,'#Get_Questions.Step#','#Get_Questions.Role#',#Test_Question_ID#,'#Test_Question_answer#','#DateFormat(Now(),"yyyy-mm-dd")#','#form.Comment#') url.EID=decrypt(#url.EID#,"54kczhzgHTj4a8n+SRZPyg==","AES","Hex"); SELECT * FROM Test_Answer WHERE Employee_ID = '#url.EID#' AND Step = '#url.text#' select TQ.*,TA.Answer,TA.Comment from #Request.prefix_db_lookup#.TestQuestions TQ LEFT OUTER JOIN #Request.prefix_db_lookup#.Test_Answer TA on TQ.Question_ID = TA.TestQuestion_ID where TQ.Step = '#url.text#' AND TA.Employee_ID = '#url.EID#' ORDER BY Question_ID ASC select TQ.* from #Request.prefix_db_lookup#.TestQuestions TQ where TQ.Step = '#url.text#' ORDER BY Question_ID ASC

#Get_Questions.Step# Training Feedback Form