Home     Services     Tutorials     Pricing     Portfolio     Testimonials     Links     Contact    

 Tutorials
  Dreamweaver ASP
Insert, update and delete records in multiple tables from one form
Delete multiple records
Update multiple records

  ASP - VBScript
Format numeric values
Format Currency values
Working with dates and times

  ASP - Access
Retrieve Record Identity from an autonumber field on insert
Setting up an OLE DB connection string

  ASP - SQL Server
Retrieve record identity from an auto incremented field on insert
Generate a random number
Setting up an OLE DB connection string

Tutorials

This is a collection of short articles compiled to answer questions I have frequently encountered on some of the developer forums I've visited.


Dreamweaver UltraDev 4 / MX / ASP

INSERT, UPDATE & DELETE records in multiple tables from one form
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 to do this. This is essential if you need to modify records in separate database tables and maintain relationships between them. This method can also be used in conjunction with the Retrieve record identity from an autonumber field on record insert to insert the identity of a newly created record in one table into a field of another table in order to create a relationship.

Deleting multiple records using a series of checkboxes
How to delete multiple records in a single operation using a series of checkboxes.

Updating multiple records
How to update multiple records in a single operation.


ASP / VBScript

Format Numeric Values
How to modify the way in which numeric values are displayed, specify the number of decimal places shown, group digits and determine way negative values are indicated.

Format Currency Values
How to modify the way in which currency values are displayed, specify the number of decimal places shown, group digitsand determine way negative values are indicated. In addition, you can use the SetLocale function to modify the currency symbol shown.

Working with dates and Times
Adding, subtracting and formatting dates and times.


Access

Retrieve record identity from an autonumber field on record insert    
In order to maintain the relationships between database tables or to return the identity of the record they have just created to the user it is necessary to determine the identity of the newly created record. There are many bad examples of how to do this, mainly involving the use of SQL and SELECT MAX(RecordID) to determine the highest record identity value. This article shows a reliable way to determine the correct identity of the newly created record.

Setting up an OLE DB connection to an Access database    
OLE DB not only offers a performance benefit over ODBC connections (DSN) but also has some increased functionality. This article shows how to set up an OLE DB connection to an Access database.


SQL Server

Retrieve a record identity from a SQL Server auto-incremented field on record insert    
Retrieving the identity of a newly inserted record can be very useful if you wish to return the value to the browser or use it in a subsequent insert or update command in order to create or maintain a relationship between two or more records. This article shows you how to do this using either a SQL Server stored procedure or coded directly with ASP.

Generate a random number within a stored procedure
How to generate a random number within a SQL Server stored procedure.

Setting up an OLE DB connection to a SQL Server database    
OLE DB not only offers a performance benefit over ODBC connections (DSN) but also has some increased functionality. This article shows how to set up an OLE DB connection to a SQL Server database.


 - Includes notes for Dreamweaver users.