sqlobject-discuss

[SQLObject] _LikeQuoted(string) + '%'

[Oleg B. <ph...@ph...>]

Hi!

>   File "sqlbuilder.py", line 549, in STARTSWITH
> TypeError: unsupported operand type(s) for +: 'instance' and 'str'

def STARTSWITH(expr, string):
    return SQLOp("LIKE", expr, _LikeQuoted(string) + '%')

_LikeQuoted is a class. How it is supoosed to work with "+"?
   (also in ENDSWITH and CONTAINSSTRING).

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

[SQLObject] Re: _LikeQuoted(string) + '%'

[Oleg B. <ph...@ph...>]

On Tue, Nov 23, 2004 at 02:56:13PM +0300, Oleg Broytmann wrote:
> >   File "sqlbuilder.py", line 549, in STARTSWITH
> > TypeError: unsupported operand type(s) for +: 'instance' and 'str'
> 
> def STARTSWITH(expr, string):
>     return SQLOp("LIKE", expr, _LikeQuoted(string) + '%')
> 
> _LikeQuoted is a class. How it is supoosed to work with "+"?
>    (also in ENDSWITH and CONTAINSSTRING).

   Simple but probably dumb fix attached.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.

[SQLObject] Re: _LikeQuoted(string) + '%'

[Oleg B. <ph...@ph...>]

Hello!

   Please be warned :) everyone that I've got write access to the
Subversion repository, and I am going to fix bugs, push minor patches,
experiment with major design changes.

On Wed, Nov 24, 2004 at 03:54:08PM +0300, Oleg Broytmann wrote:
> On Tue, Nov 23, 2004 at 02:56:13PM +0300, Oleg Broytmann wrote:
> > >   File "sqlbuilder.py", line 549, in STARTSWITH
> > > TypeError: unsupported operand type(s) for +: 'instance' and 'str'
> > 
> > def STARTSWITH(expr, string):
> >     return SQLOp("LIKE", expr, _LikeQuoted(string) + '%')
> > 
> > _LikeQuoted is a class. How it is supoosed to work with "+"?
> >    (also in ENDSWITH and CONTAINSSTRING).
> 
>    Simple but probably dumb fix attached.

   The patch has been applied. Ian, please close it on SF.

Oleg.
-- 
     Oleg Broytmann            http://phd.pp.ru/            ph...@ph...
           Programmers don't die, they just GOSUB without RETURN.