That last quiz/survey system I created handles option fields by storing them
in their own table.
TableForm
TableQuestions
TableQuestionOptions
While you might be able to grab all of these in one query, I'm running two
and if the question type is a Select Box grab the option set.
<cfelseif Type EQ "Selection">
<cfquery name="getOptions">
Select blabla
from TableQuestionOptions
where FieldID = <cfqueryparam cfsqltype="cf_sql_integer" maxlength="5"
value="#FieldID#">
order by Sortorder
</cfquery>
Output Select Box Here.
<cfelse>
Another Field Type
</cfif>
--
Casey
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create Web Applications With ColdFusion MX7 & Flex 2.
Build powerful, scalable RIAs. Free Trial
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJS
Archive:
http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:274828
Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
