I think he's just talking about a simple multi-page form, but instead of storing the info in the session scope and inserting upon completion, he's inserting between each page.
So, Daniel, yes - you can retrieve the record set you're working with and store it. I'd probably go with storing it in the session scope. But, be aware that every time your user updates a page, you'll need to also update that session scope var. I'd maybe think twice about your design - that's a lot of round trips to the database. You could, instead, be storing stuff in the session scope as they go, and then have a "save" button (repeated on each page), that saves their current work-state. It depends on the sophistication level of your users, and what you're really trying to collect. ----- Original Message ----- From: "S. Isaac Dealey" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Thursday, May 19, 2005 10:10 AM Subject: Re: form->database->form help needed >I have to admit, I'm thoroughly lost... maybe an ascii-art picture of > what you're trying to describe might help? > >> I have an application where each page is a single field >> and between >> each page, that field information is sent to the database. >> There's a >> template page that gets copied by the content people and >> their own >> form element is added to the form template. >> I've set it up so that the page in between will find out >> if the field >> exists and if so, add it to the database. >> But if the person has already partially gone through the >> screens >> which adds the elements to the db and then leaves and >> comes back to >> their "project" to continue, I need it to fill in the >> pages that >> they're already completed, as they come to those pages. > >> I'm not sure how to approach this. Can I do a db call and >> cookie the >> recordset for each page to read or somehow add the >> recordset to the >> application variables? I'm really out of my element here >> so any >> advice or requests for clarity are greatly appreciated. > > > s. isaac dealey 954.522.6080 > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > > http://www.fusiontap.com > http://coldfusion.sys-con.com/author/4806Dealey.htm > > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:207166 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
