What about using a transaction some how and just rolling back if it times out?
Gareth. -----Original Message----- From: rob [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 March 2004 10:26 AM To: CFAussie Mailing List Subject: [cfaussie] Re: how can i control the close button on a web browser sorry mate i don't think i explained it... i have a pop up form that sets active = 0 in the db when the form is submited active = 1 window closes this works however teachers tend to just close the window using the browser window close hence active never = 1 and locks people out till i reset it... Rob. On 11/03/2004, at 11:21 AM, Kevin Faulkner wrote: > Hey Rob, > > If I understand you, you have a button which closes a pop-up window > with a > "self.close()" and you want to runan update before closing? > > Try this... > > First up, change your button to be a submit not a close, and submit it > to a > new template like this... > > <!--- new template ---> > <CFQUERY etc etc > > update query to make activity enabled here... > </CFQUERY> > > <HTML> > <HEAD> > <SCRIPT> > self.close(); > </SCRIPT> > </HEAD> > </HTML> > > > > > ----- Original Message ----- > From: "rob" <[EMAIL PROTECTED]> > To: "CFAussie Mailing List" <[EMAIL PROTECTED]> > Sent: Thursday, March 11, 2004 11:07 AM > Subject: [cfaussie] how can i control the close button on a web browser > > >> i have teachers collarbrating online however some of them click the >> close button before submitting. >> >> I have got a script going so when the teacher goes to the update form >> the activity becomes disabled in the db so other teachers cant modify >> the same for at once however i am relying on the fact that they hit >> the >> submit form to ensure the activity becomes active to the next person >> to >> modify it. >> >> how can i control close button at the top of the browser sooo... >> >> if close button hit >> make activity active >> end if >> >> pleas help! >> >> Robert Shaw >> Online Learning >> [EMAIL PROTECTED] >> MLC School >> Rowley Street >> Burwood 2134 >> Phone: 97471266 >> Mobile: 0422222515 >> Fax: 97453254 >> >> >> --- >> You are currently subscribed to cfaussie as: [EMAIL PROTECTED] >> To unsubscribe send a blank email to > [EMAIL PROTECTED] >> >> MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia >> http://www.mxdu.com/ + 24-25 February, 2004 >> >> > > > --- > You are currently subscribed to cfaussie as: [EMAIL PROTECTED] > To unsubscribe send a blank email to > [EMAIL PROTECTED] > > MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia > http://www.mxdu.com/ + 24-25 February, 2004 > > Robert Shaw Online Learning [EMAIL PROTECTED] MLC School Rowley Street Burwood 2134 Phone: 97471266 Mobile: 0422222515 Fax: 97453254 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004 --- You are currently subscribed to cfaussie as: [EMAIL PROTECTED] To unsubscribe send a blank email to [EMAIL PROTECTED] MXDU2004 + Macromedia DevCon AsiaPac + Sydney, Australia http://www.mxdu.com/ + 24-25 February, 2004
