I would simply have the record created on the first form - then run a sql update query on the other forms. if you store temporarily - someone may give up and you loose all information is someone kills browser - or you have to take extra steps to write cookies or secure your temp info- by writing to db each step you;ll probably save alot of time for yourself jay
Ken Wilson wrote: >What dictates that the first form can't be written to the DB as soon as they >submit it? > >Ken > > > >-----Original Message----- >From: Brian Scandale [mailto:[EMAIL PROTECTED]] >Sent: Saturday, November 23, 2002 1:02 PM >To: CF-Talk >Subject: temp variable storage? > > >I have a large form (around 100 text boxes and check boxes etc...). Once >the user submits it they still need to navigate about 6 more forms before >the data can be written to a database. > >How do I go about storing the form data temporarily until I can write it to >disk? I suspect there are more than one ways that you all are doing this. > >Thanks for a few clues. > >Brian > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm
