If it in turn just writes data back from the screen without the operator adding any valued input, then you might be able to put that update right in the...

Perfect sense.  Thanks alot Phil.

The app is invoked by coldfusion however I am attempting to remove some of the functionality from the web server and add it to the sql server.  Like the email...

Thanks Phil,

The current application is written in Coldfusion.  I have been able to take most of the functionality and add it to stored procedures to be processed inside the server...