[thelist] Number of records returned (Solution)

Chris Marsh chris at webbtech.co.uk
Thu Aug 15 10:16:01 CDT 2002


[..]

> Set objConn = Server.CreateObject("ADODB.Connection")
> objConn.Open Application("strConn")
> strSQL = "SELECT *** FROM *** WHERE *** = 1"
> Set objRS = objConn.Execute(strSQL)

Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open Application("strConn")
strSQL = "SELECT *** FROM *** WHERE *** = 1"
Set objRS = Server.CreateObject("ADODB.RecordSet")
objRS.ActiveConnection = objConn
objRS.CursorType = 3
objRS.Open strSQL

[..]

Tip owed...

Regards

Chris Marsh





More information about the thelist mailing list