My challenge is to build a form where data gets validated before being saved, and if it fails validation the user should confirm if he want to save or not.
Practical example:
There is a registration form with 2 fields - username and is_manager. the name requires no validation, but the is_manager should be validated using Zend_Db_NoRecordExists (make sure another user isn't already manager - has is_manager = true) and if another user is already manager the the user should be prompted to confirm overwriting the manager.
The target DB table would be users(name, username, is_manager).
Any ideas are wellcomed! THank you!