Re: Fwd: Re: [Modeling-users] ec.fetch and SQL "in"

[Yannick G. <yan...@sa...>]

=2D----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On July 8, 2003 11:51 am, Sebastien Bigaret wrote:
> > > Thanks and congratulation for this instant implementation !
> > >
> > >  : )
>
> Okay, I'll add this in the next release then. Need to work on some more
> unittests, but the patch itself for QualifierParser and SQLExpression
> will probably remain as-is.

Argh, I think we have a problem when there is only one elem in the
choice list :

<Fault 1: 'Modeling.Adaptor.GeneralAdaptorException:Couldn\'t evaluate=20
expression SELECT t0.id, t0.gl_id, t0.fs2_id FROM FSLINK t0 WHERE (t0.fs2_i=
d=20
NOT IN (4,) AND t0.gl_id LIKE 1). Reason:=20
_mysql_exceptions.ProgrammingError:(1064, "You have an error in your SQL=20
syntax near \') AND t0.gl_id LIKE 1)\' at line 1")'>

I don't think that : "NOT IN (4,)" is legal...

> > Of course it should be documented that this kind of fetch is super
> > simpler to build with:
> >
> >  "val in %s" % repr(list(vallist))
> >
> > repr() of a list spit out exactly the string you want.
>
>   Agreed, but "val in %s"%list(vallist) is a bit shorted, isn't it ;)

Your just too right !

> > BTW there is and option in mailman for the replies to go directly to
> > the list instead of the sender.  I think it would be nice to turn it
> > on...
>
>   Well, yes, but... I won't go into that discussion here :) I did not
> turn it on because I mainly agree with sourceforge's policy (see
> https://sourceforge.net/docman/display_doc.php?docid=3D6693&group_id=3D1 =
and
> the pointers it contains)

After reading it, I must admit that it makes sense.

=2D --=20
Yannick Gingras
Byte Gardener, Savoir-faire Linux inc.
(514) 276-5468

=2D----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.1 (GNU/Linux)

iD8DBQE/CwKLrhy5Fqn/MRARAl2yAJwLLbAutnsDR8YJB+AADyy7h/c88QCfQMlz
tCljmOkVyM259UIIaunFl3s=3D
=3Db/Fl
=2D----END PGP SIGNATURE-----