Jeff, In the SQL Server realm, a cursor is typical of a stored procedure that has a loop structure. Without using while loops and table variables, cursors used to be the defacto way to loop over logic in complex stored procedures.
Teddy R. Payne, ACCFD Google Talk - [email protected] On Thu, Jan 20, 2011 at 2:34 PM, Jeff Howard <[email protected]> wrote: > Hey all, > > I've got a client that I do some maintenance work for on a VERY old CF > site. They have a CMS that is throwing an error when trying to add > content. The servers have changed, the databases have been updated, the > system runs across 3 different servers so I'm not sure where along the way > the system "broke" > > I am getting the following error message on a server running CFMX7 and I > believe MSSQL that was recently updated from 2003 to 2005 (possibly 2008): > > Error Executing Database Query. > [Macromedia][SQLServer JDBC Driver][SQLServer]Could not complete cursor > operation because the set options have changed since the cursor was > declared. > > > Any ideas on where to begin with this and possible culprits? > > Thanks in advance, > Jeff >
