To/From Code

	Languages
BROWSEBYLANGUAGE Access VBA ASP Classic C# C++ C++/CLI Corel Paradox Delphi Delphi Prism Java JavaScript Perl PHP VB Classic VB.Net

	Categories
BROWSEBYCATEGORY +Tool Basics +Language Basics +Language Details +Data Structures +Statements +Operators +Commands -Database ◄╣ Edit Record Filter Records Find Record Record Movement Sort Records +OOP Basics +OOP Details

	ASP Classic Guides
ASP Classic To/From Conversion Guides ASP Classic and Access VBA ASP Classic and C# ASP Classic and C++ ASP Classic and C++/CLI ASP Classic and Corel Paradox ASP Classic and Delphi ASP Classic and Delphi Prism ASP Classic and Java ASP Classic and JavaScript ASP Classic and Perl ASP Classic and VB Classic ASP Classic and VB.Net

Cross Ref Guide

ASP CLASSICLANGUAGE

ASP Classic

ASP CLASSICANDPHPTOC

Overview

+Tool Basics

Report Tools Overview

+Language Basics

+Language Details

+Data Structures

Array

+Statements

+Operators

+Commands

-Database◄╣

+OOP Basics

+OOP Details

	Members-Only
Sign in to see member-only pages.

► KB ► To/From Guides ► ASP Classic ► Database

Print This

Cross Ref > Database

By Mike Prestwood

ASP Classic versus PHP: A side by side comparison between ASP Classic and PHP.

Database

This category documents connecting and using data including database commands, and common technologies used.

Edit Record

[Other Languages]

Languages Focus

This common syntax name documents editing a record as a whole: add/insert, edit, post data, and delete.

ASP Classic: AddNew, Update, Delete

In ASP, using ADO, you use RecordSet.AddNew to add a new record, Recordset.Update to post the record, and RecordSet.Delete to delete it. To edit a record, you open the RecordSet using an editable cursor.

Syntax Example:

The following code snippet adds a record to a given editable RecordSet with FullName and Created fields:

objRS.AddNew

objRS.Fields("FullName") = "Barack Obama"

objRS.Fields("Created")  = Now

objRS.Update

[Not specified yet. Coming...]

Filter Records

[Other Languages]

ASP Classic: Filter

In ASP, using ADO, you filter a set of records using the Filter property.

Syntax Example:

objRecordSet.Filter = "ExtEmpType='P'"

[Not specified yet. Coming...]

Find Record

[Other Languages]

Languages Focus

Finding a record is about moving a cursor to a specific record within a set of records (documented here). In addition to finding a record, you can sort, filter, and loop a set of records (documented in their topics).

ASP Classic: Find, Seek

In ASP, using ADO, you use Find and Seek to move a cursor of a RecordSet to a matching record.

Syntax Example:

Given a valid ADO recordset, the following code snippet finds a specific user and prints out their age:

TC.Find " UserID='mprestwood' "
Response.Write TC.Fields("Age")

[Not specified yet. Coming...]

Record Movement

[Other Languages]

Languages Focus

Top, bottom, next, and previous.

ASP Classic: MoveFirst, MoveLast, MoveNext

ASP uses MoveFirst, MoveLast, MoveNext, and MovePrevious to move a database cursor (a RecordSet).

objRecordSet.MoveNext

Syntax Example:

The following snippet moves to the second to last record of a given RecordSet object:

objRecordSet.MoveLast

objRecordSet.MovePrevious

[Not specified yet. Coming...]

Sort Records

[Other Languages]

ASP Classic: Sort

In ASP, using ADO, you sort a set of records using the Sort property.

Syntax Example:

objMembersRS.Sort = "FirstName"

[Not specified yet. Coming...]