save to db and allow them to come back later to continue. for a good example check out www.formassembly.com, it just just this and a lot more, even in the free version.
On Sun, Jun 5, 2011 at 10:21 PM, Jim Brundle <[email protected]>wrote: > > I have a multi-page form (survey) where the user can go forward and back > through the survey. I want to save the entries from each page so that I can > repopulate the page if the user goes back to it. I expect to have 30-40 > surveys a day. Is it better to store the data for the survey in an array of > structures (CategoryID, QuestionID, AnswerValue) and then submit all the > data in one pass when the user finishes the form, or save each page to the > database as the user moves through the form, and then go back to the > database for the data if they go back to an earlier page? I've always > thought it was best to only hit the database once at the end, but I've been > reading that some people recommend going to the database every time a page > is submitted, because storing the data as an array of structures takes up > RAM. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:345096 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
