Re: [SQLObject] Help with SQLBuilder NOTIN

[Jason H. <jas...@gm...>]

On 30 March 2010 18:04, Oleg Broytman <ph...@ph...> wrote:
>   The error I can see is the second parameter to Select(). You don't need
> to pass the table class - Select derives it from the item ContItem.q.dbStock.
> The second parameter to Select is WHERE clause; if you don't need it just
> omit it.

Using:

my_selection = dbase.Stock.select(
                    sqlobject.sqlbuilder.AND(
                        dbase.Stock.q.dbStockCode.startswith("XXX"),
                        sqlobject.sqlbuilder.NOTIN(
                                sqlobject.sqlbuilder.Outer(dbase.Stock).q.id,

sqlobject.sqlbuilder.Select(dbase.ContItem.q.dbStock)))

... gives exactly the same error though.

Cheers,
Jason