ASP Advanced

Course Length: Two-Days
Fees: Training at Client Offices: One delegate: £650 per-day + VAT
Additional delegates attending: £150 each per-day + VAT

Overview: This course teaches the advanced features of using ASP to customise web pages according to the choices of the visitor.

This course is aimed at those with a good working knowledge of HTML (or XHTML) and a scripting language (VBScript is preferred although this is not essential).

Those attending the advanced course are expected to have the skill set taught in the introductory course and attendance on it is a prerequisite.

Prerequisites: HTML (or XHTML) experience; VBScript course skill set; ASP Intro course attendance

Using Scripting Objects

	Scripting objects explained
	Creating an instance
	The FileSystem object
	Server-side includes
	The TextStream object
	The RegExp object

ASP Components

	The Server object
	The AdRotator component
	Content linking
	The browscap.ini file

Onward to Databases

	Universal access for databases
	Introducing ODBC

Data Store Access

	OLE-DB explained
	Introducing ADO
	The ADO object model
	Accessible databases

Using the Connection Object

	The Connection explained
	Connection strings
	Data links and source names
	Opening and closing connections
	Properties and errors

Working with Recordsets

	Recordsets explained
	Creating a Recordset
	ADO constants
	The Source
	The active connection
	Recordset characteristics
	ADO Cursor Types
	The LockType property
	Options
	Using the Recordset object

Data Handling

	Using the Command Object
	Using SQL
	Using Queries
	Using Stored Procedures

Modifying Data

	Recordsets and adding data
	Updating data
	Deleting and inserting data
	Visitor page modification
	More data manipulation

If you have other questions, please contact us at enquiry@it-uk.com or complete our response form