hi there, wondering if someone might be able to help with this please.
I have a simple questions table and I'm displaying one randomly generated
question from it at a time. User clicks a button and the page reloads to give
the next question.
So far I have this simple bit working fine:
<cfquery name="getquestion" datasource="#request.DSN#">
SELECT questions.questionid, questions.questiontext
FROM questions
</cfquery>
<cfset displayRow = RandRange(1,getquestion.recordcount)>
<cfoutput query="getquestion" maxrows="1"
startrow="#displayRow#">#questiontext#</cfoutput>
What would be the easiest approach to make sure that one question cannot be
delivered twice?
Any help would be greatly appreciated.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Order the Adobe Coldfusion Anthology now!
http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion
Archive:
http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:350579
Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
