ADO Queries

« Previous Chapter Next Chapter »

We may use SQL to create queries to specify only a selected set of records and fields to view.

Display Selected Data

We want to display only the records from the "Customers" table that have a "Companyname" that starts with an A (remember to save the file with an .html extension):



set conn=Server.CreateObject("ADODB.Connection")
conn.Open "c:/webdata/northwind.mdb"

set rs=Server.CreateObject("ADODB.recordset")
sql="SELECT Companyname, Contactname FROM Customers
WHERE CompanyName LIKE 'A%'"
rs.Open sql, conn

<table border="1" width="100%">
  <%for each x in rs.Fields
    response.write("<th>" & & "</th>")
  <%do until rs.EOF%>
    <%for each x in rs.Fields%>


« Previous Chapter Next Chapter »

Have Any Suggestion? We Are Waiting To Hear from YOU!

Your Query was successfully sent!