[Zope-DB] Error Value: 'in' or 'not in' needs sequence right argument

[hawelek_tlen]

Hi Charlie,

I know that I should limit dynamic SQL statement,  but I cannot,
I try to do this your way (PythonScript),I allowed module
Products.ZSQLMethods.SQL
to be enabled for use by scripts and then I run script:
I become this message:

Error Type: TypeError
Error Value: 'in' or 'not in' needs sequence right argument


so I stopped my work, and tried to find some solution for it,
thats why I wrote this message again,
thanks fo your help,
I hope that I'm not to oppressive yet,

best regards
Adam

----- Original Message -----
From: "Charlie Clark" <charlie at egenix.com>
To: "hawelek_tlen" <hawelek at tlen.pl>
Cc: <zope-db at zope.org>
Sent: Thursday, April 22, 2004 3:59 PM
Subject: Re: [Zope-DB] Error Value: 'in' or 'not in' needs sequence right
argument


> Adam,
>
> I originally suggested you do this based on a suggestion made to me on the
> list. Please check the archives for the full details. I personally think
> that this not the best way to do things and that depending on your DA an
> external method might be preferable - this is certainly possible with
> mxODBCZopeDA
>
> Note that the general opinion seems to be that you should limit the number
> of dynamic SQL statements where possible in order to be able to test and
> maintain things better.
>
> There also some Zope Products which might do what you want already:
> ZNolkSQLWizard for example.
>
> Charlie
>
> On 2004-04-22 at 15:33:51 [+0200], hawelek_tlen wrote:
> > Hi,
> >
> > Problem is that, I don't want to do only Select-query, but all sql-query
> > (insert, create ...),
> >
> > If I try to do it in your way, than I have to give to PythonScript whole
> > sql-query,
> >
> > It have no sense, better thing is to give this sql-query direct to
> > ZSQLMethod, but I don't want to do this because, everyone can do this
then,
> --
> Charlie Clark
> eGenix.com
>
> Professional Python Services directly from the Source
>  >>> Python/Zope Consulting and Support ...        http://www.egenix.com/
>  >>> mxODBC.Zope.Database.Adapter ...             http://zope.egenix.com/
>  >>> mxODBC, mxDateTime, mxTextTools ...        http://python.egenix.com/
> ________________________________________________________________________
>
> ::: Try mxODBC.Zope.DA for Windows,Linux,Solaris,FreeBSD for free ! ::::