[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