Prev Next

ADO Field

The Field object in ADO represents a column in a Recordset. It provides access to the values and metadata of a specific field, enabling data manipulation and retrieval.

Key Topics

Accessing Field Values

Example

<%
    Dim conn, rs
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.Open "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=MyDatabase;User ID=myUser;Password=myPassword;"

    Set rs = conn.Execute("SELECT EmployeeName, Department FROM Employees")

    Do Until rs.EOF
        Response.Write("Name: " & rs.Fields("EmployeeName").Value & "<br>")
        Response.Write("Department: " & rs.Fields("Department").Value & "<br><br>")
        rs.MoveNext
    Loop

    rs.Close
    conn.Close
    Set rs = Nothing
    Set conn = Nothing
%>

Explanation: This example accesses field values from the Recordset using the Fields collection and displays the employee name and department.

Field Properties

Example

<%
    Dim conn, rs
    Set conn = Server.CreateObject("ADODB.Connection")
    conn.Open "Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=MyDatabase;User ID=myUser;Password=myPassword;"

    Set rs = conn.Execute("SELECT EmployeeName FROM Employees")

    Response.Write("Field Name: " & rs.Fields(0).Name & "<br>")
    Response.Write("Field Type: " & rs.Fields(0).Type & "<br>")
    Response.Write("Field Value: " & rs.Fields(0).Value & "<br>")

    rs.Close
    conn.Close
    Set rs = Nothing
    Set conn = Nothing
%>

Explanation: This example demonstrates how to access the properties of a field, such as its name, type, and value.

Key Takeaways

  • The Field object represents a column in a Recordset.
  • Access field values using the Fields collection.
  • Field properties provide metadata like name, type, and value for each column.
Prev Next