ADO and SQL

Home >> ADO >> ADO and SQL

ADO and SQL

With SQL, data to be displayed in an HTML page can be filtered and sorted.

Examples

Display only selected records

This example demonstrates how to display data that matches a certain criteria.

Sort the records on a specified fieldname

This example demonstrates how to sort the data on a specified fieldname.

Display Selected Data

set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0"

conn.Open "c:/webdata/northwind.mdb"

set rs=Server.CreateObject("ADODB.recordset")

sql="SELECT * FROM Customers WHERE CompanyName LIKE 'A%'"

rs.Open sql, conn %>

<%do until rs.EOF%>

<tr>

<%for each x in rs.Fields%>

<%next

rs.MoveNext%>

</tr>

<%loop rs.close conn.close %>

</table>

Sort the Data

set conn=Server.CreateObject("ADODB.Connection") conn.Provider="Microsoft.Jet.OLEDB.4.0"

conn.Open "c:/webdata/northwind.mdb"

set rs=Server.CreateObject("ADODB.recordset")

sql="SELECT * FROM Customers ORDER BY CompanyName"

rs.Open sql, conn %>

<%do until rs.EOF%>

<tr>

<%for each x in rs.Fields%>

<td>

<%Response.Write(x.value)%>

</td>

<%next

rs.MoveNext%>

</tr>

<%loop

rs.close

conn.close %>

</table>

Open Directory Site ADO Tutorials