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.