Get 20% discount on our Yearly Subscription and save €118/$137. The offer expires on 31st of August!
DMXzone Database Updater ASP

Perform Database Updating actions on any well-known database without any SQL and ASP knowledge! The DMXzone Database Updater ASP Dreamweaver extension gives you the power to manage the data in your databases in a whole new way through Ajax technology! You are submitting, saving and reloading your data without any page refresh! Perfect for building dynamic web sites and single page apps. Fully integrated visual tools and server code generation are available at your disposal!
The DMXzone Database Updater includes an amazing Database Updater Action Builder that will allow you to build fully visual an advanced insert, update and delete queries to your database source without any SQL knowledge! It even supports advanced filtering and for multiple update and delete actions!  With the powerful Database Updater Action Executor you can define where Database Action should get its data from when executed. You quickly pick any data from the available HTML5 Data Bindings, like form fields but also any other data!

- OR -

Full integration within DMXzone Server Connect

Thanks to the great integration of DMXzone Database Updater within DMXzone Server Connect you can easily insert/delete/update one or multiple records in your database.

Database Updater Action Builder

The Database Updater Action Builder lets you visually define any database update action. A database action defines a single global action for your site that executes a record insert, update or delete. You can have as many database actions as you wish and you can reuse them on multiple pages. Each database action just defines the database table it is operating on, which columns receive values and if any filters are applied for record selection. Database actions are executed by the so called Database Action Executors fully thought AJAX , so that you can execute them without any page refresh!

  • Insert record - Use the insert type of action to insert new records into a database table.

  • Update record - Use the update type of action to update existing records in a database table. You can also update multiple records.

  • Delete record - Use the delete type of action to delete rows in a database table. You can also delete multiple records.

  • Manage connections - The Database Updater Action Builder allows you to create and manage connections to servers with the DMXzone Database Connection wizard dialog.

  • Easy table and column pickup - You can quickly add your table to be listed in the columns pickup view. From there you can choose the columns to be populate with data and filters to be used.

  • Add, duplicate and remove database actions - In the action wizard you can add as many actions as you want, delete or duplicate them.

  • Add and remove database table - From the table manager you may add or remove a database table to pickup columns from.

  • Column values - Select the columns of your table that should be updated with new values. You can use the following sources:

    • POST variable - Fields data submitted from your page with Database Action Executor or regular post request
    • Entered value - Entered value defines a static value.
    • URL parameter - Parameter passed in the page query string
    • Cookie - Stores retrieved cookie values.
    • Session variable - You can use session variables to store and display information maintained for the duration of a user’s visit (or session). The server creates a different session object for each user and maintains it for a set period of time or until the object is explicitly terminated.
    • Application variable - In ASP you can use application variables to store and display information that is maintained for the lifetime of the application and persists from user to user. After you define the application variable, you can use its value in a page.

  • Records filtering conditions - The filters list contains conditions that are applied to database action when executed. There are basic conditions like =, <, > as well as advanced, such as contains, begins with, ends with and between. This way you can limit the database action to specific records. You can use the same value sources as with column values.

  • Required fields - You can check mark any column or filter that is required to have a value.

Database Updater Action Executor

Database Action Executors let you run a database action with specific data assigned. So if you have defined to use a database action to update your database table columns, now with the Database Action Executor you can assign the values for those columns. That is why you define a database action globally to your site, so it can be reused, but define a specific executor on your current page where your data is in for example some form with fields.

  • Assign the data for the Database Action - Quickly choose an already defined Database Action or create a new one and then just assign the data source for its columns and/or filters.

  • Easy data bindings pickup - Just select data source field from the available data bindings, displayed in the data bindings tree left and assign it to the corresponding database column field or filter, on the right, that is defined for the selected Database Action.

  • Add, duplicate and remove database executors - In the executor wizard you can add as many executors as you want, delete or duplicate them.

  • Quickly assign Database Action filter values  - If you have defined to use a database action to update or delete records from your database based on a filter, you can now assign values for this filter.

  • Full support for HTML5 Data Bindings Formatter - If you have the HTML5 Data Bindings Formatter extension installed you can get the power of the 47 supplied formatting filters, directly in your Database Updater Action Executor wizard dialog.

  • Execute asynchronous - You can enable the asynchronous execute of the Database Action so that the user browser is not blocked while the action executes! This gives you the best user experience.

  • Display alert errors - An alert message has been displayed when the action is not executed properly. 

  • Database Updater behaviors -  If you want to execute follow up action and/or behaviors depending on the result of you database action you can use our Behavior Connector to bind to the right events.

The following events are available:
  • Before the action is executed - This event is fired before the action is executed. For example, you can show here a preloader or a message that the action is being executed now. Also, you can use this event for extra validation.

  • When the action is finished - The event is fired when the action is done, successfully or with an error. This is the place to hide your preloaders as the call for data is finished. After this you can even execute others depending if data was successfully received or an error has occurred.

  • When the action is successfully executed - This event is fired when the action is successfully executed. You can show a success message here that the action was executed successfully. Also you can set to refresh your data to see the changes, without refreshing the page.

  • When an error has occurred - This event is fired when an error has occurred during the data fetch. You can show an error message here that the action has failed.

