There may be instances where one wants to update a field value for a large, select group of records. Doing this one record at a time is a killer on productivity. However, using checkboxes and a drop-down list, one can select a large group of records and then define a DMX Command to update the records in one fell swoop. This builds upon an article written by Marcellino Bommezijn concerning the deletion of multiple records and uses the SQL WHERE IN clause that he used in that tutorial.
Many people have trouble converting, inserting, updating and diplaying the correct regional date format when using databases like MS-Access. This tutorial teaches you how to insert and display the correct regional date format correctly with Dreamweaver.
I've seen this question posed many times in the ASP Q&A Messageboard... Typically this is done to determine if a user name already exists, common to many login required sites. Many people query the database and then check the values against the returned values through a loop of some sort. If they don't find it, they then add the record.
File upload on a RaQ running MySQL/Chilisoft is relatively simple but has practical limitations that have been overcome on MS platforms using Pure ASP Upload. The key issue is that the CHili ASP engine on the RaQ will only allow a single file to be uploaded at a time and the VBScript used on the upload page prohibits the use of any other Response or Request handlers.
The method describes here allows a user to upload a chosen file to a folder location on the RaQ server. Ideally the file name should be changed from the browsed fileName to something shorter. It can then be accessed using a database call from the MySQL database whenever it needs to be displayed.
Using Dreamweaver's standard insert, update, and delete server behaviours you can't modify records in multiple database tables using input from a single form. This article shows how to use the Command behaviour which enables you to do this. This is essential if you need to modify records in separate database tables and maintain relationships between them.