update Test set Status='P' where TestID=#Form.TestID# Delete TestQues where TestID=#URL.TestID# and QuestionID=#URL.QuestionID# select TestQuesID from TestQues where TestID=#URL.TestID# order by SeqNo Update TestQues set SeqNo=#SeqNo# where TestQuesID=#TestQuesID# Update Test set Status='B' where TestID=#Form.TestID# select name from Test where Name='#Form.NameTxt#' Insert into test (TestID,Name,StartDate,EndDate,Status,TypeCode) values (#Form.TestID#, '#Form.NameTxt#', '#DateFormat(Form.StartDateTxt,"mm/dd/yyyy")#', '#DateFormat(Form.EndDateTxt,"mm/dd/yyyy")#', 'B', '#Form.TypeCode#') select * from test where TestID=#Form.TestID# select count(*) as num from TestQues where TestID=#Form.TestID# Insert into Question (QuestionID,QuestionText,Type,Status,ImageURL) values (#QuestionID#,'#Form.QuestionTxt#','#Form.TypeRad#','P','#Form.PictureURL#') insert into QuesChoice (QuesChoiceID,QuestionID,Answer,Correct,Label) values(#QuesChoiceID#,#QuestionID#,'#Answer#','#Correct#','#Label#') insert into TestQues (TestQuesID,TestID,QuestionID,SeqNo) values (#TestQuesID#,#Form.TestID#,#QuestionID#,#SeqNo#) select * from TestQues where TestID=#form.TestID#

Build a New Quiz Continue Building Quiz

Error: #Error# 
Quiz Name: #Form.NameTxt#
Start Date: #Form.StartDateTxt#
End Date: #Form.EndDateTxt#
Type Code: Daily Trivia
Weekly Trivia
Other
Num Questions: #NumQuestions#

New Question Number #NewQuestionNum#
Question Text:
Picture URL:
Question Type: Multiple Choice Fill-in-the-Blank
ChoiceAnswerCorrect
#answerChoice#:

Select QuestionText from Question where QuestionID=#QuestionID#
NumQuestion
#count# #qQuestion.QuestionText# Remove