ado connections

[jlynch1]

what is the difference between these connections to a database ?

Server.CreateObject("ADODB.Connection&quot
Server.CreateObject("ADODB.Recordset&quot

this is the code that i use to connect to the database

set objConn = Server.CreateObject("ADODB.Connection&quot
objConn.ConnectionString = "DSN=**;uid=**;pwd=**"
objConn.Open

Set objRS = objConn.Execute(strSQL)

i want to set up a paging system to show 5 records on each page

any help appreciated

 

[durug]

Check this thread. It a code sample how to return efficient 5 or how many you need records on a page
thread333-249800

For difference between different connections and return
check this:

http://www.devguru.com/Technologies/ado/quickref/ado_intro.html

 

[jlynch1]

thanks for the help durug