Background Processes

i have form requires user input 40 datapoints. once submit form, 40 datapoints inserted our database, calculations run on data, , more data inserted in database. when data in, email sent user , page reloaded entered data pre-filled in.

is there way to, once submit data, have insertions , calculations , emailing go on in seperate process while move on , other things? scheduled tasks done in background, using different session.

could cflocation then cfmodule , call data submission template?

ideas welcome, thanks!

i similar time on application uses oracle. have gui prompt user submit 40 datapoints via forms, etc., , populate table in database data , status of 'submitted' etc. then, have background process (stored procedure, etc.) runs every 'x' minutes scans work looking submitted status. stored procedure perform whatever activity wish on pending jobs, end setting job status 'complete', or 'error', or whatever want use track completed or failed jobs. client can check see if or job completed accessing page check status of submitted job, etc. works great, if have process take long hold web page.

phil

More discussions in Advanced Techniques

adobe