How about submitting the form, and cfparam'ing all the form fields, then make the value of each field "#form.whatever#". That will save any changed data.
You'll probably need to set up some logic to determine if you only want to change the ID, or you really are submitting the whole form. -- Josh ----- Original Message ----- From: "Derek" <[EMAIL PROTECTED]> To: "CF-Talk" <[email protected]> Sent: Wednesday, October 18, 2006 10:59 AM Subject: Form Fields - storing unsaved values with a Page refresh > Can anyone help me with this? > > I have an onChange function that refreshes my coldfusion page and puts the > new ID in the URL and then the SQL uses this ID to get certain information > from the database. But when it refreshes with the new ID I lose any > changed > data in the form... any suggestions? > > My code goes kinda like this > > <SCRIPT> > function filter(ID){ > self.location.href=('index.cfm?ID=' + ID + ''); > } > </script> > > <cfquery> > SELECT > FROM > WHERE url.Id > </cfquery> > > <form> > > <input type=text> > > <select onChange=filter(ID)> > <option> > <option> > </select> > > </form> > > Let me know if you need more details. Thanks so much for your time. I dont > know where coders would be without forums. > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:257246 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
