>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.
well it's a distinct form on each page, but yes, I go to the db between each page for an UPDATE >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. It's this way because I was told "what if they just close the page" or a whole bunch of other what-ifs and was told that not only would it need to store it between each page, but that it also had to have a Save button on each page just in case they wanted to save partially typed information. Some of the entries can be thousands of characters. >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. So at the beginning, I should do a db query and store it to the session scope and while I don't know how to address the session scope, it seems it would be pretty easy to look up. Then each one of the form fields just needs to reference that to fill-in. And as you said, I'd also have to fill it in whenever I go to the database, not as a seperate database call but just <cfset session.var = "something"> (or however it's done). Does that all sound right? btw, here's an example of one of the pages, not that it will help I think: http://hhp.umd.edu/empower/situation_analysis/s_vision_01_test.cfm thanks! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:207184 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=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
