The DDL and query were really nothing special. The database I connected to is an Oracle 8.0.5 installation. I created the table with SQL*Plus: create table zopetest( id number(9), name varchar2(255)); followed by a few inserts (and checked with a select). Then I typed the following on the Test tab page: select * from zopetest and clicked on the Submit Query button. The Browse Option in Zope works fine. Any other queries I tried, with different attributes, tables and even other ZODBC database connections failed exactly the same way.
On 1/20/00 12:29 PM, Roland Reumerman at zope_ddi@hotmail.com wrote:
Some time ago I asked a question about some error I received when trying to do a SQL SELECT query. I didn't receive any reaction on that, and I couldn't find any mention of it on the Zope.org site, so I'll just ask it again..
I was running it on Windows NT 4 SP5, using the ZODBC product on Zope 2.1.2. It returned the following error message: ErrorType: ValueError Error Value: unpack sequence of wrong size
Can you share your query and DDL with us? That would be helpful in knowing what might be the problem.
Chris
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com