Sideway BICK BlogSideway BICK BLOG from Sideway

A Sideway to Sideway Home

Link:http://output.to/sideway/default.asp?qno=130500015

ActiveX Data Objects Component (ADO), ASP Server Component, Built-in Function

ASP Server Components

The ASP built-in server components are provided to enhance the usability of ASP technology by adding some built-in components to increase the fundamental capability of ASP technology for creating dynamic and interactive web pages. The two basic built-in server components of ASP technology are the FileSystemObject component and the ActiveX Data Object (ADO) component. The FileSystemObject component is used to manipulate the file system of the server while the ActiveX date Object component  is designed for the database manipulation.

ActiveX Data Objects Component

The ActiveX Data Objects, ADO, is one of the key component of the Microsoft/Windows Data Access Components , MDAC/WDAC, for connecting to different data sources. The ActiveX Data Objects, ADO, provide language-neutral object base features for web-based applications to access and manipultate data from a variety of sources through the OLE DB system interfaces. The parent library of ActiveX Data Objects ADO is the  ADODB Library

In general, the five major functions of the ActiveX Data Objects, ADO component is DataBase Connection, DataBase Command, Data Recordset, and Data Record, Data Stream manipulation.

File Name

The ActiveX Data Objects component is included in the ADODB library of Microsoft Data Access Components, MDAC package.

Syntax

Set ADOName = Server.CreateObject("ADODB.IDname")

Parameters

ADOName

The parameter "ADOName" is the name assigned to the instance of the ADO object of the ADODB Library created by the call using the Server.CreateObject.

IDname

The parameter "IDname" is used to specified the name of the type of ADO DataBase object included in the ADODB Library.

Remark

Although an instance of the Connection object of the ADODB Library has higher hierarchical relationship with other ADO objects in the ADODB Library, ADO objects can also be created outside the scope of the ADO hierarchy.

Objects & Collections of ADO Component

The ActiveX Data Object, ADO of the ADODB Library component can be used in the ASP page to manipulate the data of the web server. The two major types of the data manipulation are supported by the ActiveX Data Objects, ADO component. For example, Database manipulation, including database querying, and data manipulating and displaying, Data stream and file manipulation, such as Saving data into an XML file, binary or XML stream, or retrieving an Data stream.

The ActiveX Data Object, ADO of the ADODB Library component consists of a number of objects and collections.

Summary of objects and collection of thep ADODB component is:

Name Type Description
Connection Object An Connection object instance is used to represent a unique session with a data source or an actual network connection to server in a client/server database system.
Command Object An Command object is used to define a specific command for manipulating a data source.
Recordset Object An Recordset object instance is used to represent the entire set of records from a database table query or results of an executed command.
Record Object A Record object instance is used to represent a single row data entity.
Field Object A Field object instance is used to represent a column of data corresponding to a field column in the Recordset.
Fields Collection A Collection of all Field objects of a Recordset or Record object
Parameter Object A Parameter object is used to represent a parameter or argument that associated with a Command object
Parameters Collection A Collection of all Parameter objects of a Command object.
Property Object A Property object is used to represent a characteristic of an ADO object defined by the provider. The Built-in properties are properties defined in ADODB library while the dynamic properties are properties defined by the underlying provider of the ADO object
Properties Collection A Collection of all Property objects for a specific instance of an object.
Error Object A Error object is used to contain details about data access error that pertain to a single operation involving the provider.
Errors Collection A Collection of all Error objects that is created in response to a single provider-related failure.
Stream Object A Stream object is used to represent a stream of binary or text data for further  manipulating.

Objects & Collections of ADO Component

The FileSystemObject, FSO Component consists objects or collections which are the ActiveXObject objects provided by the Microsoft Scripting Run-time for creating ASP pages. And the interactive web application can then be built through the using of these built-in objects in the web pages.sing of these built-in objects in the web pages.

Methods, Properties, Collections and Events of built-in ASP objects.

Parent & Child Relation
Built-in Objects Connection Command Recordset Record Field Parameter Property Error Stream
Methods BeginTrans Cancel AddNew Cancel AppendChunk AppendChunk     Cancel
Cancel CreateParameter Cancel Close GetChunk Delete     Close
Close Execute CancelBatch CopyRecord         CopyTo
CommitTrans CancelUpdate DeleteRecord         Flush
Execute Clone GetChildren         LoadFromFile
Open Close MoveRecord         Open
OpenSchema CompareBookmarks Open         Read
RollbackTrans Delete         ReadText
  Find         SaveToFile
  GetRows       SetEOS
  GetString       SkipLine
  Move       Write
  MoveFirst       WriteText
  MoveLast        
  MoveNext        
  MovePrevious        
  NextRecordset        
  Open        
  Requery        
  Resync        
  Save        
  Seek        
  Supports        
  Update        
  UpdateBatch        
