>> Is it better to store the data for the survey in an array of structures >> or save each page to the database as the user moves through the form,
This depends on if you require the entire survey to be filled out or if partial information is acceptable. We have done both. For most of the survey applications we've built we wanted the complete survey and throw away any that are incomplete so we uses session variables. 30-50 surveys a day is not much to be concerned about for resources as that is a relatively low volume in the scheme of things especially with session timeout of 20-30 minutes Dennis Powers UXB Internet - A website Design and Hosting Company P.O. Box 6028, Wolcott, CT 06716 - T:203-879-2844 W: http://www.uxbinternet.com W: http://www.ctbusinesslist.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:345134 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
