[Zope] bug with SQL methods? (addtl info)

Jordan B. Baker jbb@spyderlab.com
Fri, 5 Mar 1999 16:45:56 -0500 (EST)


Continuing this great tradition of responding to my own posts :)

On Fri, 5 Mar 1999, Jordan B. Baker wrote:

> argdata was {'sql_delimiter': '\000', 'client': '1', 'pend': '1',
> 'pstart': '1', 'sql_quote__': }

> This is starting to confuse me because simple queries work fine within
> Zope, its only the query that I posted in my previous message that seems
> to be fowling things up.

Okay, now it makes sense.

Is 'client' a reserved variable?

If so, perhaps a warning would be nice if you attempt to use a reserved
variable as an argument to a SQL method.

Argh.. so I got that fixed and now I am getting another traceback when
testing the SQL method!

I can't believe it :)

Here it is:

Error, exceptions.KeyError: unhandled 

<!-- Traceback (innermost last):
  File lib/python/ZPublisher/Publish.py, line 877, in publish_module
  File lib/python/ZPublisher/Publish.py, line 590, in publish
    (Info: spyderwatch/sql_period_report/manage_test)
  File ../lib/python/Shared/DC/ZRDB/DA.py, line 305, in manage_test
    (Object: CopySource)
  File ../lib/python/Shared/DC/ZRDB/DA.py, line 286, in manage_test
    (Object: CopySource)
  File ../lib/python/Shared/DC/ZRDB/DA.py, line 390, in __call__
    (Object: CopySource)
  File lib/python/Products/ZMySQLDA/db.py, line 191, in query KeyError:
(see above)
-->

-jordan.