How to use ASP to issue the SELECT statement to SQL Server

How to use ASP to issue the SELECT statement to SQL Server

Use ASP to issue the SELECT statement to SQL Server

You need to create a ADO recordset and then open the recordset using the open statement with the SQL statement in it.

This is an example of how you should do it.

Set rs = Server.CreateObject("ADODB.Recordset") ‘ creates the recordset

Sqlstr = "SELECT * from employee"

rs.open Sqlstr, conn, 1,3