UpdateContact update url definition
###################################
# updateContact
###################################
request.updateContact.classname=com.ai.db.DBRequestExecutor2
request.updateContact.db=cmsdb
request.updateContact.query_type=update
request.updateContact.stmt=\
\
update contacts \
set ( \
contact_name = {contact_name.quote}, \
contact_home_phone = {contact_home_phone.quote}, \
contact_cell_phone = {contact_cell_phone.quote}, \
contact_work_phone = {contact_work_phone.quote}, \
contact_email = {contact_email.quote}, \
contact_web_page = {contact_web_page.quote} \
last_updated_on = Now() \
last_updated_by = 'Annonymous' ) \
where \
contact_id = {contactId}
#######################################
#Redirection
#######################################
request.updateContact.redirectURL=/cms-1/servlet/DisplayServlet?url=ListContactsURL
request.CreateUser.failureRedirectURL=/akc/servlet/DisplayServlet?url=ContactDetailURL&result=error
References/questions
1. How to pass more error details to the screen
2. How to do server side validation
3. How to use exceptions for redirection
4. How to use update pipelines