Handcoding database inserts using Dreamweaver MX
The Insert/Update/Delete server behaviours that are built in to Dreamweaver MX can sometimes be a little inflexible or confusing. Occasionally, I prefer to handcode inserts/updates using the Recordset.Update method. It's really easy to use and the code is quite readable. Basically, you'd create a recordset and then have some code like:
<%
Recordset1.AddNew
Recordset1("Fieldname")=Request("textfield")
Recordset1.Update
%>
It's important to note that, by default, a recordset created by MX is read-only:
Recordset1.LockType=1
You'll need to change this to:
Recordset1.LockType=3
You can click the link below to download a demo. It contains 4 pages and a database - showing how to update/insert/delete from an Access database table without using the MX server behaviours.
Download file
