Technote Details :: I can't use AJAX Edit-In-Place with server formats
Issue
I want to apply the AJAX Edit-In-Place on a recordset binding that has a server format applied on it (for instance, to display the recordset field with upper-case letters only). After I apply the AJAX Edit-In-Place, I notice the server format is not effective (it does not appear to work) or it is effective, but the wrong value is saved to the database.
Reason
There are two possible explanations for this, depending on which approach you used to apply the server format:
- If you apply the server format first, and then the AJAX Edit-In-Place, the code for the AJAX Edit-In-Place totally replaces the code of the server format in Dreamweaver. In this situation, the server format is not applied (for instance, your recordset field will not be displayed with uper-case letters).
- If you apply the AJAX Edit-In-Place first, and then you manually add a server format to the recorset binding, the value saved to the database after you edit it using AJAX Edit-In-Place will be formatted according to the server format. For instance, if you applied a server format that displays your recordset bindings in upper-case, the value saved to the database after editing will also be in upper-case (even if the initial value was not upper-case prior to editing).
| Value in database, before editing |
 |
| Value when edited with AJAX Edit-In-Place |
 |
| Value saved to database after editing |
 |
Solution
This is a known limitation of the AJAX Edit-In-Place widget. We recommend not using server formats in combination with this widget.