Hello all!

I'm using the command object referenced in chapter 14 of Beginning Active Server Pages 3.0. Everything runs and returns correctly using this code.
<%
  Option Explicit
  Dim strConnect, strParcel, CYear, Cyear1
  strParcel = "0808E-02-059.000"
  CYear = Year(Now()) - 1
  CYear1 = Year(Now()) - 2
%>

<!-- METADATA TYPE="typelib"
              FILE="c:\program files\common files\system\ado\msado15.dll" -->
<%
  Dim objRS, objComm

  Set objComm = Server.CreateObject("ADODB.Command")
  objComm.ActiveConnection = strConnect
  objComm.CommandText = "SELECT ppin, parcel_number FROM ITDLRC01 WHERE parcel_number = '" & strParcel & "'" & _
                        " AND tax_year = " & CYear
  objComm.CommandType = adCmdText
  Set objRS = objComm.Execute
  Set objComm = Nothing

  If objRS.EOF Then
    Response.Write "Nothing Found"
  Else
  Do While Not objRS.EOF
    Response.Write objRS("ppin") & "<br>"
  objRS.MoveNext
  Loop
  End If

  objRS.Close
  Set objRS = Nothing
%>

What I would like to be able to do is change the cursor type to obtain the last record found. I've done some searching on this, and here's what I found.

"If you need to use a command, and require a different cursor or lock type, then you should use the Open method of the Recordset, but use the Command as the source of the Recordset. For example:

  cmdAuthors.ActiveConnection = strConn
  cmdAuthors.CommandText = "Authors"
  cmdAuthors.CommandType = adCmdTable
  rsAuthors.Open cmdAuthors, , adOpenDynamic, adLockOptimistic"

However, when I try to use this method I get an error "Object Required:" with no specification.

Please help!!!

Hello Hcweb,

I was looking for the same thing, but I came across this at Microsoft:
http://msdn.microsoft.com/library/de...asp?frame=true

Using the Execute method on a Connection object executes whatever query you pass to the method in the CommandText argument on the specified connection. If the CommandText argument specifies a row-returning query, any results that the execution generates are stored in a new Recordset object. If the command is not intended to return results (for example, an SQL UPDATE query) the provider returns Nothing as long as the option adExecuteNoRecords is specified; otherwise Execute returns a closed Recordset.

[u]The returned Recordset object is always a read-only, forward-only cursor. If you need a Recordset object with more functionality, first create a Recordset object with the desired property settings, then use the Recordset object's Open method to execute the query and return the desired cursor type.</u>

The contents of the CommandText argument are specific to the provider and can be standard SQL syntax or any special command format that the provider supports.

An ExecuteComplete event will be issued when this operation concludes.

Note URLs using the http scheme will automatically invoke the Microsoft OLE DB Provider for Internet Publishing. For more information, see Absolute and Relative URLs.

I came up with a work around using some logic instead of using objRS.MovePrevious command.

I hope this helps.

Thanks for the response. For some reason, I am drawn to using Command. Don't know why....