Hung, This is strange stuff. Have you checked the Sybase transaction log lately? When it gets full, Zope doesn't like that too much. Hung Jung Lu wrote:

Hi,

I am getting a Sybase error while trying to query

select * from myTable

The error message is:

"Error, Products.SybaseDAv2.db.Error: ct_command(): user api layer: external error: This routine cannot be called while results are pending for a command that has been sent to the server."

I can use isql to see the table without problem. This table does contain a few constraint foreign keys, some of them were set to null. Could this be the problem? Or does the error have something to do with transactions? I have tried to restart Zope and Sybase, but the error persists. If, as the error message states, another command has been sent, how can I terminate that command?

thanks in advance,

Hung Jung

______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com

_______________________________________________ Zope maillist - Zope@zope.org http://lists.zope.org/mailman/listinfo/zope ** No cross posts or HTML encoding! ** (Related lists - http://lists.zope.org/mailman/listinfo/zope-announce http://lists.zope.org/mailman/listinfo/zope-dev )

-- Chris McDonough Digital Creations, Inc. Zope - http://www.zope.org