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 +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 PHP ASP Classic and VB.Net

Cross Ref Guide

ASP CLASSICLANGUAGE

ASP Classic

ASP CLASSICANDVB CLASSICTOC

Overview

+Tool Basics

Report Tools Overview

+Language Basics

+Language Details

+Data Structures

Array

+Statements

+Operators

+Commands

+Database

Find Record◄╣

+OOP Basics

+OOP Details

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

► KB ► To/From Guides ► ASP Classic

Print This

Find Record (ASP Classic and VB Classic Cross Reference Guide)

By Mike Prestwood

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

Database

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

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...]