change recordset cursor type in DW 8.02

You can't. The recordset returned by a command object (which is what's used
in the 8.02 update) is always a read-only, forward-only, server-side cursor.

If you need to change any of that, don't use the Execute method of the
command object. Construct a recordset with the options you want. Do NOT
set the active connection on the recordset; leave that out. Pass the
command object as the source of the recordset object, then use the
recordset's Open method. That's pretty convoluted, but it lets you retain
the most DW-generated code.

Your other option is to use the recordset object only and plain text
parameters like DW 8.01 rather than a command object with parameter objects
like DW 8.02.

That change was fundamental to the ASP server model and probably should not
have been part of any update, but saved for the next release. It at least
deserved more than a .0x update to the version number. At least call it
8.1.


"riprod7" <webforumsuser@macromedia.com> wrote in message
news:e8jdb6$ou0$1@forums.macromedia.com...
>I have never been more unhappy with an update in my live, I basically have
>to
> learn everything from scratch again with DW 8.02.
>
> When pulling a recrodset you used to be able to set the CursorType in the
> code. That is gone now.
> As a result I cannot use rs.MoveFirst or rs.Move -2 to browse around
> records.
> I get the following error.
>
> Microsoft OLE DB Provider for ODBC Drivers error '80040e24'
> Rowset does not support fetching backward.
>
> How do I change the CursorType in this horrible update! Thanks
>