On Mon, Feb 05, 2001 at 01:36:50PM -0700, Steve Ruby wrote:
> Henrik Lebtien Mohr wrote:
> >
> > Hi there
> >
> > I use ASP and ADO 2.5 to access the data in my MySQL RDBMS.
> > I get an error "Multiple-step error" when I try to update a recordset like
> > the following:
> >
> > with rs
> > .fields("date") = null 'timestamp datatype
> > .fields("nOnline") = .fields("nOnline") + 1 'int datatype
> > .update
> > end with
>
> There is no server-side cursor handling on mysql so unless you
> are using something other than MyODBC to emulate cursors you must
> treat all recordsets as static.
It _ought_ to be possible to persuade ADO to persaude the ODBC driver
manager to enable the use of the standard ODBC cursor library for that
connection.
No idea how though.
Tim.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
