This content has been marked as final. Show 4 replies
Use a hidden field to hold the random question when you return to ask the question again. On the question page, use <CFPARAM NAME="question" DEFAULT=""> at the top of the page. Then test to see if question is null. If so, do the RandRange( ). If not, ask the same question again from the hidden field.
if I capture the question in a hidden field, and the answer the user provides is wrong what will stop it from displaying another question if I send them back to the questions page? I am very new at this.
The code below should give you an idea how to proceed. It returns the question in the URL rather than a hidden field.
here is my query, how would I set this up to work with your script
select q.question, I.*
from swa.IdentityQuestions q, swa.IdentityAnswers I
where q.IdentityQuestionId = I.IdentityQuestionId
and userId = '1000'