Properties Attributes ActiveConnection AbsolutePage ActiveConnection ActualSize Attributes Attributes Description CharSet
CommandTimeout CommandText AbsolutePosition Mode Attributes Direction Name HelpContext EOS
ConnectionString CommandTimeout ActiveCommand ParentURL DefinedSize Name Type HelpFile LineSeparator
ConnectionTimeout CommandType ActiveConnection RecordType Name NumericScale Value NativeError Mode
CursorLocation Name BOF Source NumericScale Precision Number Position
DefaultDatabase Prepared Bookmark State OriginalValue Size Source Size
IsolationLevel State CacheSize   Precision Type SQLState State
Mode   CursorLocation   Status Value Type
Provider   CursorType   Type
State   DataMember   UnderlyingValue
Version   DataSource   Value
    EditMode  
    EOF  
    Filter  
    Index  
    LockType  
    MarshalOptions  
    MaxRecords  
    PageCount  
    PageSize  
    RecordCount  
    Sort  
    Source  
    State  
    Status  
    StayInSync  
       
Collections Errors Parameters Fields Fields Properties        
Properties Properties Properties Properties
Events

Link:http://output.to/sideway/default.asp?qno=130500014

Attributes / DateCreated / DateLastAccessed / DateLastModified, File Object, ASP Server Component, Built-in Function

File Object

One key function of FileSystemObject Component is the manipulation of files of the file system.

FileObject.Attributes Property

FileObject.Attributes property for file object is a read/write or read-only property depending on the attribute to set and return the attributes of the specified object instance.

Syntax:

FileObjectName.Attributes [=newattributes]

 Or in VBScript. Implyy

fileattributes =FileObjectName.Attributes

FileObjectName.Attributes =newattributes

 Or in JScript. Implyy

fileattributes =FileObjectName.Attributes

FileObjectName.Attributes =newattributes

Parameters:

fileattributes

The parameter "fileattributes" is the name assigned to the string returned by the Attributes property referred to the specified File object.

FileObjectName

The parameter "FileObjectName" is used to specify the name of the instance of the File Object related to.

newattributess

The optional parameter "newattributes" is used to specify the new attributes to be assigned by the Attributes property to the specified File object.

Returns:

bitwise value

The return value of the Attributes property is the logical combination of the bitwise the attribute values of the specified file object instance. The possible bitwise values of the single entry of attributes for any logical combination are.

Valuee Constant Description
0 Normal Normal file. No attributes are set.
1 ReadOnly Read-only file. Attribute is read/write
2 Hidden Hidden file. Attribute is read/write
4 System System file. Attribute is read/write
8 Volumn Disk drive volume label. Attribute is read-only.
16 Directory Folder or directory. Attribute is read-only.
32 Archive File Has changed since last backup. Attribute is read/write
1024 Alias Link or shortcut. Attribute is read-only.
2048 Compressed Compressed file. Attribute is read-only

Remarks:

FileObjectName refers to a File Object.  And Folder object is another possible alternate object for the Attributes property.

Examples:

  • Example of using the Attributes property to get and set the attributes of the specified file.

    ASP VBScript command::

    <script runat="server" language="VBScript">
    Dim fso, FileObjectName, fileattributes
    Set fso = CreateObject("Scripting.FileSystemObject"))
    Set FileObjectName = fso.GetFile("d:\temp1\test1.txt")
    fileattributes= FileObjectName.attributes
    Response.Write fileattributes & "<br />"
    FileObjectName.Attributes = FileObjectName.Attributes-2
    Response.Write FileObjectName.Attributes & "<br />"
    </script>;

    HTML web page output

    3
    1

  • Example of using the Attributes property to get and set the attributes of the specified file.

    ASP JScript command:

    <script runat="server" language="JScript">
    var fso, FileObjectName, fileattributes;
    fso = new ActiveXObject("Scripting.FileSystemObject");
    FileObjectName = fso.GetFile("d:\\temp1\\test1.txt");
    fileattributes = FileObjectName.Attributes
    Response.Write (fileattributes+ "<br />");
    FileObjectName.Attributes = FileObjectName.Attributes-2
    Response.Write (FileObjectName.Attributes+ "<br />");
    </script>;

    HTML web page output

    3
    1

FileObject.DateCreated Property

FileObject.DateCreated property for file object is a read-only property to get and return the date and time of the specified object instance was created.

Syntax:

FileObjectName.DateCreated

 Or in VBScript. Implyy

filedatecreated =FileObjectName.DateCreated

 Or in JScript. Implyy

filedatecreated =FileObjectName.DateCreated

Parameters:

filedatecreated

The parameter "filedatecreated" is the name assigned to the date and time returned by the DateCreated property referred to the specified File object.

FileObjectName

The parameter "FileObjectName" is used to specify the name of the instance of the File Object related to.

Returns:

date

The return value of the DateCreated property is the date and time of the created time of the specified file object instance.

Remarks:

FileObjectName refers to a File Object.  And Folder object is another possible alternate object for the DateCreated property.