Control Database Action Executor Behavior

After defining your Database Update Action and assigning data to it with the Database Action Executor, you are now ready to run it! This is where the Control Database Action Executor behavior comes in place. Just like any other behavior you can add to a specific event like click on a button or link to trigger the executor to runs its database action! You can even add the behavior through the Behavior Connector so the action executes for example as a follow action on a different database action or event from other DMXzone extensions.

  • Control DMXzone Database Action Executor - Once your database actions are defined with assigned data to them, you need the control database action executor behavior in order to run them.

  • Choose one of the available events - You can add to a specific event like click on a button or link to trigger the executor.

  • Run your Database Action through the DMXzone Behavior Connector - You can use the DMXzone Behavior Connector to run your database action as a follow up action.

  • Control DMXzone Database Action Executor Actions- The available actions in the Control DMXzone Database Action Executor are run and abort that you can choose from. 

  • Run the DMXzone Database Action Executor - Once you select the run action it triggers the selected Database Action Executor.

  • Abort the DMXzone Database Action Executor - You can apply the abort action for certain executor for example in case a validation fails.
  • Data override - It allows you to override the existing data setting such as value for insert, and value and filters for update/delete. 

Once you click the data override, the Database Updater Action executor window opens where you can change what you want to override.

Full Feature List

Replace Server Behaviors with DMXzone Extensions (Part 3)

Insert, update, delete records meet DMXzone Database Updater

Type: Behavior
License: External link
Product: Dreamweaver CS5/CS5.5 and CS6, Dreamweaver CC+
Database: Access, SQL Server, MySQL
Platform: Win XP/2000/2003/2008/7, Mac OS X, Mac OS X 10.4+
Used Technologies: jQuery, Ajax
Tags: database, updater, ASP, SQL, jQuery, Ajax


Version 1.7.1

  • New basic data type: datetime for specific Date and Time storage of both date and time in a databases field. The other types like Date now store date only and time - time only.
  • Fixed some minor connection generation issues in ASP
  • Fixed minor parser issues in the updater
  • Always show linked modules from the current selected site only
  • Improved Mac UI

Version 1.7.0

  • New conditional values! Now you can enter a condition statement for each expression on filters, updates and order by statements so you can conditionally update them as needed!
  • New keyword for date and time field types to populate the value with the current date/time
  • Field types are now also available for all database query statements and are auto-populated based on the database field type
  • Improved UI

Version 1.6.0

  • New automatic input fields binding for Database Updater when used in combination with DMXzone Server Connect
  • Improved JSON escaping in database connect generation code
  • Improved MS Access support
  • Improved database delete

Version 1.5.1

  • Improved JSON escaping in database connect generation code
  • Improved MS Access support in ASP
  • Improved database delete in ASP

Version 1.5.0

  • Full compatibility with DMXzone Server Connect

Version 1.3.2

  • Improved compatibility with Dreamweaver CC 2015

Version 1.3.1

  • Support for GUID database types in ASP
  • Improved support for LIKE expressions in all database connectors
  • Improved database data types support

Version 1.3.0

  • Cross site support for connecting mobile apps with dynamic database sites as data sources
  • Improved mobile data bindings support for building dynamic apps with PhoneGap or Cordova
  • Redesigned UI look

Update instructions for DMXzone Database Updater:
Note you need to reapply all current Database Actions in your site. Just open Site / DMXzone Database Updater / Manage Database Actions ... and then click on "Reapply All"

Version 1.2.1

  • Improved for Dreamweaver CC 2014
  • Improved for DMXzone Extension Manager

Version 1.2.0

Update instructions:
Note you need to reapply all the current Database Actions in your site. Just open the Site / DMXzone Database Updater / Manage Database Actions ... and then click on "Reapply All"

Version 1.1.1

Version 1.1.0

  • Added full support for the new DMXzone Security Provider PHP/ASP for secure database update actions.
  • Greatly improved the storage and caching of database structure info. It is all store now in the connection file so refreshing when database structure changes is really easy.
  • Improved the schema refreshing on Database Updater Action Builder dialog.
  • Added "Reapply all" buttons to Database Updater Action Builder.
  • New Behavior Connector Events for integration with DMXzone Security Provider PHP/ASP to allows you to react when the users is not logged in or does not have enough permissions.
  • New states in the Data Bindings tree per Database Actions also for user permissions.
  • Primary keys in database columns view - You can see now directly which database columns are used as primary keys on the different icon in front.

Update instructions:
Note you need to reapply all the current Database Sources in your site. Just open the Site / DMXzone Database Updater / Manage Database Actions ... and then click on "Reapply All"

George Petrov

George PetrovGeorge Petrov is a renowned software writer and developer whose extensive skills brought numerous extensions, articles and knowledge to the DMXzone- the online community for professional Adobe Dreamweaver users. His expertise in countless languages and technologies gives inspiration and teach valuable lessons on his website – which is most popular for its over high-quality Dreamweaver extensions and templates.

See All Postings From George Petrov >>

Place your review about DMXzone Database Updater ASP

You must me logged in to write a review

Be the first to place a review