I'm using command object and I want to be able to display the records found in the SELECT statement in the recordset

so I perform the following: let's say strSQL is my SELECT string

objCommand.CommandText = "SELECT PRICE, NAME .....etc"

Set objRS = objCommand.Execute totalRecordsFound

This gives me an error. how can i get the total records in the recordset once the objCommand is executed??

thx

If you use a cursor type other than forward-only you can use the RecordCount property e.g.
HTH,

Chris

how can i specify a cursor type if i'm using command object, not connection?. when i'm using a connection object i would do it like this:

objRS.Open = "SElect ...etc", strConnect, adOpenStatic, adLock....

but with a connection you do this:

Set objRS = objCommand.Execute


so where would i specify the cursor type when using a Command Object?

You can open a recordset with the command object as the source parameter e.g.
HTH,

Chris

yes, but what if i don't want to use connection object, i want to use command object instead. where do i specify the cursor type in this?

set objRS = objCommand.Execute

The code I posted above does not pass a connection object to the Open() call, it passes a command object.

It does the equivalent of the command Execute() call but allows you to specify additional parameters, in this case the cursor type.

awesome, thank you. will try tonight.

nope, this still doesn't work. here's my code, maybe this will help

<%
    Dim totRec 'total number of records
    Dim rsFaq 'recordset
    Dim objCommand 'command object
    Set objCommand = Server.CreateObject("ADODB.Command") 'create command

    'fill command properties
    objCommand.ActiveConnection = strConnect
    objCommand.CommandText = "INSERT INTO faq(QUESTION, ANSWER) VALUES ('new question10?', 'new answer10')"
    objCommand.CommandType = adCmdText
    'execute insert command
    objCommand.Execute

    'execute command
    objCommand.CommandText = "SELECT * FROM FAQ"

    rsFaq.Open(objCommand, , adOpenStatic)
    totRec = rsFaq.RecordCount

    'clean up command object
    Set objCommand = Nothing

    '-----------------------------------------------------------
    'display all records
    Do While NOT rsFaq.EOF
        Response.Write (rsFaq("Question") & "<br>")
        Response.Write rsFaq("Answer") & "<br>"
        rsFaq.MoveNext
    Loop
    Response.Write("<BR>" & "Total number of records: " & totRec)
    '------------------------------------------------------------

    'if no records are found
    If rsFaq.BOF Then
        Response.Write("No records found in the database")
    End if

    'close recordset
    rsFaq.Close
    Set rsFaq = Nothing
%>

You need to create rsFaq as a recordset before you open it and if you're using parentheses on the Open() call, add "Call" before it, so change the line
to

simply you can try this


set cn=server.CreateObject("adodb.connection")
set rs=server.CreateObject("adodb.recordset")
cn.ConnectionString="............" // connection string
cn.Open


rs.Open "SELECT * FROM tabename",cn,3,1

rs.PageSize=10000 // optional page length

Response.Write("Total No of Records = "& rs.RecordCount&"<br>")


regards

Mateen