[Zope] Zope and ODBC

[Roland Reumerman]

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