Nested Select Statements

Jeremy Livingston <[email protected]>
Newsgroups gmane.comp.db.tds.freetds
Message-ID <CACAKNbuts93MUftyitUwzpWD+oiUWvKFAhDwnVNinBgB1v92qQ@mail.gmail.com>
Hello,

I am connecting to a Microsoft SQL Server 2008 database using unixODBC and
FreeTDS on PHP. Everything was going well until the ORM library that I'm
using (Doctrine) attempted to perform a select statement while cycling
through the result set of another query. I received the error:
"SQLSTATE[24000]: Invalid cursor state: 0 [FreeTDS][SQL Server]Invalid
cursor state (SQLExecute[0] at ../pdo_odbc/odbc_stmt.c:254)"

After doing some research, it appears that this behavior is by-design in
FreeTDS (http://www.freetds.org/faq.html#pending). Is this error that I'm
getting because of this implementation detail? If so, are there any plans
to change this behavior? If not, does anyone have any recommendations for a
driver I could use with PHP that would allow this behavior?

Under normal circumstances, I would simply adjust the code myself. However,
since I'm using someone else's library, I don't exactly have this luxury.

Any suggestions are appreciated.
Thank you!
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.