Returning a recordset from a database
Previous:
Connecting to a database
To return a recordset to the browser you would use the Recordset object.
<html> <head> <title> </title> </head> <body> <% Set cn = Server.CreateObject("ADODB".Connection") cn.Open "Company" Set rs =cn.Execute "SELECT FirstName,LastName FROM Employees" rs.MoveFirst Do While Not rs.EOF Response.Write " First Name : " & rs("FirstName") & " Last Name: " & rs("LastName") & "<BR>" rs.Movenext Loop %> </body> </html> |
Asp Discussion
- - How to upload files
- - Offshore outsourcing comp
- - Example of editing in Dat
- - Example of Inserting and
- - Example of Image Upload
