HOME
ADO Tutorial
ADO HOME
ADO Intro
ADO Connect
ADO Recordset
ADO Display
ADO Query
ADO Sort
ADO Add
ADO Update
ADO Delete
ADO Demo
ADO Speed Up
ADO Objects
ADO Command
ADO Connection
ADO Error
ADO Field
ADO Parameter
ADO Property
ADO Record
ADO Recordset
ADO Stream
ADO DataTypes
ADO Summary
Examples
ADO Examples
Exam
ADO Exam
Selected Reading
Web Statistics
Web Glossary
Web Hosting
Web Quality
W3Schools Forum
Helping W3Schools
|
ADO Open Method
 Complete Record Object Reference
The Open method opens an existing Record object or creates a new file or
directory.
Syntax
Open(source,actconn,mode,createopt,opt,username,psword)
|
| Parameter |
Description |
| source |
Optional. The source parameter may be one of the following:
- An absolute url
- A relative url
- An open Recordset
- Another Record object
- A Command object
- An SQL SELECT statement
- A table name
|
| actconn |
Optional. A connection string or a Connection object
|
| mode |
Optional. A ConnectModeEnum
value, that indicates the access mode of the Record object. Default is adModeUnknown
|
| createopt |
Optional. A RecordCreateOptionsEnum value, that
indicates whether an existing file/directory should be opened, or a new file/directory should be created.
Default is adFailIfNotExists. This parameter will be ignored if the source parameter
is not a URL
|
| opt |
Optional. One or more RecordOpenOptionsEnum
values, that specifies the options for opening the Record.
Default is adOpenRecordUnspecified
|
| username |
Optional. A user ID that authorizes access to source
|
| psword |
Optional. A password that verifies the username
|
Example
|
Example 1: source as the URL of a folder:
set rec = Server.CreateObject("ADODB.record")
rec.Open("http://www.w3schools.com/ado/")
Example 2: source as a relative URL in a Connection object:
set conn=Server.CreateObject("ADODB.Connection")
set rec = Server.CreateObject("ADODB.record")
conn.Open "URL=http://www.w3schools.com/ado/"
rec.Open("test.doc", conn)
Example 3: source as a row in a Recordset object:
set rs = Server.CreateObject("ADODB.recordset")
set rec = Server.CreateObject("ADODB.record")
rs.Open "test.doc", "URL=http://www.w3schools.com/ado/",,,adCmdTableDirect
rs.MoveLast()
rec.Open(rs)
|
ConnectModeEnum Values
| Constant |
Value |
Description |
| adModeUnknown |
0 |
Default. Permissions have not been set or cannot be
determined |
| adModeRead |
1 |
Read-only |
| adModeWrite |
2 |
Write-only |
| adModeReadWrite |
3 |
Read/write |
| adModeShareDenyRead |
4 |
Prevents others from opening a connection with read
permissions |
| adModeShareDenyWrite |
8 |
Prevents others from opening a connection with write
permissions |
| adModeShareExclusive |
12 |
Prevents others from opening a connection |
| adModeShareDenyNone |
16 |
Allows others to open a connection with any permissions |
| adModeRecursive |
0x400000 |
Used with adModeShareDenyNone, adModeShareDenyWrite, or
adModeShareDenyRead to set permissions on all sub-records of the current
Record |
RecordCreateOptionsEnum Values
| Constant |
Value |
Description |
| adFailIfNotExists |
-1 |
Default. Fails if the source parameter points
to a node that not exists |
| adCreateNonCollection |
0 |
Creates a new Record of type adSimpleRecord |
| adCreateCollection |
0x2000 |
Creates a new Record specified by the
source parameter. If it points to an existing node, an error
will occur. To prevent the error combine this value with adOpenIfExists or
adCreateOverwrite |
| adOpenIfExists |
0x2000000 |
If the source points to an existing
node or Record object, then the provider
must open the existing Record instead of creating a new one. This value cannot be used
with adCreateOverwrite |
| adCreateOverwrite |
0x4000000 |
If the source points to an existing
node or Record, then the existing Record will be overwritten
and a new one is created in its place. This value cannot be used with adOpenIfExists |
| adCreateStructDoc |
0x80000000 |
Creates a new Record of type adStructDoc |
RecordOpenOptionsEnum Values
| Constant |
Value |
Description |
| adOpenRecordUnspecified |
-1 |
Default. No options are specified |
| adOpenAsync |
0x1000 |
Opens the Record object in asynchronous mode |
| adDelayFetchStream |
0x4000 |
The default stream
associated with the Record need not be retrieved initially |
| adDelayFetchFields |
0x8000 |
The fields associated
with the Record need not be retrieved initially, but can be
retrieved at the first attempt to access the field |
| adOpenExecuteCommand |
0x10000 |
The source contains command text
that should be executed |
| adOpenOutput |
0x800000 |
If the source points to a node that
contains an executable script, then the opened Record
will contain the results of the executed script. This value is only
valid with non-collection records |
Complete Record Object Reference
 |
 |
 |
 |
|
The Ektron Intranet
lets you do everything you need to do on your corporate intranet and everything you want to do... all with just one application.
What can you do with the Ektron Intranet? |
 |
Navigate through content, documents, assets, colleagues and workgroups quickly and intuitively with enterprise search |
 |
Communicate with friends and colleagues with forums, message boards and corporate blogging using the new Social Networking Platform |
|
Utilize the extensive out-of-the box features or customize your site through Ektron CMS400.NET's open architecture |
 |
Promote collaboration in your organization through project workspaces where others can efficiently find information and work together |
 |
Author/edit content, manage navigation, menus, audit trails, workflow and approvals with the best in breed Content Management |
|
|
|
|
See why there are 20,000+ Ektron integrations worldwide.
|
|
 |
TAKE THE VIDEO TOUR |
 |
or download a FREE TRIAL today. |
|
|
Jump to: Top of Page
or HOME or
Printer friendly page
W3Schools provides material for training only. We do not warrant the correctness of its contents.
The risk from using it lies entirely with the user.
While using this site, you agree to have read and accepted our
terms of use and
privacy policy.
Copyright 1999-2008 by Refsnes Data. All Rights Reserved.
|
|
|