Examples:

  • Example of using the DateCreated property to get and return the created time of the specified file.

    ASP VBScript command:

    <script runat="server" language="VBScript">
    Dim fso, FileObjectName, filedatecreated
    Set fso = CreateObject("Scripting.FileSystemObject"))
    Set FileObjectName = fso.GetFile("d:\temp1\test1.txt")
    filedatecreated= FileObjectName.DateCreated
    Response.Write filedatecreated & "<br />"
    </script>;

    HTML web page output

    11/5/2013 11:09:02

  • Example of using the DateCreated property to get and return the created time of the specified file.

    ASP JScript command:

    <script runat="server" language="JScript">
    var fso, FileObjectName, filedatecreated;
    fso = new ActiveXObject("Scripting.FileSystemObject");
    FileObjectName = fso.GetFile("d:\\temp1\\test1.txt");
    filedatecreated = FileObjectName.DateCreated
    Response.Write (filedatecreated+ "<br />");
    </script>;

    HTML web page output

    Sat May 11 11:09:02 UTC+0800 2013

FileObject.DateLastAccessed Property

FileObject.DateLastAccessed property for file object is a read-only property to get and return the date and time of the specified object instance was last accessed.

Syntax:

FileObjectName.DateLastAccessed

 Or in VBScript. Implyly

filelastaccessed =FileObjectName.DateLastAccessed

 Or in JScript. Implyly

filelastaccessed =FileObjectName.DateLastAccessed

Parameters:

filelastaccessed

The parameter "filelastaccessed" is the name assigned to the date and time returned by the DateLastAccessed property referred to the specified File object.

FileObjectName

The parameter "FileObjectName" is used to specify the name of the instance of the File Object related to.

Returns:

date

The return value of the DateLastAccessed property is the date and time of the last accessed time of the specified file object instance.

Remarks:

FileObjectName refers to a File Object.  And Folder object is another possible alternate object for the DateLastAccessed property.

microsoft.com: "This method depends on the underlying operating system for its behavior. If the operating system does not support providing time information, none will be returned. "t;

Examples:

  • Example of using the DateLastModified property to get and return the last accessed time of the specified file.

    ASP VBScript command:

    <script runat="server" language="VBScript">
    Dim fso, FileObjectName, filelastaccessed
    Set fso = CreateObject("Scripting.FileSystemObject");)
    Set FileObjectName = fso.GetFile("d:\temp1\test1.txt")
    filelastaccessed= FileObjectName.DateLastAccessed
    Response.Write filelastaccessed & "<br />"
    </script>t;

    HTML web page output

    14/5/2013 12:23:36

  • Example of using the DateLastModified property to get and return the last accessed time of the specified file.

    ASP JScript command:

    <script runat="server" language="JScript">
    var fso, FileObjectName, filelastaccessed;
    fso = new ActiveXObject("Scripting.FileSystemObject"); ;
    FileObjectName = fso.GetFile("d:\\temp1\\test1.txt");
    filelastaccessed = FileObjectName.DateLastAccessed
    Response.Write (filelastaccessed+ "<br />");
    </script>t;

    HTML web page output

    Tue May 14 12:23:36 UTC+0800 2013

FileObject.DateLastModifieded Property

FileObject.DateLastModified property for file object is a read-only property to get and return the date and time of the specified object instance was last modified.

Syntax:

FileObjectName.DateLastModified

 Or in VBScript. Imply

filelastmodified =FileObjectName.DateLastModified

 Or in JScript. Imply

filelastmodified =FileObjectName.DateLastModified

Parameters:

filelastmodified

The parameter "filelastmodified" is the name assigned to the date and time returned by the DateLastModified property referred to the specified File object.

FileObjectName

The parameter "FileObjectName" is used to specify the name of the instance of the File Object related to.

Returns:

date

The return value of the DateLastModified property is the date and time of the last modified time of the specified file object instance.

Remarks:

FileObjectName refers to a File Object.  And Folder object is another possible alternate object for the DateLastAccessed property.

Examples:

  • Example of using the DateLastModified property to get and return the last modified time of the specified file.

    ASP VBScript command:

    <script runat="server" language="VBScript">
    Dim fso, FileObjectName, filelastmodified
    Set fso = CreateObject("Scripting.FileSystemObject")
    Set FileObjectName = fso.GetFile("d:\temp1\test1.txt")
    filelastmodified= FileObjectName.DateLastModified
    Response.Write filelastmodified & "<br />"
    </script>

    HTML web page output

    4/4/2013 19:34:30

  • Example of using the DateLastModified property to get and return the last modified time of the specified file.

    ASP JScript command::

    <script runat="server" language="JScript">
    var fso, FileObjectName, filelastmodified;
    fso = new ActiveXObject("Scripting.FileSystemObject");
    FileObjectName = fso.GetFile("d:\\temp1\\test1.txt");
    filelastmodified = FileObjectName.DateLastModified
    Response.Write (filelastmodified+ "<br />");
    </script>

    HTML web page output

    Thu Apr 4 19:34:30 UTC+0800 2013

Previous Month  MAY  2013  Next Month
SMTWTFS
1234
567891011
12131415161718
19202122232425
262728293031

Previous Month  JAN  2011  Next Month
SMTWTFS
1
2345678
9101112131415
16171819202122
23242526272829
3031

Sideway BICK Blog

14/05


Copyright © 2000-2020 Sideway . All rights reserved Disclaimerslast modified on 26 January 2013